oywch
asked on
store selected drop down list value and pass the value to the next pagefor further retrieving purpose
hi,
can anyone know how to store selected drop down list value(values retrieving from oracle)and pass the value to next page for further retrieving purpose.
i oredi finish the function code for showing all the values from the oracle to a drop down list:
function createDropDown($tableName, $fieldName ,$inputNam e,$result) {
$query = ("SELECT DISTINCT ". $fieldName ." FROM ". $tableName);
ora_parse($result, $query,0);
ora_exec($result);
$returnDropDownString = "<select name='".$inputName."'>\n";
$numcols = ora_numcols($result);
while (ora_fetch($result)) {
//for($i=0;$i<$numcols;$i+ +){
$returnDropDownString .= "<option value='".ora_getcolumn($re sult,0)."' >";
$returnDropDownString .= ora_getcolumn($result,0);
$returnDropDownString .= "</option>\n";
//}
}
$returnDropDownString .= "\n</select>\n";
return $returnDropDownString;
}
the code oredi successfully pull all the values from specific field from the table.now,i would like to know the way to store the selected value and pass value to next page so that i can continue retrieving the selected value's data.
urgent!!!thx:)
can anyone know how to store selected drop down list value(values retrieving from oracle)and pass the value to next page for further retrieving purpose.
i oredi finish the function code for showing all the values from the oracle to a drop down list:
function createDropDown($tableName,
$query = ("SELECT DISTINCT ". $fieldName ." FROM ". $tableName);
ora_parse($result, $query,0);
ora_exec($result);
$returnDropDownString = "<select name='".$inputName."'>\n";
$numcols = ora_numcols($result);
while (ora_fetch($result)) {
//for($i=0;$i<$numcols;$i+
$returnDropDownString .= "<option value='".ora_getcolumn($re
$returnDropDownString .= ora_getcolumn($result,0);
$returnDropDownString .= "</option>\n";
//}
}
$returnDropDownString .= "\n</select>\n";
return $returnDropDownString;
}
the code oredi successfully pull all the values from specific field from the table.now,i would like to know the way to store the selected value and pass value to next page so that i can continue retrieving the selected value's data.
urgent!!!thx:)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.