SQL error in php

jamiason

New Member
Hey, I wrote some code for extracting some information out of the database and checking to see if it met the $_COOKIE data. But I am getting the error message:\[code\]Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1\[/code\]My code so far is:\[code\]$con = mysql_connect("XXXX","XXXXX","XXXXXXX");if (!$con) { die('Could not connect: ' . mysql_error()); }mysql_select_db("XXXXXX", $con);$id = $_COOKIE['id']; $ends = $_COOKIE['ends'];$userid = strtolower($_SESSION['username']);$queryString = $_GET['information_from_http_address'];$query = "SELECT * FROM XXXXX"; $result = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($result)){ if ($queryString == $row["orderid"]){ $sql="UPDATE members SET orderid = ''WHERE (id = $id)"; $sql="UPDATE members SET level = 'X'WHERE (id = $id)"; $sql="UPDATE members SET payment = 'XXXX'WHERE (id = $id)"; $sql="UPDATE members SET ends = '$ends'WHERE (id = $id)"; if (!mysql_query($sql)) { die('Error: ' . mysql_error()); } } }\[/code\]Any help would be appreciated,Thanks.
 
Back
Top