Can you tell us what exactly is your problem ? ie returned error, logic,
or what ?
My first impression es that your insert is wrong, because inserts cant
have "where" conditions (it makes no sense) probably you want to do a
completely new insert including the column1 or maybe you want an
update. Anywhere you can check the manual for sintax issues.
Carlos
sam rumaizan wrote:
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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
