Re: [PHP-DB] UPDATE IF

2011-03-14 Thread Richard Quadling
On 14 March 2011 15:42, Gary wrote: > I have a table in a mysql db that has 3 columns that I want to insert > (update) data if the row&column is empty (IS NULL).  However I want to start > at the first column, if this column is not null, then move to insert the > data into column 2, if that is emp

[PHP-DB] UPDATE IF

2011-03-14 Thread Gary
I have a table in a mysql db that has 3 columns that I want to insert (update) data if the row&column is empty (IS NULL). However I want to start at the first column, if this column is not null, then move to insert the data into column 2, if that is empty, then insert data into column 3. I hav