List of Participants to ROOT 2002
\n";
// access database
if ($db = mysql_connect("localhost", "nobody", "")) {
if (mysql_select_db("root", $db)) {
if ($result = mysql_query($sql, $db)) {
$i = mysql_num_rows($result);
if ($i == 0) {
echo "No participants found\n";
mysql_close($db);
return;
}
echo "$i registrations
\n";
echo "
";
for ($i = 0; $i < mysql_num_fields($result); $i++) {
$fname = mysql_field_name($result,$i);
echo "$fname | ";
}
echo "
\n";
while ($row = mysql_fetch_array($result)) {
echo "";
for ($i = 0; $i < mysql_num_fields($result); $i++) {
$s = ereg_replace("\n", "", $row[$i]);
$s = trim($s);
if ($s == "")
echo "- | ";
else
echo "$row[$i] | ";
}
echo "
\n";
}
echo "
\n";
}
}
mysql_close($db);
}
?>
Back to the ROOT Home Page