Problema con el Maximum execution time of 30 seconds

[helthon]

Hola _Radamantis_
puede ser lo que dices pero me pongo a revisar el codigo y veo que todos mis while estan cerrados. muestro el codigo haber si se me a pasado algo,

Código PHP:

  $consultacategoria = mysql_query ("SELECT DISTINCT nombre , id_categoria FROM categoria ", $dbh);  
$shtml="<table> "; 
$shtml=$shtml."  <tr>"; 
$shtml=$shtml."    <td>idCategoria</td>"; 
$shtml=$shtml."    <td>Nombre Categoria </td>"; 
$shtml=$shtml."  </tr>"; 
while($cat_empresa = mysql_fetch_array($consultacategoria))  
{      
//$idtablacategoria = $cat_empresa['id_categoria']; 
$shtml=$shtml."  <tr>"; 
$shtml=$shtml."    <td>".$cat_empresa['id_categoria']."</td>"; 
$shtml=$shtml."       <td>".$cat_empresa['nombre']."</td>"; 
$shtml=$shtml."     </tr>"; 
$shtml=$shtml."     <tr>"; 
$shtml=$shtml."       <td>&nbsp;</td>"; 
$shtml=$shtml."       <td>"; 
 
    $consultaempresa = mysql_query ("SELECT cat_empresa.id_categoria, cat_empresa.id_empresa, empresa.id_empresa, empresa.razonsocial, empresa.direccion, empresa.distrito, empresa.telefono, empresa.fax, empresa.email, empresa.website, empresa.giro 
    FROM cat_empresa 
    INNER JOIN empresa ON cat_empresa.id_empresa = empresa.id_empresa 
    WHERE cat_empresa.id_categoria = '$cat_empresa[id_categoria]' ", $dbh); 
    while($row_empresa = mysql_fetch_array($consultaempresa))   
    { 
$shtml=$shtml."<table cellpadding=\"1\" cellspacing=\"1\">"; 
/* 
$shtml=$shtml."       <tr>"; 
$shtml=$shtml."         <td >idcategoria</td>"; 
$shtml=$shtml."         <td >".$row_empresa['id_categoria']."</td>"; 
$shtml=$shtml."       </tr>"; 
$shtml=$shtml."       <tr>"; 
$shtml=$shtml."         <td>idempresa</td>"; 
$shtml=$shtml."         <td>".$row_empresa['id_empresa']."</td>"; 
$shtml=$shtml."       </tr>"; */ 
$shtml=$shtml."       <tr>"; 
$shtml=$shtml."         <td>Empresa</td>"; 
$shtml=$shtml."         <td>".$row_empresa['razonsocial']."</td>"; 
$shtml=$shtml."       </tr>"; 
$shtml=$shtml."       <tr>"; 
$shtml=$shtml."         <td>Direccion</td>"; 
$shtml=$shtml."         <td>".$row_empresa['direccion']."</td>"; 
$shtml=$shtml."       </tr>"; 
$shtml=$shtml."       <tr>"; 
$shtml=$shtml."         <td>Distrito</td>"; 
$shtml=$shtml."         <td>".$row_empresa['distrito']."</td>"; 
$shtml=$shtml."       </tr>"; 
$shtml=$shtml."       <tr>"; 
$shtml=$shtml."         <td>Telefono</td>"; 
$shtml=$shtml."         <td>".$row_empresa['telefono']."</td>"; 
$shtml=$shtml."       </tr>"; 
$shtml=$shtml."       <tr>"; 
$shtml=$shtml."         <td >Fax</td>"; 
$shtml=$shtml."         <td >".$row_empresa['fax']."</td>"; 
$shtml=$shtml."       </tr>"; 
$shtml=$shtml."       <tr>"; 
$shtml=$shtml."         <td>Email</td>"; 
$shtml=$shtml."         <td>".$row_empresa['email']."</td>"; 
$shtml=$shtml."       </tr>"; 
$shtml=$shtml."       <tr>"; 
$shtml=$shtml."         <td>Web Site</td>"; 
$shtml=$shtml."         <td>".$row_empresa['website']."</td>"; 
$shtml=$shtml."       </tr>"; 
$shtml=$shtml."       <tr>"; 
$shtml=$shtml."         <td>Giro</td>"; 
$shtml=$shtml."         <td>".$row_empresa['giro']."</td>"; 
$shtml=$shtml."       </tr> "; 
$shtml=$shtml."       <tr>"; 
$shtml=$shtml."         <td  bgcolor=\"#666666\">&nbsp;</td>"; 
$shtml=$shtml."         <td  bgcolor=\"#666666\">&nbsp;</td>"; 
$shtml=$shtml."       </tr> "; 
$shtml=$shtml."    </table>"; 
} 
$shtml=$shtml." </td>"; 
$shtml=$shtml."  </tr> "; 
}  
$shtml.="</table>"; 
$scarpetaguardar="excel/"; //carpeta donde guardar el archivo.  
$enlace05 = $scarpeta."exportarempresascategoria.xls"; 
$fpec = fopen($enlace05,"w"); 
fwrite($fpec,$shtml);  
fclose($fpec);