How do I do this?

[Anon]

I would like to print something like:

'Sorry there is currently no audio of that description in our database' if there are no results found.

I am using the following code to display my results:

<?
$username="username";
$password="password";
$database="database";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query="SELECT * FROM audio WHERE name='$keyword'";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

$i=0;
while ($i < $num) {

$html=mysql_result($result,$i,"html");

echo "$html<br>";

++$i;
}

?>

Any help would be greatly appreciated.

Thanks

Steve.

[Anon]

<?
$username="username";
$password="password";
$database="database";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query="SELECT * FROM audio WHERE name='$keyword'";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

if ($num,1) {
print('Sorry there is currently no audio of that description in our database');
} else {
$i=0;
while ($i < $num) {

$html=mysql_result($result,$i,"html");

echo "$html";

++$i;
}
}

?>

Any help would be greatly appreciated.

Thanks

Steve.

[Anon]

oops - change that to

if ($num <1) {

[Anon]

Excellent thanks very much Craig that worked a treat!

I am new to all this but it is exciting when things start to come together.

BTW You wouldn't know how to display just 5 results and then provide next/prev links would you. I found some example code to do this on this site but was ensure whether I should use it as it had strong arguments againest using it.

Thanks again

Steve.