MySQL mysql_num_rows();

Question

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;
    }

You have a brace in the wrong place - you need to move it from the line after $num_rows = mysql_num_rows($result2); to the line before. — andrewsi
– andrewsi, Commented Dec 19, 2013 at 18:41
ok, wasent 100% sure if it was invalid (while being sure it was wrong) or not — user557846
– user557846, Commented Dec 19, 2013 at 18:44
Actually... Aside from a missing trailing brace at the end, I think it's valid syntax. — andrewsi
– andrewsi, Commented Dec 19, 2013 at 18:52

John Conde · Accepted Answer · 2013-12-19 18:41:48Z

2

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))
{

answered Dec 19, 2013 at 18:41

John Conde

220k100 gold badges464 silver badges504 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Orel Eraki · Accepted Answer · 2013-12-19 18:41:59Z

2

You did it the wrong order.

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

answered Dec 19, 2013 at 18:41

Orel Eraki

12.2k4 gold badges31 silver badges38 bronze badges

3 Comments

Funk Forty Niner Over a year ago

I wonder why this got downvoted. If it's because it's the same as John Conde's answer, the reason for it would (probably) be that both answers were given at approximately the same time. (Downvoter, see timestamps).

Orel Eraki Over a year ago

@Fred-ii-, I wonder the same thing.. Probably he has more "Reputation" than me so people feel the need to downvote this, altough I posted mine 6-7 seconds after he did (without knowing it). Anyways it doesn't matter to me as long as the person got the right answer.

Funk Forty Niner Over a year ago

Yes, knowing that the correct answer is given to an OP is indeed the important thing. I will upvote this, because you deserve it just as much AND that you did not deserve the downvote. Cheers ;-)

Collectives™ on Stack Overflow

MySQL mysql_num_rows();

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related