1 Topic by csland (edited by csland 2006-06-14 09:57)

  • Registered: 2006-06-13
  • Posts: 1

Topic: How to show new reports on pages?

Well I ain't very sure if I actually selected the correct forum (Troubleshooting).
I'd like to show the new reports somewhere on my page, but I'd like some help with the code. I don't know
what code(php) I should use. Anyone has any ideas?
Thanks
----------------------------------------

$result_reports = mysql_query ("SELECT COUNT(id) FROM reports WHERE zapped IS NULL"); 
}

if ( mysql_num_rows ( $result_reports ) > 0 ) {
echo "<b><a href=forum/admin_reports.php'>There are new reports</a></b>";
}

Something like that right? It's not working though...
------------------
Edit: I managed to do it....I ask of a mod to close this topic smile