S
sysop
Guest
PHP:
include ('mysql.php');
$query = "SELECT * FROM `artikel` WHERE `kategorie`='$_GET[name]'";
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result))
{
echo"<a href='show.php?id=".$row['id']."'>".$row['bezeichnung']."</a>";
$querya = "SELECT * FROM `image` WHERE `article_id`='".$row['id']."' LIMIT 0, 1 ";
$results = mysql_query($querya);
while ($rows = mysql_fetch_assoc($results))
{
echo "<img src=\"".$rows['path']."\" height=\"100px\">";
}
echo "<hr>";
}
Zuletzt bearbeitet von einem Moderator: