This is a handy little snippet if you need to update one field (source) in one table (table 1) from the results of a field in a related table (table 2)

UPDATE table1 JOIN table1 ON table1.id = table2.id SET table2.source = table1.source

Funny that everytime I’ve been to Sawtell, just south of Coffs Harbour it’s been overcast or raining, hence I’m not sure why the sign as you drive into the town quoting ‘Welcome to Sunny Sawtell’

After the 3rd attempt at a blog this time I’ve done it properly and installed word press on my server. In the midst of updating my own website (chop.com.au) I thought it best to get a more ‘professional’ blog happening, where I can post little snippets of my professional work as well as general interests.

I’ve currently hacked up the ‘Fluid-Blue‘ theme, so I’ll give credit to them here. However now that I’m poking around in the CSS and PHP I thinking it better to start from scratch, although in saying that the HACK way is easier to get things moving, leaving a little more time on the design… shit I think I better get back to my real website, procrastinating NO….