Paging through DB records (DB neutral)

Anon

I would like to know how to page through database records using PHP. I have searched this forum and have not found anything useful except something about "limits" used in MySQL. I really need this to be database nuetral since I may have to use an Access database to run it. I easily found and used ASP code that does this. I have an example of exactly what I need to do here:

http://www15.brinkster.com/amarjaa/nursery/forphp.asp?doll=Tasha

(this was done for a database I had with pics from my doll collection)

I have a table with 10 records that are the picture names. I want to display 6 pics on each page and have next and previous buttons as well as the number of pages of pictures there are displayed. Using the ASP code I found, all I had to do was insert the code into my script and change 1 variable which is the number of records to display per page. I am using an Access database for this particular page, but I have used this exact code with a MySQL database also.

If anyone knows how to do this or knows a site where I can find out how, PLEASE let me know. I really need to find a new web host and I can't find a cheap one that allows ASP scripting. Also, if you know of a web host that offers ASP scripting for less than $10/month (and charges by the month), please fill me in, lol 🙂

Thanks,
Nicole

Anon

Using mysql's "limit" will do the trick but it will only work with mysql. I've created a php program that emulates the behaviour of mysql's "limit" for informix but it would only work with informix. It's hard to create a program that adapts to any db you want to use, especially the thing you want to do. But, if you like I can give you a copy of the code and it's up to you to modify it to work with access, basically it's the same thing anyway.
By the way, I know someone who hosts web sites, but I don't know how much he charge. I'll just give you a follow up if I've contacted him.

Anon

Thank you eloy 😃 I guess I have to stick with ASP for now, lol. I think I found a decent host, but I'm open to any others (including your friend's). Thanks for helping!!

Sincerely,
Nicole

Anon

Glad you've solved your problem. Why are you trying to deploy it to PHP anyway, everyone's into ASP.

Anon

I wanted to use PHP because my web host no longer supports ASP. Then I couldn't find another cheap host with ASP support, but there were many with PHP support. I thought it would be easy to switch, but I need that particular functionality. Thanks for the help and interest 🙂

Anon

try www.myhosting.com for affordable asp hosting. I've had problems getting the asp db's configured correctly, but once I get past that everything works fine.

Anon

Thank you James 🙂 I will check out that site.