Re: Select without taking all items

2001-08-30 Thread Fabio Caponera
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

Re: Select without taking all items

2001-08-30 Thread Jason Burfield
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

RE: Select without taking all items

2001-08-30 Thread Johnson, Gregert
:[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

Select without taking all items

2001-08-30 Thread Webmaster Odell
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