Webmaster Odell wrote:
> Hi
>
> I am trying to write a query that pulls all the items from a database except
> two
>
> here is what I am using:
>
> $query = 'SELECT DISTINCT Type FROM Products WHERE Type != "System,
> Upgrade"';
>
> This populates the drop down box with all including the System
SELECT DISTINCT Type FROM Products WHERE Type != "System" AND Type !=
"Upgrade"
-- Jason
On Thu, 2001-08-30 at 15:35, Webmaster Odell wrote:
> Hi
>
> I am trying to write a query that pulls all the items from a database except
> two
>
> here is what I am using:
>
> $query = 'SELECT DISTINC
:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 3:36 PM
To: MySQL
Subject:Select without taking all items
Hi
I am trying to write a query that pulls all the items from a database
except
Hi
I am trying to write a query that pulls all the items from a database except
two
here is what I am using:
$query = 'SELECT DISTINCT Type FROM Products WHERE Type != "System,
Upgrade"';
This populates the drop down box with all including the System and Upgrade.
What do I have to do to make t