Hello,
I'm very new to the php/mysql so bare with me.
I've searched around and just can't find what I'm looking for.
I would like to show individual result from a search and use the next and prev pages.
I've tried snippets here and there, but I always get the first database entry when jumping to next/prev page..
Can anyone help..
heres part of my code.. I've cut alot out that just does the printing.
thanks
Mike
if(!isset($start)) $start = 0;
$db = mysql_connect("localhost", "root", "");
mysql_select_db("bike",$db);
$result1 = mysql_query("SELECT * FROM bikesdb",$db);
$result = mysql_query("SELECT count(*) as count FROM bikesdb",$db);
$row = mysql_fetch_array($result);
$numrows = $row['count'];
include_once 'include/arrays.php';
echo "<center><TABLE>";
$myrow = mysql_fetch_array($result1);
echo"<TR><TD><h3>Name:";
echo "<td>";
echo $myrow["first_name"];
echo " ";
echo $myrow["last_name"];
if($start > 0)
echo "<a href=\"" . $PHP_SELF . "?start=" . ($start - 1) .
"\">Previous</a><BR>\n";
if($numrows > ($start + 1))
echo "<a href=\"" . $PHP_SELF . "?start=" . ($start + 1) .
"\">Next</a><BR>\n";
