How to Retrieve the Number of Rows in a MySQL Result Set Using PHP

There will come a time when you simply want to run a query just to see the number of rows being returned and not necessarily the data. For instance lets say you are trying to see if a username already exists in the database, if the result returned is greater than zero then you know that username has been taken.

Every programming language has a way to obtain this number and PHP is no different. Here is how you check the number of rows being returned from a MySQL database using PHP.



http://www.ehow.com/how_5167687_retrieve-result-set-using-php.html