mysql query help

[billgod]

I am creating a site that has to display 36 images on the screen.  The image name is stored in the database.  My problem is if I have less than 36 images stored I need to display a default image.  here is my current query

 

$sql="SELECT col_image, col_url from tbl_images WHERE col_active='1' and col_bigimage='0' ORDER BY RAND() limit 36";

 

so If I only have 20 active images. I need to display 16 default images.  I hope this makes sense.

 

Bill

[Roman Fedorov]

keep a counter with the number of images you have wrote.

Once you finished writing database images, continue writing default images until the counter is 36

[Maq]

keep a counter with the number of images you have wrote.

Once you finished writing database images, continue writing default images until the counter is 36

 

You can use mysql_num_rows to find out how many are returned.

[billgod]

exactly what I needed.. Thanks!