Jump to content

mysql_error


fugix

Recommended Posts

can someone enlighten me as to what is wrong with this snippet

$message_sql = "select * from messages where to_id=$id and read='no'";
$message_query = mysql_query($message_sql);
$message_num_rows = mysql_num_rows($message_query);

 

i get this error

PHP Warning:  mysql_num_rows() expects parameter 1 to be resource, boolean given

 

what its basically telling me is that the "read" filed doesnt exist..because when I take it out of my query, the query works fine...however I do have a "read" field in my db with  value of "no" stored in it..so im not sure why its telling me that it doesnt exist..

 

Link to comment
https://forums.phpfreaks.com/topic/235143-mysql_error/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.