Select from DB Not Working?

[dyr]

$inbox = mysql_query("SELECT `status` FROM `inbox` WHERE to_mid = '".$_SESSION['id']."'");
$inbox = mysql_fetch_assoc($inbox);
	{
		if($inbox['status'] == 0){
echo 'NEW<br />'; }

else{ echo 'Old<br />'; }}

 

I'm trying to update my sidebar to tell users when they have new, unread messages or not.  New, unread messages are classified in the inbox table as a status of 0.  How come this code isn't working?  On the actual page the config.php page which connects to the DB is included.

[DanWhite]

mysql_fetch_array instead of assoc maybe? if not, run an "or die(mysql_error))" at the end of the query.

[Barand]

Are you sure $_SESSION['id'] has the value you expect?

[dyr]

$_SESSION['id'] contains the user's ID# in their session, which is the same number as to_mid. 

 

Tried array, to no avail.  :/

[PFMaBiSmAd]

If you are trying to find if there are any new/unread messages, your query would need to be -

 

$query = "SELECT COUNT(*) as num_new FROM inbox WHERE status = 0 AND to_mid = {$_SESSION['id']}";

 

You would then execute that $query statement, fetch the row from the result set, and access the $row['num_new'] value to get the count of the number of new/unread messages for the current user id.