Reputation:

Mysql Result Return Problem

I'm creating a project in FuelPHP, with php + mysql. I have this database query (I'm not using their built in query builder because its just a pain in the ass for complex queries).

$sql = DB::query('
    SELECT game_id, lati, longi,
       acos(sin    (' . $lat .  ') 
     * sin (radians(    lati     ))
     + cos         (' . $lat .  ') 
     * cos (radians(lati)) 
     * cos (radians(longi) - ' . $lon . ')) 
     *' . $R . ' AS D 
        FROM (
            SELECT game_id, lati, longi
            FROM games 
            WHERE lati > ' . $minLat . 
        ' AND lati <' . $maxLat . 
        ' AND  longi > ' . $minLon . 
        ' AND longi < ' . $maxLon . 
        ') AS firstcut
            WHERE 
                acos(sin    (' . $lat .  ') 
     * sin (radians(    lati     ))
     + cos         (' . $lat .  ') 
     * cos (radians(lati)) 
     * cos (radians(longi) - ' . $lon . ')) 
     *' . $R . '<' . $rad . 
     ' ORDER BY D');

If I execute this and print_r(result) the number of rows is displayed i.e 2.

However I cant treat, or convert this result into an array, so I cant

foreach($result as $row) { echo $row['id'] . ' + ' . $row['D']}

Or something similar.

If I paste this code and replace the php variables with real values into phpmyadmin, I get the green 'The query was executed successfully' message but no rows are returned (two rows should be returned, there is not even a 'This query returned zero rows' message). I dont have much experience with this kind of nested/complex sql queries, so any help would be appreciated.

Thanks.

Upvotes: 1