<?php
require_once("mainfile.php");
include ("config.php");
global $dbi;

$msql = "select cedula from devolucion_carpeta order by id";
$file = mysql_query($msql, $dbi);	
if($file)
{
         while(list($cedula) = mysql_fetch_array($file))
           {
                $sql = "select * from cobranzas where cedula = $cedula";
                $control = mysql_query($sql, $dbi);
                if($control)
                {				 
                        $modi = "update cobranzas set estado = '' where cedula = $cedula";
                        mysql_query($modi, $dbi);
                } 	
           }
}		
?>