Mysterous SQL Syntax Error

[mabans]

I keep getting this error:

You have an error in your SQL syntax near '' at line 1

and for some reason it still excuetes it and does what it is ment to do. This is the query as I am using it. Yet I still yeild the same error. Any thoughts?

$query = "UPDATE artist SET artistname = '$firstname', artistbio = '$biography', artistlastname = '$lastname' WHERE ID = '$art_id'";

mysql_query($query) or die(mysql_error());

thanks in advance

[LordShryku]

echo $query;

It's probably that one of the variables is blank. Make sure it looks like you want it to.

[mabans]

It excutes and updates ti the way ti's meant to. Just don't know why it keeps outputting an error

[jesus_hairdo]

I would try changing the line which performs the query to

$result = mysql_query($query) or die('Error in SQL<br><strong>'.$query.'</strong><br>'.mysql_error());

That way it prints out the SQL that is being run, it maybe that one of your variables contains some punctuation marks that alters the working of the query (ie an SQL inject type problem)