drop down value from mysql problem

[sarahmx]

Hi

First of all sorry for my English

I'm new here and Im a php coding newbie..i'm currently testing

doing a simple program 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="">Sellect Occupation</option>
   <?php
 global $xoopsDB; 
 $result = mysql_query("SELECT * FROM ".$xoopsDB->prefix("myocc")."");
 
 while($row = mysql_fetch_array($result))
{
$occ_list=$row['occ_list'];
$occupation=$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 selected



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>

[sarahmx]

ok nevermind i solved this

i just changed the if statement and sql query

<?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").",".$xoopsDB->prefix("infounit")." WHERE log_id=$log_id");

 while($row = mysql_fetch_array($result))
{
$occ_list=$row['occ_list'];
$occupation=$row['occupation'];
 
        if($occ_list == $occupation) {
    
    echo "<option value='$occupation' selected>$occ_list</option>";
}
 
else
{   
$occupation=$occ_list;
echo "<option value='$occupation'>$occ_list</option>";
}  

}
?>

  </select>