<? 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