Reset Auto Increment with MySQL
Alot of the time when you are working with MySQL you will need a table that has an auto incrementing id field. This is great and usually doesn’t pose you any problems, but i’ve noticed that if you are deleting rows manually alot (as you will during development), then it can get a little confused.
Randomising MySQL results
Today I came across a situtation where I needed to have a particular set of MySQL database results to be in a random order. This was for an image slideshow that was being employed on a new project we are working on, the client wanted a random order to the pictures.
Showing local times with PHP
Here’s a little snippet of PHP that will help anyone grappling with a project that involves (or will be used in) multiple timezones.
onclick vs. onClick
Here’s an annoying one for you. It would appear that the world of cross-browser development has ventured into the dangerous and shark filled waters of grammar. More specifically; capitalisation.
Formatting MySQL datetime with PHP
Hello again, another of my posts of information skimmed off the top of the vast information pile that is my day! These posts are not just for the benefit of anyone who reads them but also for me. I come across so many small tips and methods here and there that I just want to keep a record of them! This post is about formatting a mysql datetime field with php.