-
Follow me on Twitter
- @MikeMc68 they should be banned, same as the people who stand in the exit rather than stepping off, blocking people from getting offSeptember 3, 2010 12:31
- My hearing is still fecked from riding the Deaf Machine 3 days ago... its a stupid deathtrap of a bike but very very fun...September 3, 2010 8:24
- built a bridge rectifier for my AC generatorSeptember 2, 2010 9:24
- @mike_1727 with a pint of ale in each hand, progressively lightening themSeptember 2, 2010 8:09
- Just ran another 7km - 2 days in a row... will switch routines and exercise down the pub tomorrowSeptember 2, 2010 7:54
MySQL Archive
-
Joining columns/ concatenate strings in Oracle PLSQL/ MySQL
Posted on August 7, 2009 | 1 CommentJoining columns and results together is really easy in Oracle or MySQL, in both there is the same function – CONCAT(). However you should be aware that there are differences between the databases on how this function works. In MySQL the CONCAT() function works by... -
Google Maps API part 1: Accurate Geocoding for UK Postcodes
Posted on July 3, 2009 | 14 CommentsRecently I had to build a system that would take an address, pass it to google and return latitude and longitude values. The result is then stored for later use and display on Google maps. However, firstly I found that the default XML geocoding service... -
Creating XML from PHP/ MySQL for use with SPRY
Posted on June 3, 2009 | 3 CommentsSo lets say for example you have a table in your database and you want to return some results, pretty easy with PHP/ MySQL and I dare say easy enough with other languages. Now rather than return the results to the page and format them...