[SOLVED] Help with Query

[Mundo]

	if (isset($_GET['submit'])) {
	$result = mysql_query(sprintf("SELECT * FROM diary WHERE diary_date = '$_GET[date]' AND diary_staff = 'Matt Black'"));
	if($result != NULL) {
		echo "<h1>Matt Black</h1>";
		while ($row = mysql_fetch_assoc($result)) {
			include "tpl/viewdiary_table.tpl";
			}
		echo "<hr />";
		}

 

I want it to test if the query gets any results and if not, then display nothing... Doesn't seem to work though but i'm sure i've done it right?! Any help?

[Maq]

I like to use:

 

if(mysql_num_rows($result) > 0) {

 

You should also add:

 

or die(mysql_error());

 

at the end of your mysql_query.

[Mundo]

In this instance, what would be the benefit of using mysql_error()?

 

If there is an error, it will just display nothing, surely?

 

Oh and it worked, thanks