include "conf.php";
include "head.html";
$hostname = "localhost";
$username = "vva";
$password = "olis34x";
$dbName = "uz_vva";
$userstable = "crimea_photo";
MYSQL_CONNECT($hostname,$username,$password) OR DIE("Не могу создать соединение ");
@mysql_select_db("$dbName") or die("Не могу выбрать базу данных ");
################################
Function Tab ($query) {
$result = MYSQL_QUERY($query);
echo '
';
$k=MYSQL_NUMROWS($result);
for ($i=0;$i<5;$i++){
if ( $i < $k ) {
$id = mysql_result($result,$i,"id");
$user_filename_s = mysql_result($result,$i,"user_filename_s");
echo "
| ";};
if ( $i >= $k ) { echo " | ";};
}; # for i<5
echo '
';
for ($i=0;$i<5;$i++){
if ( $i < $k ) {
$photo_name = mysql_result($result,$i,"photo_name");
echo "$photo_name | ";};
if ( $i >= $k ) { echo " | ";};
}; # for i<5
echo '
';
}; # Tab
################################
#echo "Новые";
#$query = "SELECT * FROM $userstable WHERE p > 0 and razdel = \"$razdel\" order by id DESC LIMIT 0, 5";
#Tab($query);
#echo "Лучшие";
#$query = "SELECT * FROM $userstable WHERE p > 0 and razdel = \"$razdel\" order by p ASC LIMIT 0, 5";
#Tab($query);
#echo "Все";
$query = "SELECT id FROM $userstable WHERE p > 0 and razdel = \"$razdel\"";
$result = MYSQL_QUERY($query);
$k=MYSQL_NUMROWS($result);
if ( $str < 1 ) { $r="6";$r0="0"; };
if ( $str >= 1 ) {
#$r=intval($k/5);$g=$k%5; if ( $k%5 != 0 ) { $r++; };
if ( $str * 30 <= $k ) { $r="6";$r0=$str*30; };
if ( $str * 30 > $k ) { $r=intval($k/5);$r0=$str*30; };
};
#echo "str=$str r=$r r0=$r0 k=$k";
echo '';
for ($i=0;$i<$r;$i++) {
$l=$r0+$i*5;
$query = "SELECT * FROM $userstable WHERE p > 0 and razdel = \"$razdel\" order by id DESC LIMIT $l, 5";
Tab($query);
}; # for i';
echo "Страница: ";
$i=0;$sstr=intval($k / 30);
WHILE ($i <= $sstr) {
$l=$i+1;
echo "$l ";
$i++;
}; # WHILE
echo "
";
include "tail.html";
?>