Skip to content

Tag: limit

Limiting number of reservations per user with PHP and MySQL

My users are able to create a reservation, but I would like to limit it – let’s say one user can make max 5 reservations with “Pending” status, after Admin approves reservation and pending status changes to approve, the user can make another reservation. Pending status is given by default when the user makes the reservation. What I would like

SQL get results 21-30?

This seems like a really simple question but I can’t seem to find information on it. If I have 100 results, and I only want to get the results results between 21 and 30 (from the order my SQL query is grabbing them), how would I accomplish this? Answer You can use this: E.g.,