Whats is wrong with the following code

[inusrat]

echo "$criteria";

if ($criteria =! 0)
{
$string="SELECT * FROM orders where status ='$criteria' LIMIT $start,$numentries ";

echo "$criteria";

}

Before the if statement I get the value "New" for criteria, which is what I should get, but with in the if statemnt it changes to "1", and my sql fails.........

http://www.786Marriage.com

http://www.amasspharma.com

http://www.ambdex.com

 

[rninja]

first of all, you probably meant to change this line around:

if($criteria =! 0)

to

if($criteria !=0)

Hope that helps.

Rninja

http://www.Startegy.net

 

[rockstardub]

Try this...

if ($criteria != 0){
$string="SELECT * FROM `orders` where `status` ='" . $criteria . "' LIMIT $start, $numentries";
echo "$criteria";
}

 

[vbkris]

or:
if ($criteria != "")


Known is handfull, Unknown is worldfull

 

[ericbrunson]

rninja has the right answer.

You typed "if ($criteria =! 0)". The inner part of the if says "assign the value of 'not zero' to $criteria" and "not zero" evaluates to, you guessed it... one.

 

[inusrat]

thanks for your replies it works now

http://www.786Marriage.com

http://www.amasspharma.com

http://www.ambdex.com