error 1064 SQL syntax puzzle

ericwright · April 24th, 2004, 12:16 PM

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.

Snib · April 24th, 2004, 12:49 PM

Does the variable $current_projectpath contain the value of a field?

Also, I don't know if it will change anything, but try using functions like mysql_select_db instead of SELECTing from the database like you do. You don't need to include the name of the table when you refer to the field, either.

Let me know if these things help.

Snib

<><

ericwright · April 24th, 2004, 01:02 PM

Snib,

As suggested, I adjusted the code to:

Code:

mysql_select_db("databasename");
$result_projects = mysql_query("SELECT * FROM projects WHERE projects.path = $current_projectpath");

I'm still getting exactly the same error.

$current_projectpath contains the value to find in the "path" field of the table "projects". I've also tried substituting the actual value that $current_projectpath should be/is, and it made no difference.

Thanks for the help so far. Any other suggestions are appreciated.

Snib · April 24th, 2004, 01:27 PM

If $current_projectpath contains a value that you are looking for, you need to surround the variable in single quotes:

Code:

mysql_query("SELECT * FROM projects WHERE projects.path='$current_projectpath'");

Without the quotes, MySQL searches for a field named whatever $current_projectpath is (I think this is your problem).

Also, I'm not sure that it accepts whitespace around the equals sign (it might, I'm just not sure).

HTH,

Snib

<><

ericwright · April 24th, 2004, 06:31 PM

Snib - thank you !

That appears to have fixed the problem (and it seems that whitespace doesn't make a difference). One reason I was (and am) so confused is that the following snippet (from another part of the code) still works (and always has):

Code:

$result_projects = mysql_query("SELECT * FROM databasename.projects WHERE projects.CID=$c_ID")

where $c_ID is a variable holding the number to look up in the "CID" field of the "projects" table.

I wish I knew what's going on, but if it ain't broke, i'm not going to break it.

Thanks again.

Snib · April 24th, 2004, 09:20 PM

I'm glad it's working. Thanks for letting me know about the whitespace.

Snib

<><