[PHP-DB] Re: ?!? wats wrong?

2002-05-14 Thread Nicole Amashta 

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

Re: [PHP-DB] Re: ?!? wats wrong?

2002-05-14 Thread Jeffrey_N_Dyke 


I love how this keeps getting answeredwere 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