IMU Logo
 
ICM Plenary and Invited Speakers since 1950
TEST DB" : "";?>
  Search DB
List sorted by
    Last Name 
  Congress Year 
  Section  
 
 
   
rows = $rows
"; ## echo "

result = $result
"; echo "

 Found "; if ($rows == 0 ){ echo "nothing"; } else { if ( $rows == 1 ){ echo "$rows entry"; } else { echo "$rows entries"; } echo "

"; } show_table_search($result); } ?>

 
© IMU http://www.mathunion.org/

SQL=:$sql:";} $result = mysql_query($sql); if (!empty($debug)){ echo $result ? " ok" : " NOT ok" ;} return ($result); } ################################### function show_table_search($result){ ################################### echo " "; echo "\n"; ## while ("aa" == "bb" && $row = mysql_fetch_row($result)) { while ($row = mysql_fetch_row($result)) { $name = $row[0]; ## $name = htmlentities($row[0]); $surname = $row[1]; $type = $row[2]; $congress = $row[3]; if (empty ($type)){ continue; } if (empty ($name)) { $name = " "; } if (empty ($surname)) { $surname = " "; } if (empty ($congress)){ $congress = " "; } if (empty ($type)) { $type = " "; } echo "\n\n"; ## echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; ## echo "\n"; ## echo "\n"; ## echo "\n"; echo "\n"; echo "\n"; } $sql = "SELECT * FROM Abel ORDER BY SpeakerType,Lastname"; $result = execute_sql ($sql); while ($row = mysql_fetch_row($result)) { $name = $row[0]; ## $name = htmlentities($row[0]); $surname = $row[1]; $type = $row[2]; $congress = $row[3]; if (!empty ($type)){ continue; } if (empty ($name)) { $name = " "; } if (empty ($surname)) { $surname = " "; } if (empty ($congress)){ $congress = " "; } if (empty ($type)) { $type = " "; } echo "\n\n"; ## echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; ## echo "\n"; ## echo "\n"; ## echo "\n"; echo "\n"; echo "\n"; } echo "
Last Name  First Name(s)  Congress Year  Section/Speaker Type
 $type$name $surname $congress $type $before@$after
 $type $name $surname $congress $type $before@$after

 

"; } ?>