How do i fix this database error?

As long as there's something after that equals sign, I see nothing wrong with it.

You will have to dig into the code to see how the query is being formed; to see what is tripping it up.

I had a module that would throw a database error if the title of the content the module was reporting contained an apostrophe.  Apostrophes are used in query strings as you know HL, so the module developer had to escape the apostrophe in the title first before forming the query.  Once that was taken care of, the database errors stopped.

If this is from a module you purchased, then send the error message to the developer to see if they can find the issue and fix it.

Is that GameZone?

The complete line of code in site_functions.php is this:

$mypr = db_value("SELECT max(score) from gz_activity where (uid=$cid or uid2=$cid) and gameid=$gameid");

I will say again, I see nothing wrong with it.  GG, of course, will have her two cents to add.

I think you missed the f***ing point you bleeding ....  The query string might be perfectly fine but it is the bleeding variables that may be tripping it up when they get converted out; just like what was happening in the incident I reported.  When the $title got written out to "Don't You Think" that apostrophe then was added into the query and mySQL thought it was indicating part of the query and not text.   Stop being an arse sometime HL, you might actually find you like it.  

All that was needed here was "I will say again, I see nothing wrong with it" full stop.  Then if you were curious as to what I may have to add, you could have said, "GG, what do you see wrong with it?"

Well... at least I don't supplement all of my posts with a bunch of useless babble.

Kids don't fight....

 yes it is the games module, it errors anytime someone plays a game, like it is an issues saving the score or something but everything looks to me functioning ok, it has been like this from a while I am just tired of seeing the emails.

 some people find total post count to be important and some sort of status symbol,, and to some people like you, newt, a few others and myself find it quite annoying, trust me many of us have had the conversation more then a few times already..  will just be happy when the total count being shot for is achieved and certain things slow down

Fight! Fight! fight! I am enjoying this... Fight, fight, fight!

print "id=".$gameid;

="" || ="xx" ?