Hi,

I want to show the total # of records search by the query string at the top of my page.....Please let me know how can I do this.

Any explaining answer would be highly appreciated.

Thanks A Lot!

If you display all the results on the page, increase a variable every time you display a record.

If you display the results like a pagination, you need to have the query return your results and also the total number, or create another query for the total number of results.

http://www.php.net/manual/en/functio...l-num-rows.php

Originally Posted by voxink

If you display all the results on the page, increase a variable every time you display a record.

If you display the results like a pagination, you need to have the query return your results and also the total number, or create another query for the total number of results.

May you please explain with example.....

As I was trying this.

PHP Code:

$sql_b="select biz_nam, COUNT(biz_id) from tblbusiness where `biz_name` like '$biznam%' and biz_city = '$bizcity'";
        $result_b=mysql_query($sql_b);
        $b=0;
        while($row_b=mysql_fetch_array($result_b))
        {
        $b++;
        } 


Originally Posted by tripy

http://www.php.net/manual/en/functio...l-num-rows.php

Thanks Tripy..........its working........now.

Just remember if you want to paginate the results, mysql_num_rows() will be no use.