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: [EMAIL PROTECTED]
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
