作者hsuan1203 (小橘)
看板Flash
標題[問題] 透過php連到資料庫
時間Thu Nov 5 22:40:57 2009
小妹我寫了一個flash
要透過php去連到mysql
不過現在遇到了一點trouble
要麻煩各位大大幫我看一下:)
這裡是我flash的語法
System.useCodepage = true;
var my_lv = new LoadVars();
my_lv.onLoad = function(success) {
if (success) {
for (var i = 0; i<this.count; i++) {
var temp_mc = attachMovie("item_mc", "item_mc"+i, i, {_x:25, _y:60});
trace(temp_mc);
temp_mc.name_txt.text = this["member"+i];
temp_mc.desc_txt.text = this["descr"+i];
temp_mc.addr_txt.text = this["address"+i];
temp_mc.imageholder_mc.loadMovie(this["image"+i]);
temp_mc._y += i*180;
trace(temp_mc._y);
}
} else {
trace("error load text files");
}
};
my_lv.load("php_mysql_data.php");
而接下來這裡是我php裡面的語法
<?php
$connect = mysql_connect("localhost","root","0000");
mysql_select_db("db1", $connect);
$result = mysql_query("SELECT member,descr,address,image FROM member ");
echo $result;
$cant = 0;
while($row=mysql_fetch_array($result)){
echo "member$cant=$row[member]&descr$cant=$row[descr]&address$cant=$row[address]&image$cant=$row[image]&";
$cant++;
}
echo "count=$cant";
?>
現在是從頭開始的一筆一筆的順序顯示
請問各位大大
我該怎麼改寫
才可以讓她從最後一筆開始抓呢?
感激不盡:)
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 163.17.9.238
1F：→ aquarianboy:從SQL語法下手，找個欄位來加DESC，倒著排序 11/05 22:52
2F：推 sextitanic:如果還不清楚的話，可以上網找一下 Order by 指令 11/06 18:29
3F：推 klit1987:select * from Table Order By Table.columns desc; 12/31 09:17