Home >Backend Development >PHP Tutorial >order by pid desc加到这个语句的那个位置?该怎么处理
order by pid desc加到这个语句的那个位置?
<!--Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--><?php $sql = "SELECT `subject`, `author`, `fid` ,`first`,`tid`,`pid` FROM `forum_post` WHERE 1 "; $result = mysql_query($sql) or die("查询失败!"); $number = 6; while ($row=mysql_fetch_array($result)) { if ($row['fid'] ==56 && $row['first'] !=0 && $number != 0) { ?> <tr> <td><a href="message/mes.php?id=<?php%20echo%20%24row%5B'pid'%5D;?>"><h3> <?php echo substr($row['subject'],0,64);$number--;?> </h3></a></td> <td><a href="message/mes.php?id=<?php%20echo%20%24row%5B'pid'%5D;?>"><h3> <?php echo substr($row['author'],0,16);?> </h3></a></td> </tr> <?php }}?>