Skip to content

Instantly share code, notes, and snippets.

/gist:576134

Created September 12, 2010 14:03
Show Gist options
  • Save anonymous/576134 to your computer and use it in GitHub Desktop.
Save anonymous/576134 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
<?php require_once('Connections/redeclan.php'); ?>
<?php
mysql_select_db($database_redeclan, $redeclan);
$query_membros_destaque = "SELECT * FROM membros WHERE exibir = 'Sim' AND (destaque = 'Topo' OR destaque = 'Topo/Simples') ORDER BY Rand() LIMIT 4";
$membros_destaque = mysql_query($query_membros_destaque, $redeclan) or die(mysql_error());
$row_membros_destaque = mysql_fetch_assoc($membros_destaque);
$totalRows_membros_destaque = mysql_num_rows($membros_destaque);
if ($totalRows_membros_destaque > 0) {
mysql_select_db($database_redeclan, $redeclan);
$query_categoria_destaque = "SELECT * FROM quinta_categorias WHERE id = ".$row_membros_destaque['id_categoria']."";
$categoria_destaque = mysql_query($query_categoria_destaque, $redeclan) or die(mysql_error());
$row_categoria_destaque = mysql_fetch_assoc($categoria_destaque);
$totalRows_categoria_destaque = mysql_num_rows($categoria_destaque);
mysql_select_db($database_redeclan, $redeclan);
$query_distrito = "SELECT D.uf, C.municipio FROM estados AS D INNER JOIN cidades AS C ON (C.uf = D.uf) WHERE C.id = ".$row_membros_destaque['concelho']."";
$distrito = mysql_query($query_distrito, $redeclan) or die(mysql_error());
$row_distrito = mysql_fetch_assoc($distrito);
$totalRows_distrito = mysql_num_rows($distrito);
}
mysql_select_db($database_redeclan, $redeclan);
$query_membros = "SELECT id, nome, imagem_1 FROM membros WHERE exibir = 'Sim' AND (destaque = 'Simples' OR destaque = 'Topo/Simples') ORDER BY Rand() LIMIT 12";
$membros = mysql_query($query_membros, $redeclan) or die(mysql_error());
$row_membros = mysql_fetch_assoc($membros);
$totalRows_membros = mysql_num_rows($membros);
mysql_select_db($database_redeclan, $redeclan);
$query_texto = "SELECT * FROM textos WHERE id = 1";
$texto = mysql_query($query_texto, $redeclan) or die(mysql_error());
$row_texto = mysql_fetch_assoc($texto);
$totalRows_texto = mysql_num_rows($texto);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="robots" content="Guia Digital de Sergipe, Guia de Sergipe, Guia Comercial, Guia Comercial de Sergipe, Guia Sergipano, Sergipe Guia, Comércio de Sergipe, Comercio Sergipano, Lojas de Sergipe, Lojas de Sergipe, Empresas de Sergipe" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>.:: Comercio Sergipano | Guia Digital do Estado ::.</title>
<style type="text/css">
@import url("css/estilo.css");
</style>
<script type="text/javascript" src="js/menu.js"></script>
<script type="text/javascript" src="js/form.js"></script>
<script type="text/javascript" src="js/ajax.js"></script>
</head>
<body>
<div id="layout">
<div id="topo"><? include("inc_topo.php"); ?></div>
<div id="conteudo">
<? include("inc_destaque.php"); ?>
<p>&nbsp;</p>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div id="lateral">
<?php include("inc_pesquisa.php"); ?>
<?php include("inc_menu.php"); ?>
<?php include("inc_newsletter.php"); ?>
</div></td>
<td valign="top"><div id="centro"> <span class="tituloPage2"><?php echo $row_texto['titulo']; ?></span> <span class="texto"><?php echo $row_texto['texto']; ?></span> <span class="texto"> <span class="tituloPage3">Atividades em destaque</span>
<? include("inc_box.php"); ?>
</span> </div></td>
</tr>
</table>
<p>&nbsp;</p>
</div>
<div id="rodape">
<? include("inc_rodape.php"); ?>
</div>
</div>
</body>
</html>
<?php
mysql_free_result($membros);
mysql_free_result($texto);
mysql_close($redeclan);
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment