getting a range of records

[jack.johnson.87]

i don't have any experience with writing php but we use this line in the browser window, so I'm hoping that someone here can help:

www.mysite.com/admin/user.php?action=Modify&ID=1234

That pulls up one record, but sometimes I want to look at a range like 1229-1234.  Is there a way that line can be formatted to display the range?

Thanks,

JJ

[RobinTibbs]

perhaps have two variables in the url with the start and end of range and use those, as so

[code]
htttp://www.mysite.com/admin/user.php?action=Modify&minID=1&maxID=56
[/code]

then (in psedocode, my mysql is a little rusty)
[code]
SELECT * from <table> WHERE id >= <minId> & id <=>maxID
[/code]

just a thought :) hope it helps

[dgiberson]

Robin's code will work, here is an alternative:

SELECT * FROM table
WHERE < condition statements here>
ORDER BY <whatever>
LIMIT 1229, 5