using ORDER BY id DESC and where

Question

how can i use right code for using ORDER BY id DESC and WHERE

$sel = "SELECT * FROM items where portfolio_id=".$_GET['folio_id']."ORDER BY id DESC";

Welcome to StackOverflow! Without sounding rude, this question could have been avoided with a little patience and research. If you haven't managed to find the problem after hours of debugging, a quick Google search **"mysql where order by"** would have yielded hundreds of examples, tutorials and explanations. — TheCarver, Dec 20 '13 at 19:08
http://stackoverflow.com/questions/13620961/order-by-id-desc?rq=1 — TheCarver, Dec 20 '13 at 19:19

Shankar Narayana Damodaran · Answer 1 · 2013-12-20T18:40:42.920

2

Add a space here as shown.

$sel = "SELECT * FROM items where portfolio_id=".$_GET['folio_id']." ORDER BY id DESC";
                                                                ----^

Also, don't pass your parameters like $_GET or $_POST directly into the SQL query as it will definitely lead to SQL Injection Attacks. Filter those parameters or make use of Prepared Statements.

edited Dec 20 '13 at 18:40

answered Dec 20 '13 at 18:35

Shankar Narayana Damodaran

66,874
43
94
124

Reason for downvote ? – Shankar Narayana Damodaran Dec 20 '13 at 18:53
1

Cannot see a reason for the down-votes. In all fairness, it should be getting up-voted, as it's the only answer that has warned against injection attacks and suggests the use of prepared statements. – TheCarver Dec 20 '13 at 19:24

score 0 · Answer 2 · answered Dec 20 '13 at 18:35

0

add a space before 'ORDER' at least

 $sel = "SELECT * FROM items where portfolio_id=".$_GET['folio_id']." ORDER BY id DESC";

answered Dec 20 '13 at 18:35

blotto

3,237
1
18
18

score 0 · Answer 3 · answered Dec 20 '13 at 18:35

0

You need provide space before ORDER BY

$sel = "SELECT * FROM items where portfolio_id=".$_GET['folio_id']." ORDER BY id DESC";

answered Dec 20 '13 at 18:35

Krish R

22,188
7
49
57

score 0 · Answer 4 · answered Dec 20 '13 at 18:40

0

Simply Use this :

$sel = "SELECT * FROM items where portfolio_id ='$_GET[folio_id]' ORDER BY id DESC";

answered Dec 20 '13 at 18:40

Hassan Sardar

4,153
16
53
91

using ORDER BY id DESC and where

4 Answers4