Thank you for your corroboration. Maybe my question wasn?t clear. What I need to do is: 1- I have a table in mysql with column1(Last Name), column2(address), column3(phone Number), column4(job), column5(favorite food) 2- I have created a while loop to populate the list box in my webpage. 3- I have created text fields for address and phone Number in my webpage. 4- The list box will be populated with column1 (Last Name) of all the users registered in my database. 5- Let?s say one of the users want to change (update) his/her address, phone Number. He/she will choose the Last Name from the dropdown menu (list box) 6- he/she will fill the field in the page for address, phone Number with the new information. 7- The user will hit submit to update (change) the information in the database (mysql) If this is not clear enough, I will try to post my code. Bill Bolte <billb@xxxxxxxxxxxxxxxx> wrote: 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' '; $query = "SELECT column1 FROM table"; $result = mysql_query($query); echo" "; echo" "; echo" "; echo"";echo"Choose a Category:"; while ($line = mysql_fetch_array($result)) { foreach ($line as $value) { echo"}echo ">$value"; }echo ""; echo ""; $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 --------------------------------- It's here! Your new message! Get new email alerts with the free Yahoo! Toolbar.
