Update where: LOSING MY MIND!
Ok I keep getting an error for this that says my syntax is wrong near "order=7". If I change it to any other column than "order", it works perfectly fine. What could possibly make that happen? This is driving me insane! Heres the code:
I cant figure this out...
$uid = $_SESSION['id'];
$title = $_POST['title'];
$noteid = $_POST['tnum'];
$request = "UPDATE notes SET title='$title' WHERE (user=$uid AND order=$noteid)";
$query = mysql_query($request) or die(mysql_error());
echo "FFAILURE!!! - ".$request;