simply RAND() getting me crazy

[contra10]

i'm trying to show 6 different random pics but i get 6 of the same image being echoed

 

<?php
$resultalumni1 = "SELECT * FROM users WHERE image = 'true' ORDER BY RAND() LIMIT 6";
$result = mysql_query($resultalumni1) or die(mysql_error());
while ($rowalumni1 = mysql_fetch_array($result)){

$picid1 = "{$rowalumni1['id']}";

echo "<table border='0' width='400'>";
echo "<tr>";
echo "<td WIDTH='33%' height='100' align='center'><img src='http://www.test.com/image/imagereplace.php?id=$picid1'></td></a>";
echo "<td WIDTH='33%' height='100' align='center'><img src='http://www.test.com/image/imagereplace.php?id=$picid1'></td></a>";
echo "<td WIDTH='33%' height='100' align='center'><img src='http://www.test.com/image/imagereplace.php?id=$picid1'></td></a>";
echo "</tr>";
echo "<tr>";
echo "<td WIDTH='33%' height='100' align='center'><img src='http://www.test.com/image/imagereplace.php?id=$picid1'></td></a>";
echo "<td WIDTH='33%' height='100' align='center'><img src='http://www.test.com/image/imagereplace.php?id=$picid1'></td></a>";
echo "<td WIDTH='33%' height='100' align='center'><img src='http://www.test.com/image/imagereplace.php?id=$picid1'></td></a>";
echo "</tr>";
echo "</table>";
}
?>

[contra10]

i'm looking at the code but i can't find prob

[ram4nd]

You have to use while to echo them separately or you just show the first image. You can alsu use [] after variable.

[redarrow]

 

This will give you 6 random pictures.

<?php
$resultalumni1 = "SELECT * FROM users WHERE image = 'true' ORDER BY RAND() LIMIT 6";
$result = mysql_query($resultalumni1) or die(mysql_error());
while ($rowalumni1 = mysql_fetch_array($result)){
   
$picid1 = "{$rowalumni1['id']}";
   
echo "<table border='0' width='400'>";
echo "<tr>";
echo "<td WIDTH='33%' height='100' align='center'><img src='http://www.test.com/image/imagereplace.php?id=$picid1'></td></a>";

echo "</tr>";
echo "</table>";
}
?>