SQLSTATE[42000]: Syntax error or access violation: 1064 in sql select statement

Question

I've just started to learn PHP. What I am trying to do a very simple sql select statement-

<?php
    $sql = 'SELECT firstname, lastname,email
           FROM MyGuests
          ORDER BY firstname where id=12';
?>

It gives the following error-

Could not connect to the database testdb :SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax;

Sorry if it's a foolish question.

@s.k.paul You have three answers stating the same thing already (two of which were posted within the same minute of that comment, so were probably being typed as that was) — chris85, Sep 11 '16 at 14:18

score 2 · Answer 1 · edited May 23 '17 at 11:51

2

Switch the ORDER BY and WHERE clauses:

SELECT firstname,
       lastname,
       email
FROM MyGuests
WHERE id = 12
ORDER BY firstname

Here is a useful Stack Overflow question which lists the order of interpretation of a MySQL statement:

edited May 23 '17 at 11:51

Community

answered Sep 11 '16 at 14:01

Tim Biegeleisen

score 1 · Accepted Answer · answered Sep 11 '16 at 14:01

Your query is in the wrong order, order by needs to be after the where.

SELECT firstname, lastname,email
           FROM MyGuests
          where id=12
ORDER BY firstname

You can see the order for all functions in the manual, http://dev.mysql.com/doc/refman/5.7/en/select.html.

score 1 · Answer 3 · answered Sep 11 '16 at 14:03

1

You got the syntax wrong..

SELECT..
FROM..
WHERE..
GROUP BY..
ORDER BY ..

So:

SELECT firstname, lastname,email
FROM MyGuests
where id=12
ORDER BY firstname

answered Sep 11 '16 at 14:03

sagi

3 Answers3