how to test for zero 1

[leegold2]

$num_rows = 0;
If ($num_rows = 0) {....}

This does not work, but if I set it to 1 (one) it works. How do I test for zero?

Thanks

 

[kenrbnsn]

You should be writing:

if ($numrows == 0) { ... }

Notice the two equal signs.

Ken

 

[aardvark92]

Just to expand a little on kenrbnsn's answer:

Think of these operators as:

A single equal sign (=) means "becomes".
A double equal sign (==) means "is equivalent to".

So,

if($num_rows = 0)

sets the value of $num_rows to 0. The if statement evaluates 0 as "false". Any nonzero value evaluates to "true" -- that's why the value 1 works but 0 doesn't.

 

[leegold2]

Indeed, thanks for the help...should of known...

 

[Olavxxx]

I would however use:

if (mysql_num_rows($result) > 0)
  {
    // do something
  }
else
  {
    echo "Sorry, no data found!";
  }

Olav Alexander Mjelde

http://www.volvo-power.net

Admin & Webmaster