help with searching

[Anon]

i have this quick and simple script that searches through my db and produces results ok -

<?
$result = mysql_query("SELECT * FROM ukd WHERE AREA like '%$search%'");
$list = mysql_num_rows($result);
while ($i < $list) {
$row = mysql_fetch_array($result);
$name = $row["NAME"];
print"$name";

$i++;
}
mysql_free_result($result);
?>

how can i do it so that if no records are selected it prints - no records !! try again

also how would i count the results and number the results

thanks

[monkey]

Well you already set the records to $list (With mysql_num_rows). So..
if ($list=="0"){
echo "No records";
} else {
echo "Search returned $list results";
}