$query = mysql_query ("SELECT * FROM clienti WHERE `activ` = 1 AND `plata_lunara` != 0 AND `tip` = 'retea' AND `nr_contract` != 0 ORDER by nume ASC" );

$emails = array();

while($row = mysql_fetch_array($query)) {

    if (total_plata($row['data_scadenta'],$row['plata_lunara']) >= 1) {

            $email = $row['email'];

            $emails[] = $email;

    }

}