echo reveals 1, but follows if statement for 0?

[AimeeAult]

I have a database search. $search comes from post data, as does $type. Whenever I have it echo the number after it does the query, it returns 1, but for some reason it tells me I have no matches. Does anyone have any ideas on what may be going on with this?

if ($type == "E-mail Address"){
$sql = "SELECT * FROM user_driver WHERE driver_email = '$search'";
$result = mysql_query($sql) or die ("#1 err.");
$num = mysql_num_rows($result);
echo($num);
  if ($num == 0) // no matches
     {
     echo ("Sorry, no matches!");
     }
  elseif ($num > 0) // login name not found
    {
    unset($do);
    $message = "Found matches";
    include ("search_form.inc");
    }
  }

Thanks in advance,
Aimee

 

[AimeeAult]

if ($type == "E-mail Address"){
$sql = "SELECT * FROM user_driver WHERE driver_email = '$search'";
$result = mysql_query($sql) or die ("#1 err.");
$num = mysql_num_rows($result);
echo($num);
if ($num == 0) // no matches
{
echo ("Sorry, no matches!");
}
elseif ($num > 0) // login name not found
{
unset($do);
$message = "Found matches";
include ("search_form.inc");
}
}

Sorry about the nbsps

 

[skiflyer]

FYI, you can wrap your code segments in

Tags to have it do the formatting properly for you.

Outside of that... no, I can't imagine why it would echo 1, and then echo Sorry, no matches!

Are you sure something else isn't echo'ing 1?

I like to do
echo "!!!!!".$num."!!!!!";

to make sure I'm not reading a value printed out somewhere else.

If it is indeed still behaving as you say, all I can suggest is to try a debugger (i.e. Zend Studio)

 

[Olavxxx]

for my tired eyes, your code looks o.k.
try this:

if ($num < 1)  // no matches
   {
    echo ("Sorry, no matches!");
   }
else   // login name not found         
   {
   unset($do);                                      
   $message = "Found matches";
   include("search_form.inc");
   }

Olav Alexander Mjelde

http://www.volvo-power.net

Admin & Webmaster

 

[AimeeAult]

Yeah, I tried that. That worked fine for some reason. I've been having weird issues like this lately on my server. Same thing happened with some code for a session variable. Code was fine, didn't work. Oh well.

Thanks for the input

Aimee

 

[Olavxxx]

I think that its some logical error.

If you check for only two values, you can check like I did.

You can also use switch, as it's more structured and easier to read, when debugging.

good luck!

Olav Alexander Mjelde

http://www.volvo-power.net

Admin & Webmaster