insert data in to columns base on the selection of the list box.

[sam rumaizan <samcalc@xxxxxxxxx>]

Can you help me please?


1-    I have created a while loop to populate the list box   with the information of column1.
        2-I need to update (add data) in to column2, column3, column4 base on the selection of the list box.
   

echo'<form>';

 

 $query = "SELECT  column1   FROM table";

   $result = mysql_query($query);

echo"<br>";

 

echo"<br>";

echo"<center>";

 

 

echo"<select   NAME='R'>";

echo"<option value='NULL'>Choose a Category:</option>

";

   while ($line = mysql_fetch_array($result))

   {

      foreach ($line as $value)

       {

         echo"<OPTION value='$value'";

      }

echo   ">$value</OPTION>";

 

   }

echo "</select>";

echo "</form>";

 $sql="UPDATE $tbl_name SET column2 = CONCAT(column2, '$_POST[column2]', column3 = CONCAT(column3, '$_POST[column3]',column4 = CONCAT(column4, '$_POST[column4]' WHERE Assign_Engineer ='".$_POST["R"]."'";


$result=mysql_query($sql);




 

 
---------------------------------
No need to miss a message. Get email on-the-go 
with Yahoo! Mail for Mobile. Get started.