Thread: show when there messages

can some one help me with this please so when a member gets a message it shows on the main page

Code:

$allinboxes=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM inbox WHERE ((toid='".getuid_sid($sid)."' AND fwd='0') or (fwd='".getuid_sid($sid)."'))"));
$readinboxes=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM inbox WHERE ((toid='".getuid_sid($sid)."' AND fwd='0') or (fwd='".getuid_sid($sid)."')) AND unread='1'"));
$main.="U have $readinboxes[0] Messsages Of Members<br/>\n";
$allinboxes=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM inbox2 WHERE ((toid='".getuid_sid($sid)."' AND fwd='0') or (fwd='".getuid_sid($sid)."'))"));
$readinboxes=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM inbox2 WHERE ((toid='".getuid_sid($sid)."' AND fwd='0') or (fwd='".getuid_sid($sid)."')) AND unread='1'"));
$main.="U have $readinboxes[0] Messages from staff<br/>\n";

thanks to any one that helps me out with this

Code:

$readinboxes = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM inbox WHERE ((toid='".getuid_sid($sid)."' AND fwd='0') or (fwd='".getuid_sid($sid)."')) AND unread='1'"));
if($readinboxes[0]>0){
$main.="U have $readinboxes[0] Messages from staff<br/>\n";
}

thanks mate works good

thread closed