You have to use recursive functions for this. You can write one..
function linkchecker($id)
{
$query="SELECT COUNT(*) AS mycount FROM tablename WHERE id=".$id."";
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$nextid = $id + 1;
if (($row["mycount"]) > 0 )
I think it would probably be better to read all the id's into an array,
and then use the array stepping functions to move forward or back. This
way, you won't have to worry about "empty" rows, or id's that are not
numerically following on each other.
On Thu, 2002-09-05 at 23:20, tux wrote:
>
> h
hey all,
if im displaying pages with data from a database eg
www.domain.com/file.php?id=40
on that page i would like to have a previous and next link that would
take it to id 41 and 39 respectively, the only problem being what if 39
or 41 was empty? then i would want the link to be id=42 or i
3 matches
Mail list logo
