Code: Alles auswählen
$sql = 'SELECT * FROM artists_house WHERE artist_name IN(' . str_replace("'", "''", $row['lineup']) . ')';
if (!($result = $db->sql_query($sql)))
{
message_die(GENERAL_ERROR, 'Konnte die artists nicht laden!', '', __LINE__, __FILE__, $sql);
}
$lineup_info = array();
while ($row = $db->sql_fetchrow($result))
{
$lineup_info[$row['artist_name']] = true;
}
$db->sql_freeresult($result);
$artist = explode(',', $lineup);
$lineup = array();
foreach ($artists as $artist)
{
if (isset($lineup_info[$artist]))
{
$lineup[] = '<a href="url">' . $artist . '</a>';
}
else
{
$lineup[] = $artist;
}
}
$lineup = implode(', ', $lineup);