RUS / ENG
0){ $page = gmp_strval(gmp_div_q($number, $perpage)) + 1; } else { $page = $number / $perpage; } if ($_GET['page'] > $page){ echo "
А такой страницы нет!"; } /*-----------------------------------------*/ $query = "SELECT * FROM $userstable WHERE determination = 'scrap' 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 ''; /*-----------------------------TEST----------------------------------------*/ if ($number == 0) { echo "Записей нет"; } /*----------------------------------- вывод галереи ----------------------*/ else { echo '
'; 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); echo '
'.$row1['alt'].''; 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 '
'; } ?>