[SOLVED] Function not working

[Efrem]

 function getNewMailAmt($uid) {
  global $database;
  $q = "SELECT * FROM privmsgs WHERE user_to='$uid' AND read='0'";
  $r = mysql_query($q, $database->connection);
  return mysql_numrows($r);
}

 

Mmmk for the query i can do just

  $q = "SELECT * FROM privmsgs WHERE user_to='$uid'";

And it will work just fine, but when I add the AND, which i really need, it wont work.

 

Any ideas?

 

Also.. There are 3 rows in the DB that this should correspond with.

[PFMaBiSmAd]

read is a reserved word. Either rename your column to something else or encolose it in back-ticks. `read`

[Efrem]

Oh right right, i forgot about that, i had changed it before in the db but forgot about the query. Thanks!

 

- Efrem