<?
include "conexao.php";
include "config.php";
if(isset($_GET['id']))
{
$idcoment=$_GET['id'];
$sql_foto="SELECT * FROM fotos_pct WHERE id_foto='$idcoment'" or die (mysql_error());
$consulta_foto=mysql_query($sql_foto) or die (mysql_error());
$foto=mysql_fetch_array($consulta_foto) or die (mysql_error());
$query = "SELECT * FROM comentarios WHERE id_coment and id_fot='$idcoment' " or die (mysql_error());
$consulta_query = mysql_query($query)or die (mysql_error());
$num_tr=mysql_num_rows($consulta_query)or die (mysql_error());
$fetch=mysql_fetch_array($consulta_query);
if ($num_tr=='0')
{
echo "<script>window.alert(\"Ainda Não Existe Comentários Nesta Foto! Deixe um Comentário.\");</script>";
echo "<script>window.location='criar_comentario.php?id=$idcoment';</script>";
}
$registros=3;
$pagina=$_GET["num"];
if (is_numeric($pagina))
$inicio=(($pagina-1)*$registros);
else
$inicio=0;
$query = "SELECT * FROM comentarios WHERE id_fot='$idcoment' order by id_coment desc LIMIT $inicio,$registros" or die (mysql_error());
$consulta = mysql_query($query)or die (mysql_error());
$tr=mysql_num_rows($consulta)or die (mysql_error());
$paginas=ceil($num_tr/$registros);
}
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title><? echo "$titulo"; ?></title>
<style type="text/css">
* #content {
min-height:100%;
}
#content {
width:600px;
background-color:#EFECE2;
margin:0 auto;
padding:10px 0 10px 10px;
list-style:none;
}
#content img {
width:400px;
border:10px solid #FFF;
}
#comentar {
width:100px;
text-align:center;
}
#comentar:hover {
background-color:#333;
color:#FFF;
}
#comentar a {
text-decoration:none;
color:#333;
}
#comentar a:hover {
background-color:#333;
color:#FFF;
}
#conteudo {
width:420px;
margin:10px auto;
border:5px solid #FFF;
background-color:#D3CBAF;
}
p {
display:block;
width:350px;
text-align:justify;
background-color:#FFF;
border:2px solid #666;
font-family:Verdana, Geneva, sans-serif;
font-size:14px;
padding:0 10px;
margin:10px;
color:#333;
}
#data {
font-size:11px;
}
#data span {
display:block;
background-color:#EFECE2;
font-family:Verdana, Geneva, sans-serif;
font-size:11px;
color:#900;
font-weight:bold;
margin:0 -10px;
padding:0 10px;
}
#nome {
font-size:11px;
}
#nome span {
display:block;
background-color:#EFECE2;
font-family:Verdana, Geneva, sans-serif;
font-size:11px;
color:#900;
font-weight:bold;
margin:0 -10px;
padding:0 10px;
}
#email {
font-size:11px;
}
#email span {
display:block;
background-color:#EFECE2;
font-family:Verdana, Geneva, sans-serif;
font-size:11px;
color:#900;
font-weight:bold;
margin:0 -10px;
padding:0 10px;
}
#comentario {
font-size:11px;
}
#comentario span {
display:block;
background-color:#EFECE2;
font-family:Verdana, Geneva, sans-serif;
font-size:11px;
color:#900;
font-weight:bold;
margin:0 -10px;
padding:0 10px;
}
#paginacao {
position:relative;
width:600px;
height:25px;
text-align:center;
clear:both;
}
#paginacao a {
border:2px dashed #333;
background-color: #DDD;
font:"Trebuchet MS", Arial, Helvetica, sans-serif;
text-decoration:none;
color:#333;
padding:5px;
}
#paginacao a:hover {
background-color: #333;
color:#FFF;
}
</style>
</head>
<body>
<div id="content" class="gallery clearfix">
<center>
<img src="fotos/fotos/<? echo $foto['imagem']; ?>" / >
<p style="margin-top:0px; width:398px;"><? echo $foto['descricao_foto']; ?></p>
</center>
<center>
<p id="data"> <span>
<center>
Nº de Comentario(os)
</center>
</span>
<center>
<? echo "$num_tr"; ?>
</center>
</p>
<p id="comentar"><span><a href="criar_comentario.php?id=<? echo "$idcoment"; ?>">COMENTAR</a></span></p>
<center>
</center>
<? for($i=0;$i<$tr;$i++){ $reg=mysql_fetch_array($consulta);?>
<div id="conteudo">
<p id="data"><span>Data</span><? echo $reg['data']; ?></p>
<p id="nome"><span>Nome</span><? echo $reg['nome']; ?></p>
<p id="email"><span>E-mail</span><? echo $reg['email']; ?></p>
<p id="comentario"><span>Comentário</span><br>
<? echo $reg['comentario']; ?></p>
</div>
<? } ?>
</center>
<center>
<p style="background-color:#EFECE2; clear:both;"></p>
</center>
<div id="paginacao">
<?php
if($n_maquinas!==0){
if ($pagina>1)
echo "<a href='comentario.php?id=".$idcoment."&num=". ($pagina-1) ."'> << Anterior</a> ";
for ($cont=1;$cont<=$paginas;$cont++)
{
if ($cont==$pagina)
echo $cont." ";
else
echo "<a href='comentario.php?id=".$idcoment."&num=". $cont ."'> $cont</a> ";
}
if ($pagina<$paginas)
echo "<a href='comentario.php?id=".$idcoment."&num=". ($pagina+1) ."'> Próximo >></a> ";
}
?>
</center>
</div>
</div>
</body>
</html>onde que eu to errando se sempre usei essa maneira de consultar o banco, me ajudem por favor
