MySQL error

Phoenix_Down

I'm using this query:

		$result = mysql_query("insert into calendar values ($eventid'', '$the_event', '$the_desc', '$the_date_y-$the_date_m-$the_date_d', '$_COOKIE[username])", $dbi);
		$result = mysql_query("update calendar set event='".$the_event."', event_desc='".$the_desc."', date='$the_date_y-$the_date_m-$the_date_d', posted_by='$_COOKIE[username]' where id='".$eventid."')", $dbi);

When I try to use it I get the following error: You have an error in your SQL syntax near ')' at line 1

Please tell me how to fix this.

Thanks.

nnichols

I can see a couple of problems with your code.

I suggest you write the query to a variable and then echo the query if it fails and it will tell you straight away where you've gone wrong -

$sql = "your query";
$res = mysql_query($sql, $dbi)
	or die('MySQL error: '.mysql_error().'<br>Query: '.$sql);

Hint check the positioning of your 'single quotes'.

ScubaDvr2

Your eventid value is echoed like $eventid'', when it should be echoved like '$eventid', in the mysql_query statement

Arc

Originally posted by ScubaDvr2
Your eventid value is echoed like $eventid'', when it should be echoved like '$eventid', in the mysql_query statement

Also at the end your missing a quote '$COOKIE[username] should be '$COOKIE[username]'

Phoenix_Down

Okay, thanks for the replies. I fixed the missing quote, but that didn't seem to fix the problem.

Any other suggestions?

cgraz

Have you changed your query as nnichols suggested? If so, what did that print?

$sql = "your query";
print $sql . "<br>"; // this is the line we're looking for
$res = mysql_query($sql, $dbi)
    or die('MySQL error: '.mysql_error().'<br>Query: '.$sql);

If you fixed the positioning of your single quotes, and they're all correct, then printing the query will tell you what's wrong. Maybe one of those variables contains a single quote that needs to be escaped.

Cgraz