Grouping MySQL query by date

Posted by & filed under Computers & Internet.

Working on a statistics plugin I needed a way to group records by the day.  Turns out it’s remarkably easy. If you just want to group by year and month take off the DAY() part.  This would also be a good query to use WEEK() on to pull records grouped by the week they were… Read more »

A routine to create GUIDs in PHP

Posted by & filed under Programming.

During development of an online application, I needed a way to generate a GUID. I’m sure there are other, better ways to do this. But, this is how I decided to do it.