Archive for March, 2008
PHP & MySQL Tip #2 – Better Way of Pagination
I've seen this come up a few times in #php on irc.gamesurge.net - how to find the total number of rows found, while using the LIMIT clause on a query.
I've seen people respond with some seriously incorrect solutions, such as 'Simply load all of the results into an array and only show X amount' or 'Simple run another query without the LIMIT clause and count those rows.'
Those two, common, solutions are sadly not the best solution.
Read on to discover my solution.
Problem Solving – guide to PHP programming and debugging.
Problem solving forms part of thinking.
Interesting... so, if so many web devs and IT personnel have such a problem with problem solving, perhaps they're just not thinking? Let's explore some of the problems I've seen people encounter, and how I was baffled they lacked the problem solving skills to complete their tasks.
Most Popular Posts
Most Recent
- RockMelt Browser – Future of Browsers?
- Adding Syntax Highlighting – Yay!
- PHP Tip: Handling Form Data
- Q&A: Which Framework Should I Use?
- Make an Impact
- Someone Failed to Inform Me
- Modrewrite and Short Urls – What you really want to know.
- Professional PHP
- Google Speaks on Net Neutrality and Benefits of caching
- Screen Scraping made too easy
Categories
- Computers (4)
- JavaScript (1)
- MySQL (3)
- Personal Life (4)
- PHP (9)
- Software Development (6)
- Technology (3)
- Tips (5)
- Tutorials (1)
- Uncategorized (3)
- Web Development (10)
- Work Life (1)