我想使用PHP函数从数据库中按升序获取数据:
我试过了:
$query = "select * from posts order by DESC LIMIT 0,1200";
$run = mysql_query($query);
while($row=mysql_fetch_array($run)){
$post_id = $row['un_id'];
$title = $row['post_title'];
$image = $row['post_image']; }
一切似乎都很好,直到将顺序从DSEC更改为ASE, PHP生成错误:
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in...
UPDATE:我自己解决了,我更新了问题给以后的访问者
ASE
不存在,是ASC
和DESC
。
尝试这个请求:
$query = "select * from posts order by un_id ASC LIMIT 0,1200";
关键字为ASC
。
ASE
作为关键字不存在
试试:$query = "select * from posts order by ASC LIMIT 0,1200";
因为ASE
不是MySQL关键字
试试ASC
:
$query = "select * from posts order by ASC LIMIT 0,1200";