Please help me with a search function

[Anon]

Hello, I need help with a search script.
Supose I search in a SQL table and I find more than 100 results. And I need to view just 20 results per page.
I need a mechanism that make some 1, 2, 3, 4, 5 links at the bottom of each page to healp the visitor navigate between the search results. If you can help me with some examples or tutorials I'll be glad.

[fitzbean]

$perpage = 20;

$c = sql_qeury("SELECT count(id) FROM table");
$r = sql_qeury("SELECT * FROM table LIMIT $offset, $perpage");

$count = mysql_fetch_array($c);

$pages = round($count[0] / $perpage);

for ($i = 1; $i <= $pages; $i++)
{
$newoffset = $perpage * $i;
echo "<A HREF=search.php?offset=$newoffset>1</A>,";
}

** UNTESTED, but the logic is there.

[fitzbean]

small correction:

for ($i = 0; $i < $pages; $i++)
{
$newoffset = $perpage * $i;
echo "<A HREF=search.php?offset=$newoffset>$i</A>,";
}