Passing Results from SQL to Google Maps API in CodeIgniter

[eluser]pickupman[/eluser]
This should do it:
[code]
//Model
function addressForMap($id) {
$this->db->select('b.id, b.busaddress, b.buscity, b.buszip');
$this->db->from('business as b');
$this->db->where('b.id', $id);
$query = $this->db->get();

if($query->num_rows() > 0)
return $query->row();

return FALSE;
}
//Controller
$address = $this->your_model->addressForMap($id); //Get result row

$marker['address'] = ''; //Set default if row is not returned
if(count($address) > 0){
$marker['address'] = $address->busaddress .' '.$address->buscity .', '. $address->buszip;
}