Problem on Query

[Anon]

How do I check for an empty record on a database, and then, if it's empty, force another query on the same DB? I've tried both empty and !isset, but I still get empty results.

[mwilson]

If you're querying the SQL server then try;

SELECT ... WHERE column IS NULL

(or if defined as NOT NULL);

SELECT ... WHERE column="";

Alternatively if you've performed your query and are checking w/PHP then using;

if($mycolumn == "") { ... }

should work for testing a column is null or empty.

Matt

[Anon]

thx, Matt, your solution was what I was looking for 🙂