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

[sam rumaizan]

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 (insert 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="INSERT INTO table WHERE column1='".$_POST["R"]."'

 (column2, column3, column4)VALUES('info2', 'info3', 'info4')";

$result=mysql_query($sql);




 

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