Re: ?!? wats wrong?

If the Id field type is integer, take the single quotes off from around the 1 1 in the select statement, otherwise it reads '1' as a string, ie. SELECT * FROM personen WERE Id <> 1 ORDER BY Bijnaam. ^ HTH MB Bogdan Stancescu <mgv@fx.ro> said: > The != operator is valid under MySQL. You should probably try "WHERE" > instead of "WERE". > > Bogdan > > Jeffrey_N_Dyke@Keane.com wrote: > > >Hello... > >use the <> option instead > > > >SELECT * FROM personen WERE Id <> '1' ORDER BY Bijnaam > > > >Jeff > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > --