Re: [PHP-WIN] insert data in to columns base on the selection of the list box.

2007-04-04 Thread Mikael Grön
Well, simply put (not really following your structure): --- code --- $sql = "update $tablename set address = '$address', phone = '$phone' where LastName = '$lastname';"; if (mysql_query($sql)): echo "Updated " . $_POST['R'] . "\n"; else: echo "Error: " . mysq

Re: [PHP-WIN] insert data in to columns base on the selection of the list box.

2007-04-04 Thread Mikael Grön
I don't get the purpose of your code. It's not looking right anywhere! I'm guessing the select-box isn't working too well, right? Let's say there's 4 $lines: foreach ($line as $value) { echo"$value"; will produce: value='value3'value4 ... You need to use this code for the

Re: [PHP-WIN] insert data in to columns base on the selection of the list box.

2007-04-03 Thread sam rumaizan
bedul, This is what I need (don't worry about the variable names since they are different from my previous email.) '; $query = "SELECT Assign_Engineer FROM lodata"; $result = mysql_query($query); echo""; echo""; echo""; echo""; echo"Choose Name : "; while ($line = m

RE: [PHP-WIN] insert data in to columns base on the selection of the list box.

2007-04-03 Thread sam rumaizan
-- From: sam rumaizan [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 8:00 AM To: php-windows@lists.php.net Cc: [EMAIL PROTECTED] Subject: [PHP-WIN] 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

RE: [PHP-WIN] insert data in to columns base on the selection of the list box.

2007-04-03 Thread Bill Bolte
EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 8:00 AM To: php-windows@lists.php.net Cc: [EMAIL PROTECTED] Subject: [PHP-WIN] 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 informa

[PHP-WIN] insert data in to columns base on the selection of the list box.

2007-04-03 Thread 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 (add data) in to column2, column3, column4 base on the selection of the list box. echo''; $query = "SELECT column1 FROM table"; $re