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
SELECT DISTINCT Type FROM Products
WHERE Type != "System"
AND Type != "Upgrade";
Or
SELECT DISTINCT Type FROM Products
WHERE Type NOT IN ("System", "Upgrade");
-Original Message-
From: Webmaster Odell [mailto:[EMAIL PROTECTED]]
Sent:
