What's wrong with my MySql query ?!

Question

This is a query I am doing with mysql using PHP
This is the query line

<?php
$query = "SELECT * FROM node WHERE type = 'student_report' AND uid = '{$uid}' LIMIT 1 ORDER BY created DESC";
?>

I get the following error

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 'ORDER BY created DESC' at line 1

Answer 1

You don't need the curly braces around $uid

If that does not solve it, try putting the LIMIT clause after the order by clause, which is the recommanded way. Source Mysql select syntax.

Answer 2

You need to have the limit clause last.

Answer 3

print the entire sql query ($query), not only $uid and also the LIMIT clause after order by

Answer 4

Your query should be:

$query = "SELECT * FROM node WHERE type = 'student_report' AND uid = $uid ORDER BY created DESC LIMIT 1";