When you say "update in to column2, column3..." are you referring to the list boxes or database tables? If it's the list boxes, are you wanting this to happen on the client side? Or are you putting the data all out at once? -----Original Message----- From: sam rumaizan [mailto:samcalc@xxxxxxxxx] Sent: Tuesday, April 03, 2007 8:00 AM To: php-windows@xxxxxxxxxxxxx Cc: php-windows-info@xxxxxxxxxxxxx Subject: insert data in to columns base on the selection of the list box. 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. -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
