ето този код как може да бъде странициран <<1 2 3 >>>
Код:
<?
$connection = mysql_connect("localhost","dbuser","dbpass")
or die("no connect");
mysql_select_db("dbname");
if(!isset($_GET['id'])){
$query = mysql_query("SELECT * FROM tablica ORDER BY id DESC limit 0,5");
$i = 0;
while (list ($i , $title,$text )=mysql_fetch_array ($query)) {
$text_limit="$text";
$text_limit=substr($text,0 , 50);
echo "<a href=?id=$i>$title</a>$text_limit";
$i ++;
}
}
else{
$id=$_GET['id'];
$query = mysql_query("SELECT * FROM tablica WHERE id='$id' ORDER BY id DESC limit 1");
$i = 0;
list ($i , $title,$text)=mysql_fetch_array ($query);
echo "$title $text";
}
?>