MySQL Forums
Forum List  »  Newbie

what's wrong with this SELECT statement?
Posted by: cadex
Date: June 27, 2005 11:05PM

Hello, I'm trying to write a database, but this one problem is giving me a real head ache. Can anyone help?

This is my select statement:
$query_get_projects = "SELECT nis_project.id, nis_project.subject, nis_project.billingcode, nis_completion.comments, nis_completion.completed, nis_completion.na FROM nis_project JOIN nis_completion ON nis_project.id = nis_completion.project_id AND "' . $_GET['select_store'] . '" = nis_completion.store_id";

This is the error I get:
Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /home2/sit/public_html/nis_live/dbase/projects_data.php on line 8

Line 8 of course is this SELECT statement. I'm almost sure is something to do with the quotes around the $_GET variable, but I've tried every combination.

Please help.
Thanks
Kyle

Options: ReplyQuote


Subject
Written By
Posted
what's wrong with this SELECT statement?
June 27, 2005 11:05PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.