<?php if (eregi("block-Not.php", $_SERVER['PHP_SELF'])) { Header("Location: index.php"); die(); } global $prefix, $db; echo "<link rel='stylesheet' href='themes/proclassbasic/style/style_ud.css' type='text/css'>"; echo"<table width='480' border='0' cellspacing='0' cellpadding='0' height='14'> <tr> <td> <form method='post' action='http://webmail.criarsites.com.br:82/cgi-bin/openwebmail/openwebmail.pl?' target='_blank' enctype='application/x-www-form-urlencoded' name='login'> <table align=center border=0 cellspacing=0 cellpadding=0 width='100%' height='15%' class='borda_email'> <tr> <td align=right nowrap width='87' height='2'> <div align='left'><font size='2' face='Geneva, Arial, Helvetica, san-serif'><img src='themes/proclassbasic/images/seikogan_layout_index_01.jpg' width='81' height='23'></font></div> </td> <td align=right nowrap width='57' height='2'><font size='2' face='Geneva, Arial, Helvetica, san-serif'>E-mail: </font></td> <td align=left width='108' height='2'> <input type='text' name='loginname' size='16' onChange='focuspwd()' style='background-color: rgb(204,204,204); border: 1px line'/> </td> <td align=left width='54' height='2'><font size='2' face='Geneva, Arial, Helvetica, san-serif'>Senha</font>:</td> <td align=left width='103' height='2'> <input type='password' name='password' size='16' onChange='focusloginbutton()' style='background-color: rgb(204,204,204); border: 1px line' /> </td> <td align=left width='50' height='2'> <div align='center'> <input type='submit' name='loginbutton' value='ok' style='background-color: rgb(204,204,204); border: 1px line' /> </div> </td> <td align=left width='64' height='2'><font size='1' face='Geneva, Arial, Helvetica, san-serif'>lembrar</font></td> <td align=left width='256' height='2'> <input type='checkbox' name='rememberme' value='1' style='background-color: rgb(204,204,204); border: 1px line' /> </td> </tr> </table> </form> </td> </tr> </table>"; $pid = intval($row['pid']); $prefix0 = $db->sql_query("SELECT pid, title, page_header FROM " . $prefix . "_pages WHERE active='1' ORDER BY pid DESC" ); $k='1'; while ($row = $db->sql_fetchrow($prefix0) AND $k <=1 ){ $pid= intval($row['pid']); $title = stripslashes($row['title']); if($pid <= '100'){ echo "<table width='400' border='0' cellspacing='0' cellpadding='0'> <tr> <td class='topo_mestre'><a href='modules.php?name=Content&pa=showpage&pid=$pid'><font size='4' class='footmsg'>$title </font></a></td> </tr> </table>"; } $k=$k+1; } echo "<table width='8%' border='0' cellspacing='0' cellpadding='0' align='left'> <tr> <td><img src='$imagem' width='120' height='107' border='1'></td> </tr> </table>"; $prefix1 = $db->sql_query("SELECT pid, title, page_header FROM " . $prefix . "_pages WHERE active='1' ORDER BY pid DESC" ); $k='1'; while ($row = $db->sql_fetchrow($prefix1) AND $k <=8) { $pid = intval($row['pid']); $title = stripslashes($row['title']); if($pid <='100'){ echo "<table width='350' border='0' cellspacing='0' cellpadding='0'> <tr> <td width='26'><img src='themes/proclassbasic/images/seta_03.gif' width='14' height='5'></td> <td width='374' class='borda'><a href=modules.php?name=Content&pa=showpage&pid=$pid><font face='Geneva, Arial, Helvetica, san-serif' size='2'>$title</font></a></td> </tr> </table>"; } $k=$k+1; } echo"<br><br><table width='480' border='0' cellspacing='1' cellpadding='0' class='borda2'> <tr> <td width='11%' background='themes/proclassbasic/images/back_fundo.jpg'> <table width='99%' border='0' cellspacing='0' cellpadding='0' bgcolor='#FFFFFF'> <tr> <td width='9%' background='themes/proclassbasic/images/back_fundo.jpg' class='texto_corpo' height='2'><img src='themes/proclassbasic/images/bto_planos.jpg' width='100' height='16'> <td width='84%' height='2'> <span class='texto_letras'> <a href='modules.php?name=Planos'><span class='texto_letras'>Conheça os planos de hospedagem que a Criar oferece</span></a>.</span></td> <td width='7%' background='themes/proclassbasic/images/back_fundo.jpg' height='2'> </td> </tr> </table> </td> </tr> </table>"; //SELECT * FROM TABELA ORDER BY rand() LIMIT 1 $pid = intval($row['pid']); $case0 = $db->sql_query("SELECT pid, title, page_header FROM nuke_pages WHERE pid = '$pid' ORDER BY pid DESC"); $k='1'; while ($row = $db->sql_fetchrow($case0) AND $k <=1){ $pid = intval($row['pid']); $title = stripslashes($row['title']); $page_header = $row['page_header']; echo "<br><table width='240' border='0' cellspacing='0' cellpadding='0' align='left'> <tr> <td width='55' background='themes/proclassbasic/images/top_news.gif'> <div align='center'><font color='#FFFFFF'><b class='letras_home'><a href='modules.php?name=Content&pa=showpage&pid=$pid'> $title</a></b></font></div> </td> <td bgcolor='#999999' width='185'><font color='#FFFFFF'><b class='letras_home'> </b></font></td> </tr> <tr background='themes/proclassbasic/images/back_0.jpg'> <td class='borda3' colspan='2'><font face='Geneva, Arial, Helvetica, san-serif' size='2' color='#000000'>$page_header</font></td> </tr> </table>"; $k=$k+1; } $case1 = $db->sql_query("SELECT pid, title, page_header FROM nuke_pages WHERE pid = '$pid' ORDER BY pid DESC"); $k='1'; while ($row = $db->sql_fetchrow($case1) AND $k <=1){ $pid = intval($row['pid']); $title = stripslashes($row['title']); $page_header = $row['page_header']; if($pid <= '100'){ echo "<table width='240' border='0' cellspacing='0' cellpadding='0' align='left'> <tr> <td width='55' background='themes/proclassbasic/images/top_news.gif'> <div align='center'><font color='#FFFFFF'><b class='letras_home'><a href='modules.php?name=Content&pa=showpage&pid=$pid'> $title</a></b></font></div> </td> <td bgcolor='#999999' width='185'><font color='#FFFFFF'><b class='letras_home'> </b></font></td> </tr> <tr background='themes/proclassbasic/images/back_0.jpg'> <td class='borda3' colspan='2'><font face='Geneva, Arial, Helvetica, san-serif' size='2' color='#000000'>$page_header</font></td> </tr> </table>"; } $k=$k+1; } $case2 = $db->sql_query("SELECT pid, title, page_header FROM " . $prefix . "_pages WHERE active='1' ORDER BY pid DESC"); $k='1'; while ($row = $db->sql_fetchrow($case2) AND $k <=1 ){ $pid = intval($row['pid']); $title = stripslashes($row['title']); $page_header = $row['page_header']; if($pid >= '8'){ echo "<br><br><br><br><br><table width='160' border='0' cellspacing='0' cellpadding='0' align='left'> <tr> <td bgcolor='#CCCCCC' width='240'> <div align='center'><font color='#FFFFFF'><b class='letras_home'><a href='modules.php?name=Content&pa=showpage&pid=$pid'> </a></b></font></div> <font color='#FFFFFF'><b class='letras_home'> <a href='modules.php?name=Content&pa=showpage&pid=$pid'>$title</a></b></font></td> </tr> <tr> <td class='borda3' background='themes/proclassbasic/images/back_0.jpg'><font face='Geneva, Arial, Helvetica, san-serif' size='2' color='#000000'>$page_header</font></td> </tr> </table> "; } $k=$k+1; } $case3 = $db->sql_query("SELECT pid, title, page_header FROM " . $prefix . "_pages WHERE active='1' ORDER BY pid DESC"); $k='1'; while ($row = $db->sql_fetchrow($case3) AND $k <=1){ $pid = intval($row['pid']); $title = stripslashes($row['title']); $page_header = $row['page_header']; if($pid <= '100'){ echo "<table width='160' border='0' cellspacing='0' cellpadding='0' align='left'> <tr> <td bgcolor='#CCCCCC' width='240'> <div align='center'><font color='#FFFFFF'><b class='letras_home'><a href='modules.php?name=Content&pa=showpage&pid=$pid'> </a></b></font></div> <font color='#FFFFFF'><b class='letras_home'> <a href='modules.php?name=Content&pa=showpage&pid=$pid'>$title</a></b></font></td> </tr> <tr> <td class='borda3' background='themes/proclassbasic/images/back_0.jpg'><font face='Geneva, Arial, Helvetica, san-serif' size='2' color='#000000'>$page_header</font></td> </tr> </table> "; } $k=$k+1; } $case4 = $db->sql_query("SELECT pid, title, page_header FROM " . $prefix . "_pages WHERE active='1' ORDER BY pid DESC"); $k='1'; while ($row = $db->sql_fetchrow($case4) AND $k <=1){ $pid = intval($row['pid']); $title = stripslashes($row['title']); $page_header = $row['page_header']; if($pid <= '100'){ echo "<table width='160' border='0' cellspacing='0' cellpadding='0' align='left'> <tr> <td bgcolor='#CCCCCC' width='240'> <div align='center'><font color='#FFFFFF'><b class='letras_home'><a href='modules.php?name=Content&pa=showpage&pid=$pid'> </a></b></font></div> <font color='#FFFFFF'><b class='letras_home'> <a href='modules.php?name=Content&pa=showpage&pid=$pid'>$title</a></b></font></td> </tr> <tr> <td class='borda3' background='themes/proclassbasic/images/back_0.jpg'><font face='Geneva, Arial, Helvetica, san-serif' size='2' color='#000000'>$page_header</font></td> </tr> </table><br><br><br><br>"; } $k=$k+1; } ?>
Galera este é o codigo de meu sistema
01
Figura 01
02
Figura 02
Repare que o titulo repete na lista de noticias em baixo........o que eu queria é que ele passasse os valores em seguencia por noticia.....cada um ta numerado de forma decrescente...veeja na figura 01 que o ultimo ID 09 passa pra noticia de baixo com o ID 08......só que só acontece ai......depois não passa mais.......devia passa adiante...a noticia do lado seria o ID 07.....nas tabelas(html) de baixo seria 06 e por ai vai.....só que isso seria de uma forma decrescente para que a cada noticia adicionada seja atualizada.........vese vcsme entendem...desculpe a embolação no coddigo..to começando...
vlw!!