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

<><

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Error in SQL syntax	phantom3008	ASP.NET 1.0 and 1.1 Basics	1	April 26th, 2007 07:00 AM
mysql #1064 error	manahual	MySQL	0	April 23rd, 2007 01:44 PM
Example SQL causes syntax error	Tom Rigby	BOOK: Beginning SQL	1	April 18th, 2007 09:32 AM
SQL Syntax Error I can't figure out	Syster Tara	Classic ASP Basics	24	December 2nd, 2006 05:09 PM
1064 error	kennymain	MySQL	0	July 16th, 2005 03:19 PM