If there are no results...

[D_tunisia]

I have this simple code:

<?php

include ("dbConfig.php");

$result = mysql_query("SELECT * FROM comments WHERE post_id='$id'");

while ($myrow = mysql_fetch_row($result)) {

	printf("%s <b>- %s</b><br><br>",
	$myrow[3], $myrow[1], $myrow[0] );

}

?>

How can I make it so that when no results are returned it will print to screen a message such as "There are no results".

Thanks!

[laserlight]

Use [man]mysql_num_rows/man

<?php
include ("dbConfig.php");

$result = mysql_query("SELECT * FROM comments WHERE post_id='$id'");

if (mysql_num_rows($result) > 0) {
	while ($myrow = mysql_fetch_row($result)) {
		printf("%s <b>- %s</b><br><br>",
			$myrow[3], $myrow[1], $myrow[0]);
	}
}
else {
	echo "There are no results";
}
?>

[D_tunisia]

Thanks! That works great!