ISpyHorses
The ISpyHorses website was created in 2015 as a platform for trading in horses, ponies, vehicles and services. It had an excellent bespoke PHP developer framework (not open source, but the best implementation of MVC that I have met), developed by another agency. I helped with the last few percent to get it to…
Dave Wilcox – yes, this site
Urban Blinds
Urban Blinds is a slickly designed site allowing people easily to order blinds and curtains to suit their exact measurements, with a great range of materials and fittings, at a good price. Plenty of help is available. The site was developed in Silverstripe by some very smart people at Little Giant, and…
Silverstripe for Brian R Richards
In 2011 I started a contract with the great team at Brian R Richards, a branding agency in Newmarket, Auckland. I had never used the Silverstripe PHP CMS when I started, but I was admirably and patiently assisted up the learning curve by an outstanding Silverstripe guru, Damo Mooyman. Brian has a fantastic…
Zend Framework Bank Marketing Database
I had never used Zend Framework before, though had used Symfony with a PHP project a few years earlier. I was asked to be the PHP developer for a new and innovative offering from a well-known NZ bank. So it was a "0-60 in ten minutes" job, and I grew to like…
GoogleMaps and Search for NZ Schools
As preparation for my family's intended emigration to New Zealand in 2008, I thought it would be helpful (and, yes, fun!) to create a map of NZ schools, with some selection by decile. It became an intriguing exercise in juggling technologies. And it succeeded. When I converted this site from Silverstripe into…
Free Telly Guide UK, PHP
I had a great time with PHP and MySQL developing a page to display UK TV listings, which was at www.freetellyguide.co.uk (no longer active). You can select which TV channels to display, you can use free-text search, and look ahead day-by-day for the next week. Most programmes have associated summaries which we…
SQL, update a column with values from another table
I'm always forgetting and re-learning this one. Why won't it stick? Now it's here as an aide-memoire. How to cross-update a field from values in another table. The scenario is: you have an empty column in one table which you want to update with related values in another table. How to choose…