Thursday, October 30, 2014

Friday, October 24, 2014

Thursday, October 23, 2014

Wednesday, October 22, 2014

Nearest-location finder radius for MySQL

Standard
CREATE TABLE IF NOT EXISTS `location` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `iso` varchar(50) DEFAULT NULL, `local_name` varchar(255) DEFAULT NULL, `type` char(2) DEFAULT NULL, `in_location` int(11) unsigned DEFAULT NULL, `geo_lat` double(18,11) DEFAULT NULL, `geo_lng`...