I have database of a bunch of different galleries. I'm displaying links to these galleries in a table with the following code:
PHP Code:
$result = @mysql_query("SELECT * FROM $TableName WHERE approved = 'Y'");
while ( $row = mysql_fetch_array($result) ) {
$i++;
echo "<td><a href=gallery.php?id=$row[id]>$row[name]</a><br>\n";</td>\n";
if (($i % 5) == 0) { echo "</tr><tr>\n" ; }
i would like the table to have a different layout everytime it's loaded (i want the cells to be switched around)
i've been racking my brain on this, and the only way i can think of is to select a random starting point in the database (which i have no idea how to do, or if it's possible)
unless it's possible to rearrange an array.
any help would be appreciated... just give me a shove in the right direction.
if you want to write the code for me, i'll give you a cookie ;)
thanks