Zend MySqli php error

Question

4.00/5 (1 vote)

See more:

Hi I have a Sql statement that I appended , ran it through Control Panel phpMyAdmin, it worked but as soon as I placed it back in my php page, it throws me this error,

'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli prepare error: You have an error in your SQL syntax;

here is my sql

SQL

SELECT
               s.id,
   s.groupId,
               s.name,
               s.managerId,
               s.paymentType,
               s.mustHave,
               s.deleted
           FROM
               dealer_stores s
           INNER JOIN
               users u
           ON
               u.dealerStoreId = s.id
           WHERE userType = 'Rep'

Posted 27-Dec-11 19:43pm

nathan666

Updated 27-Dec-11 19:44pm

Mehdi Gholam

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2011-12-28T10:21:00

Solution 1

Based on the SQL the only thing that quickly comes in mind is that no alias is defined for column userType. Could it be that both tables have this column so the SQL would be ambiguous. So perhaps something like:

SQL

SELECT
 s.id,
 s.groupId,
 s.name,
 s.managerId,
 s.paymentType,
 s.mustHave,
 s.deleted
FROM
   dealer_stores s
 INNER JOIN
   users u
 ON
   u.dealerStoreId = s.id
WHERE u.userType = 'Rep'

Also if you debug through the code, is that the exact statement that is used or is something appended to the SQL string.

Posted 28-Dec-11 10:21am

Wendelius

Comments

[no name] 28-Dec-11 16:46pm

Wow, good eyes ;). So 5 from a cp noob.

Wendelius 28-Dec-11 16:59pm

Thanks, staring 20+ years to SQL develops kinda tunnel vision (in good and bad) :)

RaviRanjanKr 28-Dec-11 17:36pm

Nice Answer Mika, My 5+

Wendelius 28-Dec-11 17:44pm

Thanks Ravi :)