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

[hsuan1203 (小橘)]

小妹我寫了一個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
→ aquarianboy:從SQL語法下手，找個欄位來加DESC，倒著排序
推 sextitanic:如果還不清楚的話，可以上網找一下 Order by 指令
推 klit1987:select * from Table Order By Table.columns desc;