mysql query in php

[optrex]

I am trying to run a query with a couple of conditions, unfortunately they are giving me grief.

What I am after is the following:
if text has a title then skip and continue onto the next
if text has a null title, then get that information if status=allowed

status, text and title are all text fields, this is what I have so far

PHP Code:


$result = mysql_query("SELECT username,title,text,date,userid,status
FROM table_text 
ORDER BY date desc 
LIMIT 5" ) or die(mysql_error());
while($row = mysql_fetch_array( $result )) { 


can anyone offer some guidance please?

[Farcaster]

If you are trying to fetch rows where the title is NULL and the status is "allowed", then your WHERE clause would look like this:

[SQL]SELECT username,title,text,date,userid,status
FROM table_text
WHERE title IS NULL
AND status = 'allowed'
ORDER BY date desc
LIMIT 5[/SQL]

[optrex]

ok thats helped, but I've now seen my mistake. I am taking a blank field as being NULL, but of course its isnt.

How would I change
WHERE title IS NULL
to
WHERE title IS Blank

[Farcaster]

[SQL]WHERE title = ''[/SQL]

[optrex]

thanks