function select_message($artID){
$select_message ="select * from message where $artID ";
$result_select =mysql_query($result_message) ;
return($row_select_message =mysql_fetch_array($result_select)); //getpage()取得ID;
$artID=getpage();
$artID="articleID=". $artID;
$row_select_message = select_message($artID);
print_r($row_select_message);/运行后报这样的错误:mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\www\chat\db.php on line 38
$select_message ="select * from message where $artID ";
$result_select =mysql_query($result_message) ;
return($row_select_message =mysql_fetch_array($result_select)); //getpage()取得ID;
$artID=getpage();
$artID="articleID=". $artID;
$row_select_message = select_message($artID);
print_r($row_select_message);/运行后报这样的错误:mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\www\chat\db.php on line 38
select * from message where articleID =1
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\www\chat\db.php on line 38
数据库不对?$result_select =mysql_query($result_message) or die(mysql_error());
看看
结果为:select * from message where articleID =1 Query was empty难道我打印出来的sql语句格式有错吗?不能查询么?
mysql_query(query,connection)
以后写这样的SQL执行语句最好在后面加上 or die()这样可以更好的判断错误在哪里。
自己对比着看$select_message ="select * from message where $artID ";
$result_select =mysql_query($result_message) ;
$artID = "articleID=1";
$sql = "select * from message where $artID" ;
$result = mysql_query($sql);
echo "<pre>";
$row = mysql_fetch_array($result);
print_r($row);
echo "</pre>" ;但是我这样又不可以了,求解:
$artID=getpage() ;
$sql="select * from message where articleID=1";
$row_select_message = select_message($sql);//函数function select_message($sql){
$select_message = $sql;
echo $select_message;
$result_select =mysql_query($result_message) or die( mysql_error()) ; $row_select_message =mysql_fetch_array($result_select); 为什么呢?
很不解:保存 SQL 指令的变量是 $select_message ,而给查询函数的是 $result_select