Re: Re: ?!? wats wrong?

I love how this keeps getting answered....were is just spelled wrong. it's so funny that we all miss that though. i did a couple days ago and responded with my own solution that didn't matter, b/c i still didn't spell where correctly. :) Nicole Amashta <430ntr3k@bell To: php-db@lists.php.net south.net> cc: Subject: [PHP-DB] Re: ?!? wats wrong? 05/14/2002 06:12 PM Hi, I am used to ID fields being numeric. If this is the case in your table, remove the single quotes from the id value '1' because that will cause error also. So: > SELECT * FROM personen WERE Id != '1' ORDER BY Bijnaam should be: SELECT * FROM personen WERE Id != 1 ORDER BY Bijnaam *IF* your ID field is numeric. hth, nicole amashta www.aeontrek.com Peter Roescher wrote: > I have a mysql query like this > > SELECT * FROM personen WERE Id != '1' ORDER BY Bijnaam > > but it wont work > Supplied argument is not a valid MySQL result resource > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php