Date: 05/23/05 (WebDesign)    Keywords: php, mysql, sql, google

Well, it turns out this whole PHP and MySQL project was a heck of a lot easier than I thought.

I have hit one hitch, though. I've looked all over Google for an easy script for using paging with my SQL queries. When all is said and done, this table I'm going to have will have somewhere around 5,000 entries, so I really need to enable paging.

Problem is, all the scripts I've found won't work.

I'm using a somewhat complex SQL statement (it's not just a SELECT * FROM TABLE kind of thing), and I've got all my query display and search functions working correctly. I just need this paging thing to work. I understand the general idea of how the whole function is supposed to work, but I keep getting errors.

If anyone can give me any help at all, I'd really appreciate it. I've totally resorted to cut-and-pasting code and just modifying the SQL statement to work with my existing tables, but it still won't work. I can post code portions if necessary..

Thanks in advance.

Source: http://www.livejournal.com/community/webdesign/887367.html