"; $limit = 10; $offset = 0; $sql = "SELECT count(*) as totalcompanies FROM mstcompany"; $data = $company_obj1->getCompanyInfo('' , $sql); $totalcompanies = $data[0]['totalcompanies']; while($offset < $totalcompanies) { $sql = "SELECT * FROM mstcompany LIMIT $limit OFFSET $offset"; $data = $company_obj1->getCompanyInfo('' , $sql); /// $company_obj1->dbdisconnect(); foreach($data as $row) { foreach($row as $field => $value) { $comapnaydata[$field] = $value; } $add = $company2_obj1->AddCompanyInfo($comapnaydata,"mstcompany"); } echo "
"; echo "$offset to ".($offset+$limit)." records inserted successfully."; $offset += $limit; } ?>