include "base.inc";
echo getHtmlEncabezado("Curso IV Medio 1993");
?>
Apellido Paterno |
Nombres |
Fono Casa |
Movil |
Fono Oficina |
E-mail |
$sql = 'SELECT per_apellidopat,
per_apellidomat,
per_nombre,
per_fono_casa,
per_fono_movil,
per_fono_trabajo,
per_fono_trabajo_anexo,
per_email
FROM persona';
if($sort){
$sql.=" ORDER BY $sort";
}
else{
$sql.=" ORDER BY per_apellidopat";
}
$cursor=consultarBD($conn,$sql);
while ($fila=getFilaBD($cursor,MYSQL_NUM)){
if($par == 1){
echo "";
$par=0;
}
else {
echo "
";
$par=1;
}
echo "$fila[0] | ";
echo "$fila[2] | ";
echo "$fila[3] | ";
// Nuevo
$cel=split(",",$fila[4]);
$cels="";
foreach($cel as $celu){
if ( !empty($celu) ){
$cels.="$celu
";
#$emails.="".$user."[at]".$dominio."
";
}
}
echo "$cels | ";
// Hasta aqui
//echo "$fila[4] | ";
$anexo="";
if ($fila[6]){
$anexo = " ($fila[6])";
}
echo "$fila[5]$anexo | ";
$email=split(",",$fila[7]);
$emails="";
foreach($email as $mail){
list($user,$dominio) = split("@",$mail);
if ( !empty($user) ){
$emails.="$user$dominio
";
#$emails.="".$user."[at]".$dominio."
";
}
}
echo "$emails | ";
echo "
\n\n";
}
?>
echo getHtmlFin(); ?>