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
SQL Snippet: Update table field using a join using SQL
Comment
Lighting Hospital UK – Landing Page
I recently did a holding page for the Lighting Hospital UK, it was a basic page prior to a full website being built. Unfortunatly I didn’t have the time to built the full site due to AIAM100 commitments, however the landing page which I built in a day was the direction I would have wanted to go in.
This nature of this site lends itself for some nice flash experimental pieces, so it would have been nice to dabble.
Anyway this was just built using CSS and incorporates the recent CSS3 border-radius property… love it!
