problem with link
Posted: Thu Mar 10, 2005 12:56 pm
Hi I am having a problem with this code
I am unsure how to get the next previous links working properly
Any ideas are appreciated Cheers
Maboroshi
feyd | Please use
Code: Select all
<?php
$link = mysql_connect("local", "user", "pass");
if (!$link) {
print "Error connecting to database";
exit;
}
if (!@mysql_select_db("engrooved")) {
print "Could not select Database";
exit;
}
if(!$rowstart) $rowstart=0;
$numrows=mysql_num_rows($result2);
$result = mysql_query("select * from knowledge order by title asc limit $rowstart,20");
$result2 = mysql_query("select * from knowledge");
if ($result && @mysql_num_rows($result) > 0 ) {
while ($row = mysql_fetch_array($result))
{
$myid = $row['id'];
?>
<A HREF="moredata.php?moredata=<? echo $myid ?>"><? echo $row['title']; ?> </A><BR>
<?
}
}
else {
print "Sorry Nothing Yet";
}
?>
<br>
<br>
<?php
if ($rowstart>$numrows)
{ ?>
<A HREF="<? echo $PHP_SELF ?>?rowstart=<? echo $rowstart-20;?>">
< Previous Page</A>
|
<?
}
$numrows=mysql_num_rows($result2);
if($rowstart+20<$numrows)
{?>
<A HREF="<? echo $PHP_SELF ?>?rowstart=<?echo $rowstart+20;?>">
Next Page ></A>
<?
}
mysql_close($link);
?>Any ideas are appreciated Cheers
Maboroshi
feyd | Please use
Code: Select all
andCode: Select all
tags where approriate when posting code. Read: :arrow: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]