I'm getting an error message that i can't unclog:
Code:
1064 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 '' at line 1
this is the code snippet:
Code:
$result_projects = mysql_query("SELECT * FROM databasename.projects WHERE projects.path = $current_projectpath");
if(!$result_projects)
{
die("<p>".mysql_errno()." ".mysql_error()."</p>");
}
I've looked online through forums for a while, and can't figure out the cause. I've double checked everything within the query that i can think of, such as:
1. I've run the query from the command line in mySQL and it returns exactly what i want.
2. I've echoed all the variables used, and they're exactly as expected.
Any suggestions about where the syntax error is? Thanks.