php/mysql - want to select all NOT NULL, not work right..

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
camarosource
Forum Commoner
Posts: 77
Joined: Sat Aug 03, 2002 10:43 pm

php/mysql - want to select all NOT NULL, not work right..

Post by camarosource »

Trying to do the following:

Select fields "user_from, username, user_email FROM database phpusers where user_from does NOT contain "USA" nor are BLANK, and then order by username.

My PHP script is :

$sql = "SELECT user_from, username, user_email FROM phpbb_users WHERE user_from NOT LIKE '%usa%' OR user_from=NULL OR user_from='' ORDER BY username";

//Execute SQL query
$sql_result = mysql_query($sql,$conn) or die(mysql_error());


It seems to be selecting all those without "USA" which is what I want, however seems to be ignoring the part about NOT wanting to select those that are BLANK (NULL).

Help. Thanks
User avatar
PrObLeM
Forum Contributor
Posts: 418
Joined: Sun Mar 07, 2004 2:30 pm
Location: Mesa, AZ
Contact:

Post by PrObLeM »

Code: Select all

SELECT * FROM phpbb_users WHERE user_from != 'usa' OR user_from != NULL OR user_from != '' ORDER BY username

that should work
camarosource
Forum Commoner
Posts: 77
Joined: Sat Aug 03, 2002 10:43 pm

Post by camarosource »

Changed it to :

$sql = "SELECT * FROM phpbb_users WHERE user_from != 'usa' OR user_from != NULL OR user_from != '' ORDER BY username";

//Execute SQL query
$sql_result = mysql_query($sql,$conn) or die(mysql_error());


But it displays if user_from is blank still..
User avatar
andre_c
Forum Contributor
Posts: 412
Joined: Sun Feb 29, 2004 6:49 pm
Location: Salt Lake City, Utah

Post by andre_c »

instead of doing

Code: Select all

!= NULL
do

Code: Select all

IS NOT NULL
Post Reply