Mysql select problem

[dpluth]

Hi all,

I'm having a bit of a brain melt. I've got a field in my database called status that is type varchar(9).

My select code looks like this.

$selectsale = "Select * from Items where manufacturer = '$manufacturer' and hi_level_desc = '$hileveldesc' and status != '' ";
$zz1 = mysql_query("$selectsale");
$saleresults = mysql_num_rows($zz1);

Basically, I need to count to see if there is a record in the select where status is not blank. When I run the code, no matter what I do, it seems to simply ignore that Status= portion of things.

I know this is probably something really simple and I appreciate any help you can lend.

[[deleted]]

Three things:

!= is PHP syntax, use <> instead

an empty field contains NULL, everything else is either an empty string: "" or a non-empty string.

vars are never quoted:
$zz1 = mysql_query("$selectsale");
should be
$zz1 = mysql_query($selectsale);