how to write syntax in sql like that ? because i have an error in this. (with php)

Question

SELECT * FROM posts ORDER BY `posts`.`postid` DESC WHERE postid < ".$_POST['last_video_id']." LIMIT 8 ;

Well your order by is in the wrong place and you have SQL injection problem... what is the error exactly? — Alex Barker, Oct 27 '20 at 18:02

score 1 · Answer 1 · answered Oct 27 '20 at 18:03

1

You have to put the conditions in your query in the correct order

SELECT * 
FROM posts 
WHERE postid < ?
ORDER BY postid DESC 
LIMIT 8

And you should use prepared statements that savely fill the parameters in your query.

answered Oct 27 '20 at 18:03

juergen d

1 Answers1