Or you could use a program like pingQast ::: Ping and shorten URLs that does it all for you if you install a simple plugin, with that you can do split testing and geo-targetting and get complete analytics on your traffic 
Reply To: Php and SQL – Things we can do to make life better