Retrieving data in Ascending order In PHP5 MySQL

Question

if($limit== '400'){
    $sql="SELECT * FROM report ORDER BY reportID ASC LIMIT $limit WHERE userID='$reportID'";}

says "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE userID='147'' at line 1".

Anybody who can help me. I'm a beginner in php programming language.

score 1 · Answer 1 · answered May 31 '19 at 13:27

1

Where clause should be come before the Order By

Try this:

if($limit== '400'){
    $sql="SELECT * FROM report WHERE userID='$reportID' ORDER BY reportID ASC LIMIT $limit";
}

answered May 31 '19 at 13:27

Vikash Pathak

3,444
1
18
32

Still it's not working! – Eskinder Alemu May 31 '19 at 13:39
what is the error now? – Vikash Pathak May 31 '19 at 13:39
Thank you! now it's working! – Eskinder Alemu May 31 '19 at 14:15
You are welcome! glad to hear :) – Vikash Pathak May 31 '19 at 14:16
– Eskinder Alemu May 31 '19 at 14:22
$query = "SELECT * FROM report WHERE cidmid='$cidmID' AND viewd='Not seen'"; – Vikash Pathak May 31 '19 at 14:33
You need to pay attention on mysql syntax and query builder. – Vikash Pathak May 31 '19 at 14:33
Thank you Very much! but still I can't count 'not seen' reports by cidmid it says "Notice: Undefined index: cidmid in C:\xampp\htdocs\AA\reports.php on line 58" and php $cidmID =$_SESSION['cidmid'];is not working – Eskinder Alemu May 31 '19 at 16:50
@Eskinder you comments not related to the question you asked. This the issue in application logic. Try to debug and correct that. – Vikash Pathak May 31 '19 at 22:16
Also try search for topic ` handling session in php` might help you understand and fix the session issue. – Vikash Pathak May 31 '19 at 22:18

Retrieving data in Ascending order In PHP5 MySQL

1 Answers1