Pearl Jam DVD
// SQL Anweisung
$sql1 = "SELECT pearl_jam_dvd.show_id, pearl_jam_dvd.show_tour_id, pearl_jam_dvd.show_date, pearl_jam_dvd.show_place, pearl_jam_dvd.show_rating, pearl_jam_dvd.show_no_disc, pearl_jam_dvd.show_format, pearl_jam_dvd.show_source, pearl_jam_dvd.show_comment, tour.tour_name FROM pearl_jam_dvd, tour WHERE tour.tour_id = pearl_jam_dvd.show_tour_id AND pearl_jam_dvd.show_tour_id <= 10 AND pearl_jam_dvd.show_tour_id >= 7 ORDER BY pearl_jam_dvd.show_date;";
// Abfrage ausführen Result-Identifier, aber nicht direkt das Ergebnis steckt nun in $result
$result1 = mysql_query($sql1);
// Jetzt die gelieferten Zeilen einzeln durchgehen, Möglichkeit 1:
while (list($show_id, $show_tour_id, $show_date, $show_place, $show_rating, $show_no_disc, $show_format, $show_source, $show_comment, $tour_name) = mysql_fetch_array($result1)) { ?>
--- ---
Date:
$filenameSC3 = "$DOCUMENT_ROOT/screenshots/$show_date"._.$show_format."_a.jpg";
if (file_exists($filenameSC3)) {?>
Menu Screenshots:
}?>
$filenameSC2 = $DOCUMENT_ROOT."/screenshots/".$show_date."_".$show_format."_b.jpg";
if (file_exists($filenameSC2)) {?>
}?>
$filenameSC1 = $DOCUMENT_ROOT."/screenshots/".$show_date."_".$show_format."_c.jpg";
if (file_exists($filenameSC1)) {?>
}?>
Venue:
Tour:
Format:
No. of Discs:
Rating (Video/Audio):
Source:
Comments:
Artwork:
$filename1 = "$DOCUMENT_ROOT/thumbs/".$show_date."_".$show_format."_a.jpg";
if (file_exists($filename1)) {?>
}?>
$filename11 = $DOCUMENT_ROOT."/thumbs/".$show_date."_".$show_format."_a_i.jpg";
if (file_exists($filename11)) {?>
}?>
$filename12 = $DOCUMENT_ROOT."/thumbs/".$show_date."_".$show_format."_a_st1.jpg";
if (file_exists($filename12)) {?>
}?>
$filename13 = $DOCUMENT_ROOT."/thumbs/".$show_date."_".$show_format."_a_st2.jpg";
if (file_exists($filename13)) {?>
}?>
$filename2 = $DOCUMENT_ROOT."/thumbs/".$show_date."_".$show_format."_b.jpg";
if (file_exists($filename2)) {?>
}?>
$filename21 = $DOCUMENT_ROOT."/thumbs/".$show_date."_".$show_format."_b_i.jpg";
if (file_exists($filename21)) {?>
}?>
$filename22 = $DOCUMENT_ROOT."/thumbs/".$show_date."_".$show_format."_b_st1.jpg";
if (file_exists($filename22)) {?>
}?>
$filename23 = $DOCUMENT_ROOT."/thumbs/".$show_date."_".$show_format."_b_st2.jpg";
if (file_exists($filename23)) {?>
}?>
$filename3 = $DOCUMENT_ROOT."/thumbs/".$show_date."_".$show_format."_c.jpg";
if (file_exists($filename3)) {?>
}?>
$filename31 = $DOCUMENT_ROOT."/thumbs/".$show_date."_".$show_format."_c_i.jpg";
if (file_exists($filename31)) {?>
}?>
$filename32 = $DOCUMENT_ROOT."/thumbs/".$show_date."_".$show_format."_c_st1.jpg";
if (file_exists($filename32)) {?>
}?>
$filename33 = $DOCUMENT_ROOT."/thumbs/".$show_date."_".$show_format."_c_st2.jpg";
if (file_exists($filename33)) {?>
}?>
$filename4 = $DOCUMENT_ROOT."/thumbs/".$show_date."_".$show_format."_d.jpg";
if (file_exists($filename4)) {?>
}?>
$filename41 = $DOCUMENT_ROOT."/thumbs/".$show_date."_".$show_format."_d_i.jpg";
if (file_exists($filename41)) {?>
}?>
$filename42 = $DOCUMENT_ROOT."/thumbs/".$show_date."_".$show_format."_d_st1.jpg";
if (file_exists($filename42)) {?>
}?>
$filename43 = $DOCUMENT_ROOT."/thumbs/".$show_date."_".$show_format."_d_st2.jpg";
if (file_exists($filename43)) {?>
}?>
$filename5 = $DOCUMENT_ROOT."/thumbs/".$show_date."_".$show_format."_e.jpg";
if (file_exists($filename5)) {?>
}?>
$filename51 = $DOCUMENT_ROOT."/thumbs/".$show_date."_".$show_format."_e_i.jpg";
if (file_exists($filename51)) {?>
}?>
$filename52 = $DOCUMENT_ROOT."/thumbs/".$show_date."_".$show_format."_e_st1.jpg";
if (file_exists($filename52)) {?>
}?>
$filename53 = $DOCUMENT_ROOT."/thumbs/".$show_date."_".$show_format."_e_st2.jpg";
if (file_exists($filename53)) {?>
}?>