<?
$in_id = $_REQUEST['in_id'];
$mysql_server_name = "localhost";
$mysql_username = "root";
$mysql_password = "1";
$mysql_database = "lyb";
//建立连线————透过(服务器地址,使用名称,密码)
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
$sql = "SELECT * FROM `newinsert` where in_id = " . $in_id . " and order by in_id AESC ";
mysql_select_db($mysql_database,$conn);
mysql_query("SET NAMES 'gbk'");
$result = mysql_query($sql);
while($row = mysql_fetch_row($result))
{
echo "发帖人:".$row[1]."<P>";
echo "标题:".$row[2]."<P>";
echo "发帖内容:".$row[3]."<P>";
echo "发帖时间:".$row[4]."<P>";
echo "<P>-------------------------------------------------------<P>";
?>
<form action="insert.php?in_id=<?php echo $row[0];?>" method="post">
<input type="submit" name="b1" value="回复">
</form>
<?
}
?> Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in D:\AppServ\www\lyb\only.php on line 31
回复人:666先生(小姐)
$in_id = $_REQUEST['in_id'];
$mysql_server_name = "localhost";
$mysql_username = "root";
$mysql_password = "1";
$mysql_database = "lyb";
//建立连线————透过(服务器地址,使用名称,密码)
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
$sql = "SELECT * FROM `newinsert` where in_id = " . $in_id . " and order by in_id AESC ";
mysql_select_db($mysql_database,$conn);
mysql_query("SET NAMES 'gbk'");
$result = mysql_query($sql);
while($row = mysql_fetch_row($result))
{
echo "发帖人:".$row[1]."<P>";
echo "标题:".$row[2]."<P>";
echo "发帖内容:".$row[3]."<P>";
echo "发帖时间:".$row[4]."<P>";
echo "<P>-------------------------------------------------------<P>";
?>
<form action="insert.php?in_id=<?php echo $row[0];?>" method="post">
<input type="submit" name="b1" value="回复">
</form>
<?
}
?> Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in D:\AppServ\www\lyb\only.php on line 31
回复人:666先生(小姐)
错了,
$sql = "SELECT * FROM `newinsert` where in_id = " . $in_id . " order by in_id AESC ";
排序前是没有and
恩,没错,SQL语句错了。
1.order by 前不用加and ,
2.AESC 好像也是不对的,改成desc....
$sql = "SELECT * FROM `newinsert` where in_id = " . $in_id . " order by in_id DESC ";//升序
$sql = "SELECT * FROM `newinsert` where in_id = " . $in_id . " order by in_id ASC ";
order by前不用加and
升序降序单词弄清楚
降序 DESC
升序 ASC