include("../typo3conf/localconf.php");
$dbh=mysql_connect ($typo_db_host, $typo_db_username, $typo_db_password) or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db($typo_db, $dbh) or die('Could not select database.');
if (isset($_GET["uid"])){
$uid=$_GET["uid"];
$result=mysql_query("SELECT * FROM tx_shop where art_nr=$uid",$dbh);
while($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
$d_art=$row["d_art"];
$Kategorie=$row["Kategorie"];
$Gewehrart_d=$row["Gewehrart_d"];
$kaliber=$row["kaliber"];
$marke=$row["marke"];
$type=$row["type"];
$vkpreis=$row["vkpreis"];
$textlang_d=$row["textlang_d"];
$textkurz_d=$row["textkurz_d"];
if ($d_art=="") $d_art=" ";
if ($Kategorie=="") $Kategorie=" ";
if ($Gewehrart_d=="") $Gewehrart_d=" ";
if ($kaliber=="") $kaliber=" ";
if ($marke=="") $marke=" ";
if ($type=="") $type=" ";
if ($vkpreis=="") $vkpreis=" ";
if ($textlang_d=="") $textlang_d=" ";
if ($textkurz_d=="") $textkurz_d=" ";
if (is_file("shop_images/".$uid.".jpg")){
$bild=$uid.".jpg";
}else{
$bild="leer.gif";
}
print"
Artikelnummer |
$uid |
Waffenart |
$d_art |
Kategorie |
$Kategorie |
Gewehrart |
$Gewehrart_d |
Kaliber |
$kaliber |
Marke |
$marke |
Modell |
$type |
Verkaufspreis |
$vkpreis |
Kurzbeschreibung |
$textkurz_d |
Beschreibung |
$textlang_d |
|
";
}
}
?>