|
openDatabase();
global $lanId;
global $eventPrice;
global $lanName;
$query = "select activityid, count(*) as 'count' from lan_activities, lan_booking where lanid=$lanId and lan_booking.bookingid=lan_activities.bookingid group by activityid order by activityid";
$list = doQuery($query);
if(isset($list))
{
?>
Följande spel har de som har anmält sig till Najt EasterEye 2004 sagt att de har intresse i:
while(list($h, $x) = each($list))
{
$activity = "Okänd";
if($x["activityid"] == 1)
{
$activity = "Counter-Strike";
}
elseif($x["activityid"] == 2)
{
$activity = "Quake III Arena";
}
elseif($x["activityid"] == 3)
{
$activity = "Quake World";
}
elseif($x["activityid"] == 4)
{
$activity = "Battlefield 1942";
}
elseif($x["activityid"] == 5)
{
$activity = "Natural Selection";
}
elseif($x["activityid"] == 6)
{
$activity = "Unreal Tournament 2003";
}
elseif($x["activityid"] == 7)
{
$activity = "WarCraft III";
}
?>
- -
}
?>
}
else
{
?>
Det finns inga intressen för något!
}
?>
|
closeDatabase();
?>
|
|