Hi, I have a small problem. I made a form to update serveral id's at the same time. Im looking to update the same field.
PHP Code:
echo "<form action='page.php?action=order' method='POST'>";
$sql = "SELECT * FROM `page` ORDER BY `order` DESC";
$result = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_object($result))
{
echo "<input type='text' name='order' value='$row->order'>";
}
echo "<input type='submit' value='save'></form>";
in page.php?action=order:
PHP Code:
$sql = "UPDATE `page` SET order = '".$_POST['order']."'";
mysql_query($sql) or die(mysql_error());
Im clueless, any suggestions?
Thanks in advance
Niklas