Help with Mysqli and Limits

[runnerjp]

Hi,

 

Im using Mysqli and im trying to limit the results by 10 and order them from last to first from the database.

$sqlhorses = "SELECT Place FROM `*` WHERE `Horse` ='".$db->real_escape_string($row['horse']). "'";

the above works but when i added the limit 6 to the end it shows errors.

 

Can anyone help?

[Barand]

 

the above works

???

[QuickOldCar]

Did you mess up the positions of that wildcard? *

 

I would hope the data already in your database is safe.

$sqlhorses = "SELECT * FROM Place WHERE `Horse` ='".$row['horse']. "' GROUP BY id DESC LIMIT 10";

Sounds like you need pagination, there is an old tutorial here at phpfreaks can follow, but should make it mysqli or pdo

http://www.phpfreaks.com/tutorial/basic-pagination

 

with pagination would also include the startrow

GROUP BY id DESC LIMIT 0,10

GROUP BY id DESC LIMIT 9,10

GROUP BY id DESC LIMIT 19,10

[Barand]

Why the "GROUP BY id"? Don't you mean "ORDER BY id"?

 

Do you want to try recalculating those start record numbers?

first 10: 0 - 9

next 10: 10 - 19

next 10: 20 - 29

[QuickOldCar]

Was a late night, you are right.