<?php
// Öppna databasen
require 'inc/db.php';
// Hämta samtliga artister
$get = mysql_query("SELECT * FROM artister ORDER BY placering");
echo "<table border=1 cellspacing=0 cellpadding=0 bgcolor=#F9F9F9>";
echo "<tr>";
$ctr = 0;
while($userRow = mysql_fetch_array($get))
{
$namn = $userRow['namn'];
$beskrivning = $userRow['beskrivning'];
$url = $userRow['url'];
$bild = $userRow['bild'];
$id = $userRow['id'];
echo "<td>";
echo "<center><img src=gfx/artister/$bild><br><img src=gfx/artister/rander.gif><br><a href=artist.php?id=$id>$namn</a></center>";
echo "</td>";
if ((++$ctr)%3 == 0){
echo "</tr><tr>";
}
}
while ((++$ctr)%3){
echo "<td> </td>";
}
echo "</tr>";
echo "</table><br>";
// Stäng databasen
mysql_close($open);
?>
Inte testat, men det bör funka.
