[問題] 透過php連到資料庫

看板Flash作者 (小橘)時間16年前 (2009/11/05 22:41), 編輯推噓2(201)
留言3則, 3人參與, 最新討論串1/2 (看更多)
小妹我寫了一個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

11/05 22:52, , 1F
從SQL語法下手,找個欄位來加DESC,倒著排序
11/05 22:52, 1F

11/06 18:29, , 2F
如果還不清楚的話,可以上網找一下 Order by 指令
11/06 18:29, 2F

12/31 09:17, , 3F
select * from Table Order By Table.columns desc;
12/31 09:17, 3F
文章代碼(AID): #1AykFyR9 (Flash)
文章代碼(AID): #1AykFyR9 (Flash)