include "connect.inc"; $result = mysql_query("select * from $TABLE order by familyname,firstname,no", $CONNECT); $cnt = mysql_query("select count(*) from $TABLE", $CONNECT); $cnt = mysql_fetch_array($cnt); if ($result){ echo "
". "
Name
". "
Affiliation
"; while( $row = mysql_fetch_array($result) ){ echo "
".$row[familyname].", ".$row[firstname]."
". "
".$row[affiliation].", ".$row[department]."
"; } echo "
"; echo "
". "
".$cnt[0]." participants
"; } else{ echo "There is no data.
"; } mysql_close(); ?>