[SOLVED] Not sure on how to do this, making a total

[Lamez]

ok now I am working on my PM system, and I cannot figure out how to total up the unread messages.

 

My DB:

sender, receiver, received, message, subject

 

so when the user logs in I want them to see how many unreceived messages they have.

 

so something like this?

 

<?php
$r = mysql_query("SELECT * FROM `messages` WHERE `receiver`='$user_' AND `received`='0'");
$total = mysql_num_rows($r);

echo $total;
?>

[Lamez]

lol never mind, I was right I just spelled something wrong