hi! this is just another stupid question from me:
see this is my coding :
<select name="ras_num">
<?php
$linkID = mysql_connect("localhost","","");
mysql_select_db("ras",$linkID);
$result = mysql_query("select from ras_update",$linkID);
while($row = mysql_fetch_array($result))
{
?>
<option value="<?=$row['ras_num']?>" <?=($row['ras_num'] == $ras_num) ? "SELECTED" :""?>>
<font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<?=$row['ras_num']?>
</font></option>
<?php
}
?>
</select>
<input type="submit" name="Submit" value="Submit">
</font></p>
<?php
$linkID = mysql_connect("localhost","","");
mysql_select_db("ras",$linkID);
$result = mysql_query("select from ras_update where ras_num='$ras_num'",$linkID);
while($row = mysql_fetch_array($result))
{
if($ras_num == $row->ras_num)
{
$div = $row->div;
$rc = $row->rc;
$position = $row->position;
$grade = $row->grade;
$ras_recd_date = $row->ras_recd_date;
$ras_num = $ras_num;
$div = $div;
$rc = $rc;
$position = $position;
$grade = $grade;
$ras_recd_date = $ras_recd_date;
}
}
?>
//build table to display
//each data were print using <? print $rc ?> and so
my problem is that is just can view the ras_num only. all other data are no where in sight. any help, anyone?
