//// check for messages ////////////////// $res1 = mysql_query("SELECT COUNT(*) FROM messages WHERE receiver=" . $CURUSER["id"] . " AND location IN ('in', 'both')") or print(mysql_error()); $arr1 = mysql_fetch_row($res1); $messages = $arr1[0]; $res1 = mysql_query("SELECT COUNT(*) FROM messages WHERE receiver=" . $CURUSER["id"] . " AND location IN ('in', 'both') AND unread='yes'") or print(mysql_error()); $arr1 = mysql_fetch_row($res1); $unread = $arr1[0]; $res1 = mysql_query("SELECT COUNT(*) FROM messages WHERE sender=" . $CURUSER["id"] . " AND location IN ('out', 'both')") or print(mysql_error()); $arr1 = mysql_fetch_row($res1); $outmessages = $arr1[0]; $res1 = mysql_query("SELECT COUNT(*) FROM messages WHERE receiver=" . $CURUSER["id"] . " && unread='yes'") or die("OopppsY!"); $arr1 = mysql_fetch_row($res1); $unread = $arr1[0]; if ($unread) $inboxpic = "inbox"; else $inboxpic = "inbox";