 UBBFriend: Email This Page to Someone! |
 DevShed Discussion Forums
 MySQL
 select using !=
|
| next newest topic | next oldest topic |
| Author | Topic: select using != |
|
tonym Junior Member |
posted July 09, 2000 04:48 AM
   
I'm using this sql statement to retrieve records from my table where the field view does not equal 1 (view is an INT field size 4) $sql = mysql_query("select * from mytable where view !=1 order by date_written desc"); But it doesn't work - it returns no records. I changed it to this and this works: $sql = mysql_query("select * from mytable where view ='' OR ISNULL(view) order by date_written desc"); But I thought the first one would work - can anyone put me right as to why the first select query doesn't work? TIA, Tony |
|
SepodatiCreations Member |
posted July 09, 2000 11:20 PM
I tried your first statement and it worked fine for me. i'm not sure what the problem could be. what version are you using?? ---John Holmes... |
|
drewbacca Junior Member |
posted July 10, 2000 07:12 PM
In mysql, the proper "not equal to" statement is <> not != |
|
rod k Member |
posted July 10, 2000 08:26 PM
Actually, either != or <> are perfectly acceptable. |
All times are MST (US) | next newest topic | next oldest topic |
  |
|
Contact Us | DevShed.com
Copyright © 1997-2000 ngenuity. All rights reserved.
Powered by: Ultimate Bulletin Board, Version 5.41a
© Infopop Corporation (formerly Madrona Park, Inc.), 1998 - 1999.