Mysql_num_rows problem...

Mr_Mako

Hi...

I've got a strange problem and I can't see where it is.

I have my code below for reference.

When I run this code, I'm expecting a "0" (zero) result from the $num_360th variable. I'm getting nothing at all. No number, no nothing.

I was under the understanding that a mysql_num_rows function would yeild an integer result... 0 if it didn't find anything based on the query, and a number greater than 0 if it did find something based on the query.

The query below is SUPPOSED to not find anything... and as a result supposed to yeild a result of 0.

Anyone have any ideas? I'm stumped... 🙁

<?php

// Define Variables //
$db_name = "database";

// Connect to Database //
$connect = @mysql_connect("localhost", "username", "password") or die(mysql_error());
$db = @mysql_select_db($db_name, $connect) or die(mysql_error());

// Create MISSION variable Query //
$mis = "SELECT MAX(mission_no) FROM mission";
$mis_result = @mysql_query($mis, $connect) or die(mysql_error());

while ($row = mysql_fetch_array($mis_result)) {
	$mission = $row['MAX(mission_no)'];
}

$check = "SELECT percentage FROM mission WHERE mission_no = '$mission' AND plane_squadron = '360th'";
$check_result = @mysql_query($check, $connect) or die(mysql_error());

$num_360th = mysql_num_rows($check_result);

echo "<font face=\"Century Gothic\" size=2 color=red><b>ERROR CHECK (num_360th variable) = </b><font color=black>$num_360th</font></font><br>";
echo "<font face=\"Century Gothic\" size=2 color=red><b>ERROR CHECK (mission) = </b><font color=black>$mission</font></font>";

?>

rachel2004

What does an echo of $mission give you?

i.e.:

echo "Value is $mission";
exit();

You don't need to put the exit() in there, but since we're debugging, no sense in going further than finding out what $mission has been assigned at this point.

TheDefender

Unless I am missing something, you don't need to do a while here: (It wouldn't be the first time ;-))

while ($row = mysql_fetch_array($mis_result)) { 
    $mission = $row['MAX(mission_no)']; 
}

You are expecting one value anyhow, so only the row with the MAX(mission_no) is going to be returned.

So, change it to:

$row = mysql_fetch_array($mis_result);
$mission = $row['MAX(mission_no)'];

In any respect, remove your @ symbols so you can get the errors (if any errors are being produced) and make sure all of your queries are running properly too...