Incrementing a counter in the database

[eluser]CI Simon[/eluser]
Oops 4.1.20 is the live database. Ive tried so many ways of doing this and they all seem to work locally and not live.

This also works locally but not live:

Code:

if ($query->num_rows() > 0) {

            foreach ($query->result() as $advertisers) {
                
                    $advertiser_id_array[] = $advertisers->id;
    
                    $output .= $advertisers->company_email;
                    $output .= ", ";
                    
                    $count = $advertisers->company_count;
                    $count = $count + 1;
                    
                    $sql = "UPDATE fq_company SET company_count = '$count' WHERE id = '$advertisers->id'";
                    $this->db->query($sql);
                    
                }
            
            $output = substr ($output, 0, -2);
            
        
        }