Error in MySQL Syntax with WHERE clause

Question

could you check and tell me where i have made a mistake? Here is the code:

$sql = "SELECT prekės.* , CONCAT(vartotojai.name) as v_name
        FROM prekės 
            LEFT JOIN vartotojai
            ON vartotojai.V_ID=prekės.V_ID
        ORDER BY prekės.date
        LIMIT $offset, $rec_limit
        WHERE prekės.category='Telefonai'";

The error comes from the last line with WHERE clause.

select from join where order limit

juergen d
– juergen d

2014-05-20 00:18:10 +00:00
Commented May 20, 2014 at 0:18 — juergen d
– juergen d, Commented May 20, 2014 at 0:18

souslov · Accepted Answer · 2014-05-20 00:20:33Z

3

Clause order is incorrect : WHERE -> ORDER -> LIMIT :

$sql = "SELECT prekės.*
             , CONCAT(vartotojai.name) as v_name
        FROM prekės LEFT JOIN vartotojai ON vartotojai.V_ID=prekės.V_ID
        WHERE prekės.category='Telefonai'
        ORDER BY prekės.date
        LIMIT $offset, $rec_limit
       ";

answered May 20, 2014 at 0:20

souslov

44.7k11 gold badges92 silver badges113 bronze badges

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

Comments

smcjones · Accepted Answer · 2014-05-20 00:18:53Z

1

Check the order. ORDER and LIMIT should go after WHERE.

In order to ensure you are crafting well designed SQL, it is a good idea to check the link I provided. Once you get it, it's actually quite easy to understand the why of it.

answered May 20, 2014 at 0:18

smcjones

5,6411 gold badge25 silver badges43 bronze badges

1 Comment

Barmar Over a year ago

Also ORDER BY has to be after `WHERE.

Collectives™ on Stack Overflow

Error in MySQL Syntax with WHERE clause

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related