if ($iets == "" && $_GET["hulp"] != "1")
{
echo '';
}
else
{
$page = $_GET["page"];
if ($page == "")
{ $page = "1"; }
$num = $_GET["numpage"];
if ( $num != "12" && $num != "24" && $num != "48")
{
$num = "12";
}
if ($num == "")
{ $num = "12"; }
$begin = ($page-1) * $num;
$sql = "SELECT *
FROM stock
WHERE Subject LIKE '%" . $iets . "%'
ORDER BY ID ASC, Location ASC LIMIT $begin, $num";
$res = mysql_query($sql,$link);
$num_rows = mysql_num_rows($res);
$sql2 = "SELECT *
FROM stock
WHERE Subject LIKE '%" . $iets . "%' ";
$res2 = mysql_query($sql2,$link);
$total_records = mysql_num_rows($res2);
$total_pages = ceil($total_records / $num);
if ($res && $num_rows >= 1)
{
echo '
| Page: ';
for ($i=1; $i<=$total_pages; $i++) {
if ($page == $i)
{ echo ''.$i.' '; }
else
{
echo ''.$i.' ';
}
};
echo ' |
Click image thumbnail to enlarge Displaying '.$num_rows.' of '.$total_records.' ';
if ($num_rows == 1)
{ echo 'photo'; }
else
{ echo 'photos'; }
echo ' matching your criteria:';
echo '
|
';
echo '';
$var = $_SERVER['REQUEST_URI'];
$adres = substr_replace($var, 'paintview', 0, 6);
$count = 0;
while ($row = mysql_fetch_array($res))
{
if ($count == 4)
{
echo '
';
$count = 0;
}
$count = $count + 1;
echo ' Info | Buy | ';
}
echo '
';
echo ' All pictures copyright © by the photographer |
| Page: ';
for ($i=1; $i<=$total_pages; $i++) {
if ($page == $i)
{ echo ''.$i.' '; }
else
{
echo ''.$i.' ';
}
};
echo ' |