[SOLVED] MySQL search results display

[richrock]

How would I get the results found (like on the CLI) to display on a webpage?  I'm looking at something similar to Google's results page, eg

 

Results 1 - 10 of about 31,400,000 for goog. (0.07 seconds)

 

Any ideas?

 

And sorry - not sure if this was a php or mysql question...

 

Rich

[Barand]

something like

<?php
mysql_connect ('localhost');
mysql_select_db ('world');

$res = mysql_query("SELECT COUNT(*) FROM city");
$rows = mysql_result($res, 0);

$sql = "SELECT name FROM city ORDER BY name LIMIT 10";
$t1 = microtime(1);
$res = mysql_query($sql);
$t2 = microtime(1);

printf ('Results 1 - 10 of %s for goog. (%0.2f seconds)', number_format($rows,0), $t2-$t1);
?>

[fenway]

You can also use SQL_CALC_FOUND_ROWS().....