Select a random row in MySQL

Written by Mfawa Alfred Onen on . Posted in MySQL, PHP

I know this topic is not a new one and I was playing with the solutions out there but most of them just don’t scale for me until I found this interesting was of doing it. It actually involves a three (3) query step process which you can checkout in the PHP script below. I have also attached a zip version of the script.

Hail the Igniter while coding with 2.1.0

Written by Mfawa Alfred Onen on . Posted in PHP


Alright that might not be the most fanciful way of introducing the new Codeigniter 2.1.0 that was just release hours ago.

So really, this release will ease some of the problems encountered in previous versions.At the moment even the documentation on codeigniter website is still at version 2.0.3 which will hopefully be updated by the time most of you read this post. Even though Codeigniter 2.1.0 is more of bug fixes, there are quite a few notable features including Migrations, CUBRID driver, ability to check for  unique fields when using the Form Validation library, ability to now use SSL/TLS authentication with the email library; which means you can connect to GMail out of the box without using third party libraries like PHPMailer or SwiftMailer.