[RESOLVED] Help with $check

[chinclub]

I am trying to create a button that will appear when a member has a new unread message. I know how to do a check in the database and if an item is found it will return an action. Like this:

$check = mysql_num_rows(mysql_query("SELECT * FROM `messages` WHERE  `status`='unread'"));

if($ch == 1){

The problem is there may be many unread messages and if there are more than one the button doesn't show up. What is the correct way to write this so the button will appear if any unread messages are in the database no matter how many?

[NogDog]

You could do...

if($check > 0) {

... or simply ...

if($check) {

However, it might be a bit cleaner and faster to do:

$check = mysql_result(mysql_query("SELECT COUNT(*) FROM `messages` WHERE  `status`='unread'"), 0);
if($check)
{
   // display new messages button
}

[chinclub]

Thanks!!