/home » workblog

Entries for the ‘MySQL’ Category

Natural Sorting for MySQL

Feb.22, 2010 in MySQL, PHP Leave a Comment

MySQL doesn’t provide a way to perform natural sorting on a string, so if you have numbers in your data you may get results like this
Product 110
Product 120
Product 13
Product 140
There are a lot of hacks available, but all of the ones I’ve seen only work in specific circumstances. The only comprehensive solution I found to [...]

Passing dates and times between PHP and MySQL

Sep.02, 2009 in MySQL, PHP Leave a Comment

Richard Lord wrote a good article explaining the various ways of handling dates and times with PHP and MySQL.

  

My name is Ian Dunn and I'm a web developer for mPango Development Studios in Dayton, Ohio. I started this blog to document solutions/tips/tricks that I may need again in the future. Hopefully it'll also be useful to other people who are searching for the same information.

I'm currently looking to relocate to the Seattle area, so let me know if you're looking for a PHP/MySQL developer or network technician.