require("/home/kunden/fpfoodde/public_html/connect2db.inc");
/* ************** sql - befehl *************************** */
$sql="SELECT titel, img, text FROM Promotion WHERE pg='$pg';";
/* ************** db - abfrage ****************** */
$result=mysql_query($sql, $db);
/* ************** einlesen in array + ausgabe *************** */
$row=mysql_fetch_array($result);
echo "
" . ($row[0]) . "
|
| " . ($row[1]) . " | ";
echo "";
echo (nl2br($row[2]));
echo " |
";
/* ************** speicher frei ******************** */
mysql_free_result($result);
/* ************** $db = handler ***************** */
/* ************** sql - befehl *************************** */
$sql="SELECT img, jpg FROM Promotion_Bilder WHERE pg='$pg'";
/* ************** db - abfrage ****************** */
$result=mysql_query($sql, $db);
/* ************** einlesen in array + ausgabe *************** */
/* ************** tabelle schreiben ************************ */
// tabellenkopf
echo "
";// |
// beginne abfrage
while($row=mysql_fetch_array($result)){
$bild=urldecode($row[1]);
echo "
 | ";
} // close while
// tabelle schließen
echo "
";
// db-verbindung schließen
mysql_close($db);
?>