a prob:
I have a form wich contains a SELECT MULTIPLE element like this:
Code: Select all
<?php
// a databse query for the $anumrows values
echo "<FORM NAME="whois_advanced_$LANG" ACTION="03.php3" METHOD="GET" onreset="return confirmReset(this)">\n";
echo "<INPUT TYPE="HIDDEN" NAME="LANG" VALUE="$LANG">\n";
echo "<INPUT TYPE="HIDDEN" NAME="method" VALUE="$method">\n";
echo "<INPUT TYPE="HIDDEN" NAME="view" VALUE="$view">\n";
echo "<INPUT TYPE="HIDDEN" NAME="search_mode" VALUE="$search_mode">\n";
echo "<SELECT NAME="department[]" SIZE=5 MULTIPLE>\n";
if ($anumrows > '0'){
$a = 0;
while ($a < $anumrows){
$dep_s03 = mysql_result($aerg,$a,"dep_s03");
$dep_s05 = mysql_result($aerg,$a,"dep_s05");
echo "<OPTION VALUE="$dep_s03">"; echo strtr($dep_s05,$short_names); echo "</OPTION>\n";
$a++;}}
echo "</SELECT>\n";
?>Code: Select all
<?php
$tquery = "SELECT staff.s01, staff.s02, staff.s03, staff.s04, staff.s05, staff.s06, staff.s11, staff.s21, staff.s22, staff.s23, staff.s27, staff.s28, staff.s29, staff.s30, staff.s31, staff.s39, staff.s46, staff.s47, staff.s48, staff.s49, staff_departments.dep_s03, staff_departments.dep_s04 FROM staff LEFT JOIN staff_departments ON staff.s03 = staff_departments.dep_s03 WHERE (staff.s05 LIKE '$user%') $connection_01 (staff.s03 LIKE '%$department%') $connection_02 (staff.s01 = '$status') ORDER BY staff.s02 ASC, staff.s05 ASC";
?>Code: Select all
<?php
$department = $_REQUEST["department"];
foreach ($department as $value) {
echo $value." ";}
?>Thanx for help in advance, yours bluenote