PHP MYSQL error - "You have an error in your SQL syntax; check ... for the right syntax to use near

Question

The exact error message is:

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 'where rfflag='0'' at line 1

Hi,

I'm trying to get some php scripts working and it dies with the above error message. There are two locations where rfflag is used in the SQL query:

$_SESSION['lang']=$objTerm->my_get_one("select min(id) from "
    .$objTerm->TABLE['languages']." where status='1' and rfflag='0'");

$rs_lang=$objTerm->execute_query("select id,language from "
    .$objTerm->TABLE['languages']." where `status`='1' and `rfflag`='0'");

How do I determine which one is causing the problem? Or is the problem something else altogether?

Are you 100% sure that rfflag isn't used in another query somewhere? — Tim Stone
– Tim Stone, Commented Sep 16, 2010 at 6:42

gianebao · Accepted Answer · 2010-09-16 05:50:02Z

2

Echo this:

"select id,language from ".$objTerm->TABLE['languages']." where status='1' and rfflag='0'"

and this:

"select min(id) from ".$objTerm->TABLE['languages']." where status='1' and rfflag='0'"

Then run execute each output in your favorite sql developer tool. Errors will be displayed there.

answered Sep 16, 2010 at 5:50

gianebao

19.2k3 gold badges33 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jani Hartikainen · Accepted Answer · 2010-09-16 05:50:26Z

1

How do I determine which one is causing the problem?

Remove one of the queries. See if it still happens.

On a secondary thought, I would suggest that you change your MySQL query code so, that it doesn't use die() to print out the error message. Use trigger_error or exceptions instead, this way you will automatically get a trace of which line caused it.

answered Sep 16, 2010 at 5:50

Jani Hartikainen

43.4k11 gold badges70 silver badges87 bronze badges

Comments

Your Common Sense · Accepted Answer · 2010-09-16 06:07:24Z

0

How do I determine which one is causing the problem?

use trigger_error() to output an error message.
I guess (I have to guess because you supply no code) that you are using die() to output an error.
if you change this bad practice function to trigger_error(), you will be able to see the line number, where error occurred.
If you add non only mysql_error() to it's output, but also query itself, you will be able to see the problem code too.

answered Sep 16, 2010 at 6:07

Your Common Sense

158k42 gold badges226 silver badges373 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:08:59Z

0

I guess $objTerm->TABLE['languages'] is undefined or does not have the value you’re expecting.

As sheeks06 has already suggested, just echo the query to see if everything is as expected:

$query = "select min(id) from "
    .$objTerm->TABLE['languages']." where status='1' and rfflag='0'";
echo $query;
$_SESSION['lang']=$objTerm->my_get_one($query);

$query = "select id,language from "
    .$objTerm->TABLE['languages']." where `status`='1' and `rfflag`='0'";
echo $query;
$rs_lang=$objTerm->execute_query($query);

edited May 23, 2017 at 12:08

CommunityBot

11 silver badge

answered Sep 16, 2010 at 6:36

Gumbo

657k112 gold badges792 silver badges852 bronze badges

Collectives™ on Stack Overflow

PHP MYSQL error - "You have an error in your SQL syntax; check ... for the right syntax to use near

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related