insert data in to columns base on the selection of the list box.
| From: | sam rumaizan | Date: | Tue, 03 Apr 2007 13:00:11 +0000 |
| Subject: | insert data in to columns base on the selection of the list box. | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-27615@lists.php.net to get a copy of this message | ||
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.