Hello,
Thanks for the tip, I ended up with something like :
function findAllByD($x, $y, $distance = null, $day, $recursive) {
.
$x2 = "`TblClassLocation`.`classLocationLong`";
$y2 = "`TblClassLocation`.`classLocationLat`";
return $this->find('all',array(
'limit'=>'1000',
'order'=>'distance
I did similar MySQL geocoding situation where I had to use HAVING and
ended up with something like this, you'll probably have to tweak it
for your own system.
http://blog.joebeeson.com/wp-content/uploads/2008/08/query.jpg
Sorry it's an image, didn't feel like typing it all back up. The
original
