Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require("config.php");
- $que = mysql_query("SELECT Topics.ID
- FROM Topics
- WHERE ID = '". $_GET[i] ."'");
- while($arr = mysql_fetch_array($que)){
- $totale = $arr['Risposte'] + 1;
- }
- if (floor($totale / 6) == $totale / 6){
- $pag = $totale / 6;
- }
- else{
- $pag = floor($totale / 6) + 1;
- }
- $LimInf += (6*($_GET[page]-1));
- $query = @mysql_query("SELECT Topics.ID, Topics.NICK, Topics.DATA, Topics.ORA, Topics.TITOLO, Topics.TESTO
- FROM Topics
- ORDER BY Topics.Data DESC LIMIT'.$_GET[LimInf].','6'");
- $ID = array();
- $Nick = array();
- $Data = array();
- $Ora = array();
- $Titolo = array();
- $Testo = array();
- while($row = mysql_fetch_array($query))
- {
- $ID[] = $row['ID'];
- $Nick[] = $row['NICK'];
- $Data[] = $row['DATA'];
- $Ora[] = $row['ORA'];
- $Titolo[] = $row['TITOLO'];
- $Testo[] = $row['TESTO'];
- }
- echo "<div id=\"content\">";
- for($i = 0; $i <= sizeof($ID)-1; $i++)
- {
- echo "<div class=\"post\">";
- echo "<h1 class=\"title\"> $Titolo[$i] </h1>";
- echo "<p class=\"nick\"><i>Posted by</i> <b> $Nick[$i] </b> <img src=\"images/PostedBye.jpg\"></p>";
- echo "<p class=\"date\"> <i>On</i> </span> $Data[$i],   <i>At</i> $Ora[$i] </p>";
- echo "<p class=\"entry\"> $Testo[$i] </p>";
- echo "<p class=\"trt\"> <a href=#>Segnala post</a> </p>";
- echo "</div>";
- }
- echo "</div>";
- if ($_GET[p] != $pag){
- $prec = $_GET[page]-1;
- echo "<a href=\"post.php?i=$_GET[i]&page=$prec\">precedente</a>";
- }
- if ($_GET[p] != 1){
- $succ = $_GET[page]+1;
- echo "<a href=\"post.php?i=$_GET[i]&page=$succ\">sucessiva</a>";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement