my following code is like this:
$places = DivePlace::selectRaw("*,(st_distance_sphere( POINT(".$lon.",".$lat.") , point(lon, lat))/1000) as distance")
->havingRaw("distance < ".$radius)
->orderBy("distance")
->paginate(10);
without the "havingRaw" everything is good. After adding it, the following error came up:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'distance' in 'having clause' (SQL: select count(*) as aggregate from
dive_places
having distance < 300)
Any solution?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire