//DB connect
$dbserver = "localhost";
$dbuser = "tshop_mattm";
$dbpass = "HewsoN";
$database = "tshop_tickets";
$dbase = "eventim5";
mysql_connect($dbserver,$dbuser,$dbpass);
mysql_select_db($database);
function listoneevent($EVENTNR)
{
$result = mysql_query("select EVENTNR, EVENTNAME, ORT, SAALNAME, EVENTDATUM, EVENTZEIT, LKZ, PLZ, STRASSE, TOURNR, KATEGORIENR from eventim5 where EVENTNR='$EVENTNR' LIMIT 0,1");
while ($row = mysql_fetch_array($result)) {
echo "$row[EVENTDATUM] $row[EVENTZEIT] - $row[ORT], $row[SAALNAME] ";
echo "";
if ($row[KATEGORIENR] == "1Z") {
echo " Eventreise
";
} else {
echo " Tickets
\n";
}
}
}
// end function listoneevent
?>