1
First of all sorry for my English
Im a php/xoops coding newbie..i'm currently testing
doing a simple module for XOOPS cms...
i'm having trouble with this can anyone help me
ok i have this
two table
info_unit : log_id, occupation
myocc : id, occ_list
input
<select name='occupation'> <option value="">Select Occupation</option> <?php global $xoopsDB; $result = mysql_query("SELECT * FROM ".$xoopsDB->prefix("myocc").""); while($row = mysql_fetch_array($result)) { $occ_list=$row['occ_list']; echo "<option value='$occupation'>$occ_list</option>"; } ?> </select>
the above code working properly...the drop down will display value from myocc..
and the value is submitted to info_unit table successfully
the problem is this code below when i want to edit a record in the edit form the value that i selected in the input form is not display/choosen
update record
<?php $log_id=$_POST[log_id]; if($log_id=='') { echo "<center>Please Select a record</center><br /><br />"; } else { $result = mysql_query("SELECT * FROM info_unit WHERE log_id=$log_id"); while($row = mysql_fetch_array($result)) { $log_id=$row['log_id']; $occupation=$row['occupation']; } ?> <select name='occupation'> <option value=''>Select occupation</option> <?php global $xoopsDB; $result = mysql_query("SELECT * FROM ".$xoopsDB->prefix("myocc").""); while($row = mysql_fetch_array($result)) { $occ_list=$row['occ_list']; if($occupation == '$occ_list') { echo "<option value='$occupation' selected>$occ_list</option>"; } else { echo "<option value='$occupation'>$occ_list</option>"; } } ?> </select>
