[techker]

hey guys i made a store script and i would like to a rondom pic on the main page.

see i have 4 tables and in each i have an image.

in my sql

PHP Code:

$data = mysql_query("SELECT `id`
FROM `store`
WHERE 1
LIMIT 0 , 1 " ) or die(mysql_error()); 

but ionly see the same image 4 times?

in the tables

php

PHP Code:

echo '<a href="admin/info_product.php?id='. $info['id'] .'"target="_blank"><img src="admin/getdata3.php?id='. $info['id'] .'" border="0" alt="" /></a><br />'."\n"; 

works but i only see the same image over an over?

how can i extract a diffrent image?

[Jay6390]

Hmm, do you have 4 seperate tables, or 4 entries in one table?
If it's one table, then your mysql statement should look something like

SELECT `id`
FROM `store`
LIMIT CEIL(RAND() * 4) , 1 

[techker]

that gives me a random pic.thats good but it is the same pic in all the boxes?

see i have a bottom footer with 4 square boxes that i wan't pics to show in each.

[Nico]

SELECT `id` FROM `store` ORDER BY RAND() LIMIT 4 

Then use a loop to output the table with the images. Otherwise you'll only get one image.

[techker]

hen use a loop to output the table with the images. Otherwise you'll only get one image.

thats the part the is messing me up?