query($query); while ($text = $textos_sql->fetch_assoc()) { $textos[$text['rowid']] = $text['text']; } $query = "SELECT v.rowid, nombre_comercial, slogan_" . $lng_text . " as slogan, email, slogan_cat as lang_check, addr_street, addr_num, addr_floor, addr_other, addr_zip, addr_city, url_base, url_" . $lng_text . " as url, tel_fix, tel_mov, vs.sector_" . $lng_text . " as sector, descripcion_oferta_" . $lng_text . " as descripcion_oferta, descripcion_negocio_" . $lng_text . " as descripcion_negocio, p.description as provincia, map_url FROM ventajas v, ventajas_sectores vs, prov_codes p WHERE v.pagename = '" . $empresa . "' AND v.sector_id_code = vs.rowid AND v.addr_prov_code = p.rowid "; // echo $query; $result = $mysqli->query($query); $company = $result->fetch_assoc(); $address = format_address($company['addr_street'], $company['addr_num'], $company['addr_floor'], $company['addr_other'], $company['addr_zip'], $company['addr_city'], $company['provincia']); $cat=1; $has_map=1; if ($company['map_url']=="") { $has_map=0; } if ($company['lang_check']=="") { $cat=0; } ?> STOP Accidentes - Ventajas de <? echo $company['nombre_comercial']?>
 
'; } else { echo ' style="background:url(\'/imgs/empresa_nav_bar.jpg\')">'; } if ($lng==3) { ?>
: " . $company['descripcion_oferta']?>
' . $company['map_url'] . "

"; ?>
'; } echo ''; if ($company['url']) { echo ''; } echo '

' . $company['nombre_comercial'] . "
\n"; echo $company['slogan'] . '

' . "\n"; if ($company['addr_street']) { echo '
'; // echo ''; echo $address . "

\n"; // echo $address . "

\n"; } if ($company['tel_fix']) { if ($company['tel_fix'][0]=='3') { echo $textos[8] . ': ' . format_telf($company['tel_fix'],3) . "
\n"; } else if ($company['tel_fix'][1]=='0') { echo $textos[8] . ': ' . format_telf($company['tel_fix'],2) . "
\n"; } else { echo $textos[8] . ': ' . format_telf($company['tel_fix'],1) . "
\n"; } } if ($company['tel_mov']) { echo $textos[49] . ': ' . format_telf($company['tel_mov'],2) . "
\n"; } echo "
\n"; if ($company['email']) { echo $textos[9] . ': ' . '' . $company['email'] . '

' . "\n"; } if ($company['url']) { echo $textos[51] . ': ' . '' . $company['url_base'] . '

' . "\n"; } echo "Sector: " . $company['sector']; } else { echo ''; echo ''; echo '
'; if ($company['url']) { echo ''; } echo ''; if ($company['url']) { echo ''; } echo ''; echo '

' . $company['nombre_comercial'] . "
\n"; echo $company['slogan'] . '

' . "\n"; if ($company['addr_street']) { echo '
'; echo ''; echo $address . "

\n"; } if ($company['tel_fix']) { if ($company['tel_fix'][0]=='3') { echo $textos[8] . ': ' . format_telf($company['tel_fix'],3) . "
\n"; } else { echo $textos[8] . ': ' . format_telf($company['tel_fix'],1) . "
\n"; } } if ($company['tel_mov']) { echo $textos[49] . ': ' . format_telf($company['tel_mov'],2) . "
\n"; } echo "
"; if ($company['email']) { echo $textos[9] . ': ' . '' . $company['email'] . '

' . "\n"; } if ($company['url']) { echo '' . $company['url_base'] . '
' . "\n"; } echo "
Sector: " . $company['sector']; echo '



'; } ?>   
2) { echo '

' . $textos[56] . ':
    '; foreach ($files as $file) { if ($file[0] != '.') { echo '
  • ' . $file . '
    • '; } } echo '
'; } } ?>