Mysql number of rows returned

[c_pattle]

I was just wondering when you run a mysql query what the easiest way to find out the number of rows returned.  Just so I can do a number of results found on a search.  Thanks. 

[wildteen88]

You'd use mysql_num_rows

[c_pattle]

Thanks.  Is there a list of all of the php/mysql functions such as mysql_num_rows and mysql_fetch_array etc?

[mikosiko]

  In case that you didn't notice... the name of the function that was provided to you is a link to the manual ... here is the whole link  http://www.php.net/mysql_num_rows 

[sasa]

http://php.net/manual/en/ref.mysql.php

[c_pattle]

Thank you.  Also I have another question.  At the moment this is my mysql query

 

$data_sql = "select * from data limit 0, 24";

 

However I want to get the number of all of the rows in the table "data".  There for should I run a the sql ="select * from data" and then use mysql_num_rows on the results of that query and store it in a variable?  However surely this is a bad way of doing it because I am selecting all of the data from a database just to get the number of rows. 

[sasa]

select COUNT(ID) AS num_of_rows from data

this return just number of data (one row)

[DavidAM]

Or, if you have 5.0+ use

select SQL_CALC_FOUND_ROWS * from data limit 0, 24

 

followed by another query

 

SELECT FOUND_ROWS()

 

The second query will return the number of rows that would have satisfied the previous query if the LIMIT was not present.

 

$sql = "select SQL_CALC_FOUND_ROWS * from data WHERE categoryID = 4 limit 0, 24";
$resList = mysql_execute($sql);
$resCnt = mysql_execute("SELECT FOUND_ROWS()");
$row = mysql_fetch_row($resCnt);
$totalAvailable = $row[0];

while ($row = mysql_fetch_assoc($resList)) {
  // Show the data
}

echo "There are " . $totalAvailable . " records available for Category 4";

(I just threw the WHERE clause in to show that it can be used)

[c_pattle]

Cool, thanks for your replies.