如何用php获取mysql数据库的行数

Question

i would like to get the number of rows of a mysql database table with one single statement or a function

include "opendatabase.php"; //opens database

while (NUMBEROFROWS > 0){
    //do something
}

the NUMBEROFROWS should be replaced with the statement that returns the number of rows

i already tried to create a function

function getRowNumber(){
    $query = "SELECT COUNT(*) FROM  `votes`";
    $result = mysql_query($query, $connect);

    list($length) = mysql_fetch_row($result);
    return $length;

}

but it does not work if i dont put the include "opendatabase.php"; in it.

what am i doing wrong

Answer 1

$result = mysql_query("SELECT * FROM tablename");

if (mysql_num_rows($result) > 0) {
    // rows found..
}