[SOLVED] MySQL Error..

[Klance]

I'm getting this error:

Error in query: SELECT MAX(score) FROM GH80 WHERE console = 'PS2' AND diff = 'Expert' AND song = 'Ain't Nothin But A Good Time'. You have an error in your SQL syntax near 't Nothin But A Good Time'' at line 1

 

Here is the code i'm using:

 

<tr>
<td><center><?php (include "PreSong.inc"); ?>&song=Ain't Nothin But A Good Time">Ain't Nothin But A Good Time</a></td></center>
<td>
<?php $query = "SELECT MAX(score) FROM $game WHERE console = '$console' AND diff = '$diff' AND song = 'Ain't Nothin But A Good Time'";
$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());
echo mysql_result($result, 0); ?>
</td>
</tr>

[rondog]

try:

"SELECT MAX(score) FROM $game WHERE console = '$console' AND diff = '$diff' AND song = 'Ain\'t Nothin But A Good Time'";

 

the ' in you song name is throwing it off

[Klance]

try:

"SELECT MAX(score) FROM $game WHERE console = '$console' AND diff = '$diff' AND song = 'Ain\'t Nothin But A Good Time'";

 

the ' in you song name is throwing it off

 

Thank you