Mam taki oto kodzik:
Kod
<?php
mysql_connect('localhost', 'ktos_lol', 'haslo');
mysql_select_db('ktos_lol1');
mysql_query("SET NAMES 'latin2'");
$category = $_GET['category'];
$sql = mysql_query("SELECT `id`, `category`, `name`, `content` FROM `article` WHERE `category` = '".$category."'");
while ($r = mysql_fetch_row($sql)) {
$category = mysql_fetch_row(mysql_query("SELECT `name` FROM `category` WHERE `id` = '".$r[1]."'"));
echo '<center><div id="article">
<div id="title"><h3>'.$r[2].'</h3></div>
<div id="main">'.$r[3].'</div>
<div id="end"></div>
</div></center>';
}
?>
mysql_connect('localhost', 'ktos_lol', 'haslo');
mysql_select_db('ktos_lol1');
mysql_query("SET NAMES 'latin2'");
$category = $_GET['category'];
$sql = mysql_query("SELECT `id`, `category`, `name`, `content` FROM `article` WHERE `category` = '".$category."'");
while ($r = mysql_fetch_row($sql)) {
$category = mysql_fetch_row(mysql_query("SELECT `name` FROM `category` WHERE `id` = '".$r[1]."'"));
echo '<center><div id="article">
<div id="title"><h3>'.$r[2].'</h3></div>
<div id="main">'.$r[3].'</div>
<div id="end"></div>
</div></center>';
}
?>
Jak przekształcić kod i dodać podział na strony?
Ktoś pomoże?
Pozdrawiam