mysql_num_rows

mysql_num_rows

Get number of rows in result

Waarschuwing: > mysqli_num_rows``mysqli_stmt_num_rows``PDOStatement::rowCount

 **mysql_num_rows** resource $result

Retrieves the number of rows from a result set. This command is only valid for statements like SELECT or SHOW that return an actual result set. To retrieve the number of rows affected by a INSERT, UPDATE, REPLACE or DELETE query, use . mysql_affected_rows

The number of rows in a result set on successreturn.falseforfailure.

Voorbeeld: example

<?php

$link = mysql_connect("localhost", "mysql_user", "mysql_password");
mysql_select_db("database", $link);

$result = mysql_query("SELECT * FROM table1", $link);
$num_rows = mysql_num_rows($result);

echo "$num_rows Rows\n";

?>

Opmerking: > If you use , will not return the correct value until all the rows in the result set have been retrieved. mysql_unbuffered_query``mysql_num_rows

Opmerking: > info.deprecated.alias

mysql_numrows

mysql_affected_rows``mysql_connect``mysql_data_seek``mysql_select_db``mysql_query