Register Globals

<?
$limit=25; 
$user="****";
$password="****";
$database="****";
$waarde=$_GET["trefwoord"];
mysql_connect(mysqlhost,$user,$password);
@mysql_select_db(****) or die( "Unable to select database");
$query = "select * from doodsprentje where TITEL LIKE \"%$waarde%\" "; 
$numresults=mysql_query($query);
$numrows=mysql_num_rows($numresults);

if (empty($s)) {$s=0;}

$query .= " limit $s,$limit";
$result = mysql_query($query) or die("Couldn't execute query");
$url=$_SERVER['PHP_SELF'];
if ($s>=1) {$prevs=($s-$limit);print "<a href=\"$url?s=$prevs&trefwoord=$waarde\">Vorige afbeeldingen</a>";}

$pages=intval($numrows/$limit);

if ($numrows%$limit) {$pages++;}
$url=$_SERVER['PHP_SELF'];
if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {$news=$s+$limit;echo "<a href=\"$url?s=$news&trefwoord=$waarde\">Volgende afbeeldingen&gt;&gt;</a>"; }
?>
</font>
<p align="center">&nbsp;</td>
<table border="1" cellspacing="5" cellpadding="5" align="left" width="100%" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<th align="left" valign="top"><p align="left"><b><Font size="2",font face="Arial">Nummer</font></b></th></p>
</tr>
<?
$count = 1 + $s ;
while ($row= mysql_fetch_array($result)) {
$NUMMER=$row["NUMMER"];
?>
<tr>
<td align="left" valign="top"><b><Font size="2",font face="Arial"><?echo $NUMMER;?></font></b>&nbsp;</td>
</a>&nbsp;</td>
</tr></div>
</b>
</div>
<?
$count++ ;
}
echo "</table>";
$currPage = (($s/$limit) + 1);
?>

<?
$limit=25; 
$user="****";
$password="****";
$database="****";
$waarde=$_GET["trefwoord"];
mysql_connect(mysqlhost,$user,$password);
@mysql_select_db(****) or die( "Unable to select database");
$query = "select * from doodsprentje where TITEL LIKE \"%$waarde%\" "; 
$numresults=mysql_query($query);
$numrows=mysql_num_rows($numresults);
 
if (empty($s)) {$s=0;}
 
$query .= " limit $s,$limit";
$result = mysql_query($query) or die("Couldn't execute query");
$url=$_SERVER['PHP_SELF'];
if ($s>=1) {$prevs=($s-$limit);print "<a href=\"$url?s=$prevs&trefwoord=$waarde\">Vorige afbeeldingen</a>";}
 
$pages=intval($numrows/$limit);
 
if ($numrows%$limit) {$pages++;}
$url=$_SERVER['PHP_SELF'];
if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {$news=$s+$limit;echo "<a href=\"$url?s=$news&trefwoord=$waarde\">Volgende afbeeldingen&gt;&gt;</a>"; }
?>
</font>
<p align="center">&nbsp;</td>
<table border="1" cellspacing="5" cellpadding="5" align="left" width="100%" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<th align="left" valign="top"><p align="left"><b><Font size="2",font face="Arial">Nummer</font></b></th></p>
</tr>
<?
$count = 1 + $s ;
while ($row= mysql_fetch_array($result)) {
$NUMMER=$row["NUMMER"];
?>
<tr>
<td align="left" valign="top"><b><Font size="2",font face="Arial"><?echo $NUMMER;?></font></b>&nbsp;</td>
</a>&nbsp;</td>
</tr></div>
</b>
</div>
<?
$count++ ;
}
echo "</table>";
$currPage = (($s/$limit) + 1);
?>