
include "select_menu.inc"; ?>

if ($show == 1){
$sth = mysql_query("SELECT spot, date, fish, body, name, mail FROM actual WHERE approved = 1 AND id = $id", $dbh);
list($spot, $date, $fish, $body, $name, $mail) = mysql_fetch_row($sth);
$onova = explode("-", $date); $datata = "$onova[2].$onova[1].$onova[0] г.";
echo "
$spot |
$datata |
Улов: $fish |
".stripcslashes($body)." |
";
if ($name) echo "$name ";
if ($mail){
$mail = explode("@", $mail);
?>
}
echo " | ";
}
if ($show == 2){
echo '';
$prodperpage = 20;
settype($st, integer); if (!$st) $st = 0;
$lst1 = mysql_query("SELECT COUNT(id) FROM actual WHERE approved = 1 AND date LIKE '$month%'");
list($N) = mysql_fetch_row($lst1);
for ($i = 0, $j = 1; $i < $N; $i += $prodperpage, $j++) {
$a1 = "";
$a2 = "";
if ($st != $i) {
$a1 = "[";
$a2 = "]";
}
echo "$a1$j$a2 ";
}
echo " | ";
$sth = mysql_query("SELECT id, spot, date, fish, body FROM actual WHERE approved = 1 AND date LIKE '$month%' ORDER BY date DESC LIMIT $st, 20", $dbh);
while(list($id, $spot, $date, $fish, $body) = mysql_fetch_row($sth)) {
$body = substr("$body", 0, 130);
$onova = explode("-", $date); $datata = "$onova[2].$onova[1].$onova[0] г.";
echo "$spot $datata Улов: $fish |
$body... [още] |
| ";
}
}
echo '';
for ($i = 0, $j = 1; $i < $N; $i += $prodperpage, $j++) {
$a1 = "";
$a2 = "";
if ($st != $i) {
$a1 = "[";
$a2 = "]";
}
echo "$a1$j$a2 ";
}
echo " | ";
?>
|
| |
include "arch_menu.php"; ?>
|