How can i skip the first 4 data loops in a foreach php loop?

[John_Betong]

@applytobecome

Why does this not work?

This is what i have that works:

$data = mysqli_query($db, 'SELECT * FROM videos ORDER BY id DESC

Then i wanted to skip the first 0,1,2,3 videos by adding LIMIT 4, 10 but it does not work?

looks like this$data = mysqli_query($db, ‘SELECT * FROM videos ORDER BY id DESC LIMIT 4, 10’);

Did you manage to solve your problem?

I tested your $SQL statement on a database and because you are using DESC it got the last 10 rows:

    $sql = 'SELECT * FROM videos ORDER BY id DESC LIMIT 0, 10'; 
    // id = 3300 .. 3291

    $sql = 'SELECT * FROM videos ORDER BY id DESC LIMIT 4, 10'; 
    // id = 3296 .. 3287

If you want records 5…14 you must use ASC

    $sql = 'SELECT * FROM videos ORDER BY id ASC LIMIT 4, 10'; // 3296 .. 3287
    // id = 5 .. 14 

Special Note:
ASC is the default and therefore no need to declare.