placing SQL order by (simple)

Question

I'm trying to order the following results on reference. Using Order by and desc limit 100. Can someone help me where to place it.

$stm = $pdo->prepare("SELECT `reference`, SUM( `stockdifference` ) AS 'stockdifference'  
FROM `results1` 
WHERE `datum` BETWEEN '".$oldDate."' AND '".$newDate."' AND `reference` = '".$stm[0]."'");

Do `GROUP BY reference` as well, after WHERE and before ORDER BY. — jarlh, Dec 08 '16 at 13:06
comment repost: there's nothing here "to" prepare since there's no placeholders in your query. So just do `query` instead of `prepare`. — Funk Forty Niner, Dec 08 '16 at 13:08

score 0 · Answer 1 · answered Dec 08 '16 at 13:01

0

To order a sql query is simple.

Select *
FROM table
Where column=condition
ORDER BY column desc/asc
Limit

answered Dec 08 '16 at 13:01

are you sure he is asking about the SQL syntax and not about how to write the PDO parameters? – Dragos Dec 08 '16 at 13:02

score -1 · Answer 2 · answered Dec 08 '16 at 13:06

-1

try :

<?php 
$stm = $pdo->prepare("SELECT `reference`, SUM( `stockdifference` ) AS 'stockdifference'  
FROM `results1` 
WHERE `datum` BETWEEN '".$oldDate."' AND '".$newDate."' AND `reference` = '".$stm[0]."'
Order by 'your column',
'your column' desc,
limit 100

");

answered Dec 08 '16 at 13:06

nimour pristou

143
1
8

what exactly are you preparing ? Where are the parameters? – Dragos Dec 08 '16 at 15:31

placing SQL order by (simple)

2 Answers2