Another amazing thread from me...
When i execute part of my php script i get:
Error: You have an error in your SQL syntax near 'Order='3' WHERE CatID=3' at line 1 in query:
my code is:
if($ordernow && $Edit==1){
$sql = "UPDATE cats SET Order='$NewOrder' WHERE CatID='$id'";
$result = mysql_query($sql) or die("Error: ".mysql_error()." in query: ".$query);
}
the code which is used to submit data to that is:
if($action=="order" && $Edit==1){
$result = mysql_query("SELECT * FROM cats",$db);
while ($myrow = mysql_fetch_row($result)) {
echo "<br><br><b>$myrow[1] - Order: <form name='orderform' method=POST action='catadmin.php?ordernow=1&action=order&id=$myrow[0]'><input type = text value=$myrow[3] name='NewOrder' size=5><input type=submit value=Change></form></b>";
}
}
I'm using mySQL for the db.
Any help would be appreciated!
