include 'registration/inc_common.php';
$nlpmysql = db_connect();
$adr = '';
include 'inc_vrchni.php';
?>
SCO 2008 - Zaregistrovaní účastníci
| Jméno | Organizace |
$i = 0;
$dotaz = 'SELECT * FROM people_registration WHERE souhlas=1 ORDER BY prijmeni, jmeno';
$result = mysql_query($dotaz) or die("MySQL query error: ".mysql_error()."
$dotaz");
while ($row = mysql_fetch_assoc($result)) {
echo '| ';
if ($row['souhlas'] == 1) echo $row['jmeno'].' '.$row['prijmeni'];
else echo ' ';
echo ' | '.$row['affiliation'].' |
'."\n";
$i++;
}
$dotaz = 'SELECT * FROM people_registration WHERE souhlas=0 ORDER BY people_id';
$result = mysql_query($dotaz) or die("MySQL query error: ".mysql_error()."
$dotaz");
while ($row = mysql_fetch_assoc($result)) {
echo '| ';
if ($row['souhlas'] == 1) echo $row['jmeno'].' '.$row['prijmeni'];
else echo ' ';
echo ' | '.$row['affiliation'].' |
'."\n";
$i++;
}
?>
Celkem: '.$i.'';?>