Re: ?!? wats wrong?
| From: | Nicole Amashta | Date: | Tue, 14 May 2002 22:12:29 +0000 |
| Subject: | Re: ?!? wats wrong? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-19187@lists.php.net to get a copy of this message | ||
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 Bijnaamshould 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