Help!!

[aladdin1]

Hello,

I would like to do something like:

$sql = "SELECT _picture1 FROM phpbazar_ads WHERE publicview=1 ORDER BY RAND() limit 1";
$result = mysql_query($sql);

Some time the field "_picture1" is empty how could I select only the the rows where that field is not empty?

Thanks

[dody]

Try this

SELECT _picture1 FROM phpbazar_ads WHERE publicview=1 AND _picture1 <> '' ORDER BY RAND() limit 1

[aladdin1]

Thank you