unexpected error

tuf-web_co_uk

can anyone see an error with this code, i'm trying to check if the file i have in a certain directory is in my database, and if it isnt then put it in and tell me which files are new so i can tell people on my news page

<?
$sql = "SELECT * FROM `waypoints` WHERE `type` = '$wpt[$i]' AND `name` = '".$files."'";
				$qry = mysql_query($sql) or die(mysql_error());
?>

i keep getting this 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 ' AND name='as_52hours6.zip'' at line 1

could anyone please give me some insight as to why this is happening?

thanks, Comms

bastien

Echo out the sql before execution...that way you can loook at it and see if the quotes are in the right place, commas are correctly placed etc

tuf-web_co_uk

hhm.... everything was fine, when i re-ran the script with the echo statement in, it worked perfectly, i didnt get that error message

but i didnt change anything else in my code

so what i want to know is why it was doing this in the first place?