MySQL syntax error

Question

I have a complex query and it was working fine before adding one more line: the working query:

         $query = "SELECT SQL_CALC_FOUND_ROWS *
                    FROM realestate
                    INNER JOIN users ON id_user = users.id
                    LEFT JOIN pic ON id_realestate = realestate.id
                    group by realestate.id
                    ORDER BY {$order}
                    LIMIT 0 , 10";

the value of $order is date DESC

after adding one more line, here is the query:

         $query = "SELECT SQL_CALC_FOUND_ROWS *
                    FROM realestate
                    {$place} 
                    INNER JOIN users ON id_user = users.id
                    LEFT JOIN pic ON id_realestate = realestate.id
                    group by realestate.id
                    ORDER BY {$order}
                    LIMIT 0 , 10";

$place has this value WHERE address =1 the field name address doesn't duplicate in other tables.
I get this mysql error :

  Database query failed: 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
 'INNER JOIN users ON id_user = users.id LEFT JOIN pic ON id_realestate = real' 
  at line 4

Niet the Dark Absol · Accepted Answer · 2012-02-03 01:50:03Z

2

JOIN clauses must come before WHERE clauses. You have your clauses in the wrong order.

answered Feb 3, 2012 at 1:50

Niet the Dark Absol

326k86 gold badges480 silver badges604 bronze badges

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

Comments

mauris · Accepted Answer · 2012-02-03 01:50:37Z

1

According to http://dev.mysql.com/doc/refman/5.0/en/select.html

Table References comes before the WHERE portion. The following should be the correct order:

     $query = "SELECT SQL_CALC_FOUND_ROWS *
                FROM realestate
                INNER JOIN users ON id_user = users.id
                LEFT JOIN pic ON id_realestate = realestate.id
                {$place} 
                group by realestate.id
                ORDER BY {$order}
                LIMIT 0 , 10";

JOIN statements are part of the FROM table references.

answered Feb 3, 2012 at 1:50

mauris

43.6k16 gold badges102 silver badges132 bronze badges

Collectives™ on Stack Overflow

MySQL syntax error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related