Re: ?!? wats wrong?

Is this a joke? Maureen wrote:

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