[SOLVED] mysql_num_rows error

[MikeDXUNL]

Hi, haven't posted on here in a while but hope some people can help.

 

I have a function:

 

function checkNewMSG($suser) {

$joe = mysql_query("SELECT * FROM messages WHERE to_username = '".$suser."' AND read = 'n'");

$count = mysql_num_rows($joe);

$_SESSION['newmsgs'] = $count;
}

 

 

it says there is an error on line 330.

 

Line 330: $count = mysql_num_rows($joe);

 

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\vgant\incl\functions.php on line 330

 

think someone could help me?

 

Thanks in advance.

- Mike

 

 

 

[pocobueno1388]

That means there is a problem with the query. Put a die to catch the error.

 

$joe = mysql_query("SELECT * FROM messages WHERE to_username = '".$suser."' AND read = 'n'")or die(mysql_error());

[MikeDXUNL]

heh, it's been a while since I coded. forgot to do that but still haven't a clue to how to fix this.

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'read = 'n'' at line 1

[ohdang888]

$joe = mysql_query("SELECT * FROM messages WHERE to_username = '{$suser}' AND read = 'n' ")or die(mysql_error());

[MikeDXUNL]

that's still giving me the same error.

 

edit: SOLVED

 

$joe = mysql_query("SELECT * FROM `messages` WHERE `to_username` = '{$suser}' AND `read` = 'n' ")or die(mysql_error());