php编了一个下拉框,当在下拉框选中一个数据,提交以后,下拉框没有显示选中的数据,而是初始状态,求解决下拉框创建函数<?php
function getqycs($name,$system,$tname,$dname)
{
global $cursor;
echo "<select name=$name >";
$sql="select distinct a.$dname from $system.$tname a where a.$dname<>'XXX'";
ora_parse($cursor, $sql) or die;
ora_exec($cursor);
echo "<option value=''>...</option>";
while(ora_fetch($cursor)) {
$numcols=ora_numcols($cursor);
for($column=0; $column < $numcols; $column++) {
$row[$column]=trim(ora_getcolumn($cursor, $column));
}
if($row[0]==$name)
echo "<option value=$row[0] selected>$row[0]</option>";
else
echo "<option value=$row[0]>$row[0]</option>";
}
echo "</select>";
}
?>程序中调用
echo "选择币种";
@include("include/bz.php");
getqycs("dwdmbz","bancs",$tablename,"invm_currency");
echo "<input type=submit name=search value='查询'>";
echo "</td>";
echo "</tr>";
选中下拉框一个值,按下提交按钮,下拉框中选中的值就会没有
function getqycs($name,$system,$tname,$dname)
{
global $cursor;
echo "<select name=$name >";
$sql="select distinct a.$dname from $system.$tname a where a.$dname<>'XXX'";
ora_parse($cursor, $sql) or die;
ora_exec($cursor);
echo "<option value=''>...</option>";
while(ora_fetch($cursor)) {
$numcols=ora_numcols($cursor);
for($column=0; $column < $numcols; $column++) {
$row[$column]=trim(ora_getcolumn($cursor, $column));
}
if($row[0]==$name)
echo "<option value=$row[0] selected>$row[0]</option>";
else
echo "<option value=$row[0]>$row[0]</option>";
}
echo "</select>";
}
?>程序中调用
echo "选择币种";
@include("include/bz.php");
getqycs("dwdmbz","bancs",$tablename,"invm_currency");
echo "<input type=submit name=search value='查询'>";
echo "</td>";
echo "</tr>";
选中下拉框一个值,按下提交按钮,下拉框中选中的值就会没有
$system.$tname是表名,不是$system.$name现在可以选中选中的值,关键是一提交不能保留选择的值
重新定了一个参数,$row[0]==$dmdm