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.