Next/Prev button

Anon

Hallo!
Is there some one how can help me with this Next / Prev script.
When I click on the next link it dosen't return any rows.

Here is the code i use.

Thanks//Micke

<head>
<title>Sök resultat</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF" text="#000000">
<center>
<table border="0" width="200" cellspacing="0" cellpadding="0">
<tr>
<td align="center"><img src="bilder/logga.png" width="191" height="42"></td>
</tr>
<tr>
<td align="left">
<?
if ($searchstring)
{
print $searchstring;

include("common.php");
$link = dbConnect();
$limit=20;
$numresults=mysql_query("SELECT kundid, icon, namn, typ FROM $table WHERE namn LIKE '%$searchstring%' order by namn");
$numrows=mysql_num_rows($numresults);

if (empty($offset)){
$offset=0;

$result=mysql_query("SELECT kundid, icon, namn, typ FROM $table WHERE namn LIKE '%$searchstring%' order by namn limit $offset,$limit");
?>
<br>
<table border="0" width="200" cellpadding="0" cellspacing="0">
<?

while ($raden = mysql_fetch_array($result)){  	
	echo "<tr bgcolor=#cccccc>
	<td width=20><img src='$raden[icon]' width=20 height=20></td>
	<td><font face=verdana size=2>&nbsp;<b><a href=info.php?kundid=$raden[kundid]>$raden[namn]</a></b></font></td>
	<td><font face=verdana size=1>$raden[typ]</font></td>
	</tr>
	<tr height=2 bgcolor=#ffffff>
	<td colspan=3>&nbsp;</td>
	</tr>";
	 }

	  if ($offset==1){
	$prevoffset=$offset-20;
	print "<a href=\"$PHP_SELF?offset=$prevoffset?searchstring=$searchstring\"><font face=verdana size=1>PREV</font></a> &nbsp; \n";
	}

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

	if ($numrows%$limit){
	$pages++;
	}

	 for ($i=1;$i<=$pages;$i++){
	 $newoffset=$limit*($i-1);
	 print "<a href=\"$PHP_SELF?offset=$newoffset?searchstring=$searchstring\"><font face=verdana size=1>$i</font></a> &nbsp; \n";
	 }

	 if (!(($offset/$limit)==$pages) && $pages!=1){
	 $newoffset=$offset+$limit;
	 print "<a href=\"$PHP_SELF?offset=$newoffset?searchstring=$searchstring\"><font face=verdana size=1>NEXT</font></a><br>\n";
	 }
	 }
?>
    </table>
    <?
	}
	?>

piersk

Im not sure if you just typed it in wrong, but I think your mistake might be here:

You had just a
<?

When you should have <?php instead.

Thats the only thing I could see wrong with it.

tomhath

It looks like the problem is here:

if (empty($offset)){
$offset=0;

You only run the rest of the script when this is true. I think you intended to close this statement with an "}" on the next line.

jayant

Originally posted by piersk
You had just a
<?

When you should have <?php instead.

Thats perfect piersk, there is an option in php.ini for this, whether to allow shorter <? also apart from <?php, it also has an option for supporting asp style tags : <% %>