Situation:
I'm using a DB query to bring back a list of values to populate a
selection box on a form. I would like the user to be able to select
multiple values.
As it stands my code is only returning the last value selected.
I plan to use the selected values to run more queries so I believe the
best way to handle multiple values is to put them in an array and then
run queries based on the array. That's the next stage
How should I change this code to have $earnType return multiple values
I'm guessing this is a mix of the html & php But I'm betting someone
else has solved this already.
Here's the code
<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
<title>OCFR List Page</title>
</head>
<body>
<?php
include("DB.inc");
if($earnType)
{
$ET = explode(":",$earnType);
while ( list($key, $value) = each($ET))
print ("Key: $key, Value: $value <br>");
}
Else
{
$db = odbc_connect($database, $login, $pwd);
$cur = odbc_exec($db, "SELECT Distinct
EARNTYPE FROM ISIDBA.ISI_CDB_OBJ_T
Order by EARNTYPE");
$fields = odbc_num_fields($cur);
$Outer=0;
print "<tr>";
print "<form action=\"$PHP_SELF\" method = \"post\">";
print "<center>Please pick an Earn Type </center><br>";
print "<center><select name = \"earnType\" multiple size = \"10\">";
while( odbc_fetch_row( $cur ))
{
$Outer++;
for($i=1; $i <= $fields; $i++)
{
printf("<option value = \"%s\">%s</option>",
odbc_result( $cur, $i ), odbc_result( $cur, $i ));
}
}
print "</table>";
print "</select></center>";
print "<br><center><input type = \"submit\" value = \"Submit\"></center>";
print "</tr>";
odbc_close( $db);
}
?>
</body>
</html>
--
Michael Kelley
[EMAIL PROTECTED]
Programmer/Systems Analyst I
New Mexico State University
Information and Communication Technologies
Work # (505)-646-1374
P.O. Box 30001
MSC: 3AT
Las Cruces, NM 88003
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
