А такой страницы нет!"; } /*-----------------------------------------*/ $query = "SELECT * FROM $userstable WHERE draft=0 and determination = 'пэчворк' ORDER BY Date DESC LIMIT ".((($_GET['page']-1)*$perpage + 1)-1).", ".$perpage; $res = mysql_query($query) or die(mysql_error()); $number = mysql_num_rows($res); /*-----------------------------TEST----------------------------------------*/ $currentpage = 1; if ($number == 0) { echo "записи в таблице отсутствуют"; } /*----------------------------------- вывод номеров страниц ----------------------*/ else { echo '
';
while ($currentpage <= $page) {
if ($currentpage == $_GET['page']){
if ($tag=="" & $year=="" & $schema==""){
echo ''.$currentpage.' '.' ';
$currentpage += 1;
}
if ($tag<>"" & $year=="" & $schema==""){
echo ''.$currentpage.' '.' ';
$currentpage += 1;
}
if ($tag=="" & $year<>"" & $schema==""){
echo ''.$currentpage.' '.' ';
$currentpage += 1;
}
if ($schema==1 & $tag=="" & $year==""){
echo ''.$currentpage.' '.' ';
$currentpage += 1;
}
}
else {
if ($tag=="" & $year==""){
echo ''.$currentpage.' '.' ';
$currentpage += 1;
}
}
}
}
echo '
';
/*-----------------------------TEST----------------------------------------*/
if ($number == 0) {
echo "Записей нет";
}
/*----------------------------------- вывод галереи ----------------------*/
else {
switch ($_GET['page']){
case 1: {echo '';break;}
case $page: {$prevpage=$page-1;echo '';break;}
default:{$prevpage=$_GET['page']-1;$nextpage=$_GET['page']+1;echo ' ';break;}
}
echo '';
$isvideo = 1;
while ($row = mysql_fetch_array($res)) {
$query1 = "SELECT * FROM $userstable1 WHERE ID_creation = ".$row['id']." ORDER BY ID";
$res1 = mysql_query($query1) or die(mysql_error());
$row1 = mysql_fetch_array($res1);
switch ($isvideo){
case 1: {echo '!['.$row1['alt'].']('.$row1['Large_photo'].' "'.$row1['title'].'")
';
echo '
'; $datearray = date_parse($row['Date']); echo '
';
break; }
case 2: {echo '';
echo '
'; $datearray = date_parse($row['Date']); echo '
';
break; }
case 3: {
switch ($_GET['page']){
case 1: {echo '';
echo '
'; $datearray = date_parse($row['Date']); echo '
';
break; }
case 5: {echo '';
echo '
'; $datearray = date_parse($row['Date']); echo '
';
break; }
case 6: {echo '';
echo '
'; $datearray = date_parse($row['Date']); echo '
';
break; }
case 7: {echo '';
echo '
'; $datearray = date_parse($row['Date']); echo '
';
break; }
case 8: {echo '';
echo '
'; $datearray = date_parse($row['Date']); echo '
';
break; }
}
$isvideo = $isvideo + 1;
}
echo '
';
}
?>
'; $datearray = date_parse($row['Date']); echo '
'.date('d.m.Y',mktime( 0, 0, 0, $datearray[month], $datearray[day], $datearray[year] )).'
';
echo ''; $datearray = date_parse($row['Date']); echo '
'.date('d.m.Y',mktime( 0, 0, 0, $datearray[month], $datearray[day], $datearray[year] )).'
';
echo ''.$row['preview'].'
';
echo '
';
break;}
case 2: {echo '';
echo '
';
break;}
default: {echo '';
echo '
';
echo '
';
break;}} mysql_data_seek($res,$isvideo-1);
break; }
case 4: {echo ''; $datearray = date_parse($row['Date']); echo '
'.date('d.m.Y',mktime( 0, 0, 0, $datearray[month], $datearray[day], $datearray[year] )).'
';
echo ''.$row['preview'].'
'; $datearray = date_parse($row['Date']); echo '
'.date('d.m.Y',mktime( 0, 0, 0, $datearray[month], $datearray[day], $datearray[year] )).'
';
echo ''; $datearray = date_parse($row['Date']); echo '
'.date('d.m.Y',mktime( 0, 0, 0, $datearray[month], $datearray[day], $datearray[year] )).'
';
echo ''.$row['preview'].'
'; $datearray = date_parse($row['Date']); echo '
'.date('d.m.Y',mktime( 0, 0, 0, $datearray[month], $datearray[day], $datearray[year] )).'
';
echo ''.$row['preview'].'
'; $datearray = date_parse($row['Date']); echo '
'.date('d.m.Y',mktime( 0, 0, 0, $datearray[month], $datearray[day], $datearray[year] )).'
';
echo '
