• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Parse error: syntax error, unexpected T_AS in C:\wamp\www\Adreach\application\models\offerModel.php on line 13

#2
[eluser]PhilTem[/eluser]
You've forgotten to but AS distance within a string. Use

Code:
$this->db->select('loc.location_id, ' . ( 3959 * acos( cos( radians($data['area_latitude']) ) *cos( radians( loc.location_lat ) ) * cos( radians( loc.location_long ) - radians($data['area_longitude']) ) +sin( radians($data['area_latitude']) ) * sin( radians( loc.location_lat ) )) ) . " AS `distance`");

Might be that I screwed up with some brackets, but basically $this->db->select() only accepts one parameter which must be the fields you want to select (or any other thing that usually is used with MySQL's SELECT-statement). The second parameter for db->select(), howerver, is to prevent the string to be escaped.

http://ellislab.com/codeigniter/user-gui...ecord.html Part $this->db->select();


Messages In This Thread
Parse error: syntax error, unexpected T_AS in C:\wamp\www\Adreach\application\models\offerModel.php on line 13 - by El Forum - 03-03-2012, 04:34 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.