[SOLVED] Retreiving data from my database problem, i want to ignore empty images!

[npsari]

 

Hello there users

 

I have a table called people

in which, there is a colomb called Image1 (where users upload their image)

 

I did a little code to show the latest 10 images

however, i want the code to show all images, except the ones that are empty (because some users doe not upload image)

 

This is my code:

 

$con=mysql_connect("localhost", "name", "password"); 
mysql_select_db("database",$con); 

$q = "SELECT * FROM people ORDER BY Date DESC, Time DESC LIMIT 10;";

$res = @mysql_query($q);

 

What should i add to my code, so that, it ignores empty image1 field

[trq]

$q = "SELECT * FROM people WHERE image1 != '' ORDER BY Date DESC, Time DESC LIMIT 10;";

[npsari]

thanks thorpe