MySQL
PHP & MySQL Tip #3
PHP & MySQL Tip #3
I want to share with some of you an easy way to set up your database design in a very flexiable and reliable EAV like model.
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.
PHP and MySQL Tip #1 - Error Checks
I’d like to share with all of you some PHP Tips.
› Continue reading