|
Participants
$sql="SELECT *
FROM participants
WHERE Approved = 1 AND AttendConference = 1
ORDER BY LastName, FirstName";
//MySQL-Verbindung aufbauen
$db = mysql_connect("localhost","webuser");
mysql_select_db("gfkl2004",$db);
$result = mysql_query($sql,$db);
//Übersicht ausgeben
$farbe="#E4E9F2";
echo " ";
echo "
Last Name |
First Name |
Organization |
City |
Country | ";
if ( $result != 0 )
{
while ($row = mysql_fetch_array($result))
{
//Eintrag ausgeben
printf("
%s |
%s |
%s |
%s |
%s |
",$row["LastName"],$row["FirstName"],$row["Organization"],$row["City"],$row["Country"]);
//Automatischer Farbwechsel
if ($farbe=="#E4E9F2")
{
$farbe="#FFFFFF";}
else
{
$farbe="#E4E9F2";
};
}
}
echo " ";
?>
|