I need abit of help with anouncements on mainmenu
• <a href='ann.php' title='See the announcements.'>";
@$d=mysql_query("SELECT * FROM annoucements WHERE id={$ir['id']} AND id=0",$c);
if (@mysql_num_rows($d) > 0)
{
print "<font color=red>[b]Anouncements (".mysql_num_rows($d).")</font>[/b]";
}
else
{
print "Anouncements(0)";
}
print "</a>
i want it so when i post an announcement it turns red
i think its the query...
any help appreciated