LIMIT Syntax

[rapmonkey]

Hi, I am using the LIMIT syntax in my PHP script and Have a question.

Here is a snippet of code:

<?php

$query = "SELECT * FROM newnews ORDER BY date DESC LIMIT 4";

?>

This code works, but how would I make it so it skips the first row and only selects the other 3? Thanks for your help. 😃

[enterume]

you can try this:

$query = "SELECT * FROM newnews ORDER BY date DESC LIMIT 1,4";

So it will start from row 2. If you put 0,4, then it will start fromt the begining of yoru result.

Thanks
Louis