include "mysqlconecta.php"; // Conecta ao banco de dados include "mysqlexecuta.php"; // Executa a cláusula SQL $materia=$_GET["manchete"]; $materia=trim($materia); if(empty($materia)){ $sql = "SELECT * FROM noticias ORDER BY data DESC"; $res = mysqlexecuta($id,$sql); $cont=1; while (($row = mysql_fetch_array($res))&& $cont==1) { $materia=$row['manchete']; ++$cont; }} ?>
|
Publicações anteriores: $cont=1; $sql = "SELECT * FROM noticias ORDER BY data DESC "; $res = mysqlexecuta($id,$sql); ?> while ($row = mysql_fetch_array($res)) { if($row[estatus]==ok){ if($row[manchete]!= $materia){ if(($cont == 2)||(11 > $cont)) { ?> ++$cont; } } } } ?> |
$sql = "SELECT * FROM noticias WHERE manchete='$materia'"; $res = mysqlexecuta($id,$sql); while ($row = mysql_fetch_array($res)) { if($row[estatus]==ok){ ?>
|
|