MySQL mysql_num_rows();

php mysql mysql-num-rows
wesslayneb picture wesslayneb · Dec 19, 2013 · Viewed 27.5k times · Source

I am not sure as to why. But the code I have created below is not working. The variable: "$num_rows" is not even being set and has no value (not even 0). Anyone know as to why this issue is occurring?

$result2 = mysql_query("SELECT * FROM `mycity_vehicles` WHERE `id` = '$vehID'");
while($row2 = mysql_fetch_array($result2))
$num_rows = mysql_num_rows($result2);
{
    if(empty($num_rows)) {
        echo "empty";
    }
    else {
        echo $num_rows;
    }

Answer

John Conde picture John Conde · Dec 19, 2013

Your syntax is off.

while($row2 = mysql_fetch_array($result2))
$num_rows = mysql_num_rows($result2);
{

should probably be

$num_rows = mysql_num_rows($result2);
while($row2 = mysql_fetch_array($result2))
{

Related questions

With mysql_fetch_array I can easily count the rows returned. Can I do something similar with mysql_fetch_object?

(Apologies if necessary--my first Stack Overflow question. I'll be happy to modify it if anyone has suggestions. I have looked for an answer but I'm afraid my grasp of the terminology isn't good enough to make a complete search.) I'm …

Read More
PHP and MySQL: Number of rows returned

How can I see how many rows the following query returns? mysql_select_db($database_aoldatabase, $aoldatabase); $query1 = "select * from sale where secid = $invoiceno "; $query2 = "select * from sale where secid = $invoiceno "; $maxa = mysql_query ($query1) or die ("Query '$query' …

Read More
Proper way to ask if mysql_num_rows in PHP

Because mysql_num_rows returns false if there are no rows returned, would it be best to do: $query = mysql_query("SELECT id FROM table WHERE something = 'this'"); $result = mysql_num_rows($query); if ($result) { } Or should I do: if ($…

Read More