Research Group 1sort by
name | town | country | university
// Verbindung zur Datenbank
$verbindung = @mysql_connect("localhost","tschneid","dglieq");
if (!$verbindung) {
echo "Database not connected!\n";
exit;
}
$sortier=$_GET['sortier'];
//echo "$sortier: $sortier , p: $p";
$Ein_2 = " ORDER by last_name,first_name" ;
if ($sortier == "Country") $Ein_2 = " ORDER by country,last_name,first_name" ;
if ($sortier == "Town") $Ein_2 = " ORDER by town,last_name,first_name" ;
if ($sortier == "University") $Ein_2 = " ORDER by university,last_name,first_name" ;
$Ein_1 = "SELECT title,last_name,first_name,university,institute,town,country,email FROM tconnex_addresses where rgID='1' ";
$Eingabe = $Ein_1 . $Ein_2 ;
$res = mysql_db_query("CONNEX",$Eingabe);
if (!$res) { echo( mysql_error());
exit; }
$num = mysql_affected_rows();
$counter=0;
echo " ";
while($row=mysql_fetch_row($res))
{
if ($counter % 2)
$bgfarbe = "#ffffff";
else
$bgfarbe = "f0f0f0";
echo("");
//if ($row[0] != "") echo ("$row[0] ");
printf("%s %s %s",$row[2],$row[1],$row[3]);
if ($row[4] != "") echo (", $row[4]");
printf(" %s, %s | %s | | ",$row[5],$row[6],str_replace("@", "(_ at _)",$row[7]));
$counter++;
}
echo " ";
?>
|