You are browsing the archive for MySQL.

Don’t use IsValid in your Doctrine Models – a warning

September 9, 2010 in Doctrine, PHP, Web Development

Recently for a project i’ve been making heavy use of Doctrine. In one of the models I had a method to check to see if the object was valid under a certain set of conditions. I named this function isValid .. and it had 2 params. Little did I know that this was actually overriding [...]

MySQL – Conditional Joins

March 7, 2009 in MySQL

For the most part I’ve used many JOINs in my queries since I leartn how to use them and what they were good for, I much prefer to use an Inner Join over the the Implied join of a WHERE statement. For those who haven’t yet learnt about JOINs you might be using an implied [...]

MySQL – Conditional Updates

March 6, 2009 in MySQL

Just a quick blog post in an update related way, Recently i’ve needed to toggle multiple rows in a database from 1 value to 1 of possible 2 values dependant on the contents of a field on the row. I wasn’t sure if this was possible, so i asked in #PHPWomen IRC Channel and the [...]