PHP and MySQL Versions

Over the last few weeks as the sponsors have been using Tasks Pro™, most of the issues I’ve been dealing with have been due to differences in PHP and MySQL versions.

Just a reminder to all you developers out there, don’t underestimate the importance of testing on a variety of platforms and configurations.

In particular, I’ve had a number of PHP session handling issues. Also, MySQL 4 allows you to do a JOIN during an UPDATE; MySQL 3.23 doesn’t.

There are a lot of moving parts for LAMP web developers:

  • Browser rendering and JavaScript differences
  • PHP and MySQL version irregularities
  • Server platform differences (Linux/Mac OX X vs. Windows)

There is no magic bullet – read, code and test…