Dobrá, takže tohle je celý kód:
<?php
REQUIRE_ONCE("conf/config.php");
$mysql_link = mysql_connect($MySQL_IP, $MySQL_user, $MySQL_pass);
IF(!$mysql_link){
$mysql_link_error = "TRUE";
$mysql_link_errtext = mysql_error();
}
ELSE{
mysql_select_db($MySQL_DB, $mysql_link);
$mysql_sql_nc = "SELECT * FROM ".$GuestBoard_table." WHERE ID = (SELECT MAX(ID) FROM ".$GuestBoard_table.")";
$mysql_query_nc = mysql_query($mysql_sql_nc);
$str_nc = mysql_fetch_array($mysql_query_nc);
$num_comments = $str_nc['ID'];
IF( ISSET($_GET['cop']) ){
$str_cop = $_GET['cop'];
$str_page = 1;
$page_of_comments = CEIL( $num_comments / $str_cop );
$s_max_cop = $num_comments;
$s_min_cop = $num_comments - $str_cop;
}
ELSE{
$s_max_cop = $num_comments;
$s_min_cop = 0;
}
IF( ISSET($_GET['cop']) && ISSET($_GET['p']) ){
$str_cop = $_GET['cop'];
$str_page = $_GET['p'];
$s_max_cop = ( $num_comments + $str_cop ) - ( $str_cop * $str_page );
$s_min_cop = $s_max_cop - $str_cop;
}
$mysql_sql = "SELECT DATE_FORMAT(timeanddate,'%e. %c. %Y | %H:%i') AS timeanddate, name, email, message FROM ".$GuestBoard_table." WHERE ID>'$s_min_cop' AND ID<='$s_max_cop' ORDER BY ID DESC;";
$mysql_query = mysql_query($mysql_sql);
IF( EMPTY($num_comments) ){
ECHO "<DIV class='nocomments'><BR>[ Žádné příspěvky ]</DIV>\n";
}
ELSE{
WHILE($row = mysql_fetch_array($mysql_query)){
$t_datetime = $row["timeanddate"];
$t_name = $row["name"];
$t_email = $row["email"];
$t_message = $row["message"];
ECHO "\n<DIV class='coverl'>\n";
ECHO "<DIV class='top'>\n";
ECHO "<DIV class='gbtext'>\n";
ECHO "<DIV class='name'><B>".$t_name."</B></DIV>\n";
ECHO "<DIV class='email'>".$t_email."</DIV>\n";
ECHO "<DIV class='datetime'>".$t_datetime."</DIV>\n";
ECHO "<BR><HR>\n";
ECHO "</DIV>\n";
ECHO "</DIV>\n";
ECHO "<DIV class='middle'>\n";
ECHO "<DIV class='gbtext'>".$t_message."</DIV>\n";
ECHO "</DIV>\n";
ECHO "</DIV>\n";
ECHO "<DIV class='space'></DIV>\n\n";
}
IF( ( ISSET($page_of_comments) ) && $page_of_comments > 1 ){
ECHO "<DIV class='pages'>\n";
FOR( $num_page = 1; $num_page <= $page_of_comments; $num_page++ ){
IF($num_page == $str_page){
ECHO "<SPAN style='color: gray;'>[</SPAN>".$num_page."<SPAN style='color: gray;'>]</SPAN>";
}
ELSE{
ECHO "<A href='?str=nastenka&cop=".$str_cop."&p=".$num_page."'>".$num_page."</A>";
}
IF($num_page != $page_of_comments){
ECHO " | ";
}
}
ECHO "</DIV>\n";
}
}
mysql_close($mysql_link);
}
?>
EDIT: A mimochodem, u toho tvého řešení nevidím způsob, jak by se dalo ovlivnit vytažení z databáze,
EDIT2: Tak jsem se pokusil to upravit tak, aby to šetřilo server, snad se mi to povedlo.