displaying images dynamically

you could repeat the mt_rand for as many times as you would like, just make sure that each one has a different variable. For example

PHP Code:

---

<?
$image1 = mt_rand(1,7);
$image2 = mt_rand(1,7);

$sql1 = "SELECT * FROM `images` WHERE `store`='store1' AND `id`='$image1'";

$sql2 = "SELECT * FROM `images` WHERE `store`='store2' AND `id`='$image2'";

//Then simply execute the sql queries and change to appropriate numbers.
?>

---

Enjoy!