作者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