How to count total number of results found in php?

Hello everyone

anyone can please help me I want to show total number of records search by string at the top of my page. Please help me how can I do this?
[FONT=&quot]
Thanks in advance[/FONT]

Not sure if this is gonna help much, your question isn't the most direct!

mysql_query("SELECT * FROM tablename");

is the query to select everything from a table

You can count the number of results using following function

$total_number_of_records = count($fetched_records_from_db);

mysql_num_rows(); in PHP gives the number of rows in the resultset.

you can use count function for counting number of records

first select the database
$total_number_of_records = count($fetched_records_from_db);
insert query display result..

mysql_numrows() function returns the number of rows returned from an fetched SQL.

You can count result in mysql using mysql_num_rows() function.