Listing previous 10 records

[DisplayError]

I want to list the previous (minus) 10 records.
classic asp example:  <% do while not rs.eof and i< 7 %>
how to do with php pdo?

My code is this:
<?php
$sqlq=$connectx->prepare("SELECT * FROM lovetree ");
$sqlq->execute();
while($rs = $sqlq->fetch()) {

echo $rs['tree'];

}
?>

Thanks...

[gw1500se]

What do you mean by "previous" 10 records? If you are trying to limit the number of records in your query use LIMIT 10. I'm not sure this is a PHP question as opposed to a MySQL question.

Edited March 25, 2021 by gw1500se

[DisplayError]

I want to list 10 records after the last 10 entrie.
 

[gw1500se]

Then add DESC to the LIMIT clause:

$sqlq=$connectx->prepare("SELECT * FROM lovetree DESC LIMIT 10");

That sorts in descending order which means the rows are upside down so the limit 10 results in the last 10 rows. Note the first row returned was the last row in the table. You may want to resort the resulting array to turn it right side up, if that matters.

Edited March 25, 2021 by gw1500se

[DisplayError]

thank you but this is not the solution.
As if there were no first 10 records - next 10 records will be print to the screen.

$sqlq=$connectx->prepare("SELECT * FROM lovetree WHERE id > -10");
- 10 record go back

[gw1500se]

Sorry, I don't understand what you are asking.

[Barand]

1 hour ago, DisplayError said:

As if there were no first 10 records - next 10 records will be print to the screen.

How can that situation even be possible?

@DisplayError If you tell us what you are trying to do in a clear, logical manner then we can probably help. Otherwise you're on your own.

[dodgeitorelse3]

OP is most likely after rows 11 through 20 (after last 10)

[Barand]

Maybe, but only if the first 10 don't exist ??? -  who can tell?

[DisplayError]

[Barand]

To get the records you highlighted

SELECT id
     , tablex
FROM lovetree
LIMIT 9, 11;

i.e. LIMIT offset, num_recs

However, you probably meant LIMIT 10, 10 but I can only guess.

[DisplayError]

<?PHP Beautiful people, i wish love and health ?> 🖐️