mysql query

[Jacbey]

Hi Guys,

 

I have been having problems with a piece of PHP and mysql. I was wondering if you could help me out?

 

The error is = Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /customers/klueless.net/klueless.net/httpd.www/daisysite/home.php on line 120 Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /customers/klueless.net/klueless.net/httpd.www/daisysite/home.php on line 122

 

And this is the code which goes with these errors =

 

$msgquery = "SELECT * FROM spotty_messages WHERE (id_receiver = '" . $userid . "') AND read = '0'";

$messageres = mysql_query($msgquery);

$messrow = mysql_fetch_array($messageres);

$messagecount = mysql_num_rows($messageres);	

[smsmarketeers]

Remove the parenthesis in the query:

 

$query = mysql_query("SELECT * FROM spotty_messages WHERE id_receiver = '" . $userid . "' AND read = '0'");
$result = mysql_fetch_array($query);
$rows = mysql_num_rows($result);

[fugix]

or

$query = mysql_query("SELECT * FROM spotty_messages WHERE id_receiver = '{$userid}' AND read = '0'");
$result = mysql_fetch_array($query);
$rows = mysql_num_rows($result);

[mikosiko]

@jacbey: error means that your query is failing, a good reason for that is the usage of a mysql reserved word

 

read is one of them.... 2 options:

a) change the name of the column (the best long term solution) or

b) enclose it in backtics in this way `read`

 

 

[fugix]

good catch mikosiko, i didn't even notice that  :-\

[spiderwell]

and if that column's datatype is int you wont need the single quotes around the zero

 

EDIT or the id_receiver one

[Jacbey]

Thanks guys. I'll try it out and let you know if it works.

[Jacbey]

@jacbey: error means that your query is failing, a good reason for that is the usage of a mysql reserved word

 

read is one of them.... 2 options:

a) change the name of the column (the best long term solution) or

b) enclose it in backtics in this way `read`

 

Thank you, I'll change the column name. How do you get backtics? Because I don't see a key on my keyboard for that.

[spiderwell]

depends on keyboard on my mac its right of the lefthand shift key, on my pc its to the left of 1

 

````````````

 

theres some i given you for free, please copy and paste

[Jacbey]

depends on keyboard on my mac its right of the lefthand shift key, on my pc its to the left of 1

 

````````````

 

theres some i given you for free, please copy and paste

 

Found it on my keyboard, thank you