counting search results

[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 would i count the results and display a sequential number at the left of the result, (so it would count up 1-n) ??

also i have tried adding
if ($list=='0') {
print"no records";
}
else { result disply
}

does display results but doesn't print the no records ????

any ideas for both queries ???

thanks

[[deleted]]

Just set a var to zero before you start the while loop,
and print the var like this:

echo $iResultCounter++;

this will print the value, and increase it by one so it will be updated the next time you print it.

if ($list=='0') is wrong, you are comparing a number to a string.

use: if($list==0)

[Anon]

can i display the total before the loop ??

ie can i count the records ???

cheers for any help

[[deleted]]

It seems I was too fast with my previous post..

Look at your code again...
what does it do exactly? (retorical question)

Everything you are asking in your post is already happening in your code.

hint: how does the while look know when to stop?

[Anon]

thanks, i can now see the light