...

View Full Version : select non empty row?



ab123
05-10-2009, 06:41 PM
How do i go about selecting from mysql the newest entry in table but all fields must not be empty, or a single declared row must not be empty? :thumbsup:


$q= "select id from tab where thisrow (is not empty) order by name desc";

I dont want to display from mysql if its empty... :)

sea4me
05-10-2009, 06:44 PM
$q = "SELECT `id` FROM `tab` WHERE `thisrow` IS NOT NULL order by name desc";

Not tested...



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum