Trying to learn PHP and messing around with databases. I have created a very simple (or so I thought) page in Adobe GoLive6. I am currently displaying records 5 at a time in my table. I have a next and previous button to of course display the next series of records. I currently have 16 records in my sample database.
Here's my problem. If I am on the second grouping of records (6-10) and I click on one of the names, the page gets refreshed and the table pointer goes back to 1-5. I want it to stay right where it is displaying that grouping of records. How do I do this?
Here's my code:
<?php require_once("config/include/utils.runtime6.php") ?>
<?php require_once("config/include/mysql.runtime6.php") ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html;charset=iso-8859-1">
<meta name="generator" content="Adobe GoLive 6">
<title>Welcome to Adobe GoLive 6</title>
<?php // GoLive Content Source
$MemberList = WrapMySQLDatabaseResults("TheSportsLair", "select * from rccinfo order by screenname", "block=5","MemberList");
?>
</head>
<body bgcolor="#ffffff">
<table width="326" border="0" cellspacing="0" cellpadding="0" cool gridx="6" gridy="6" height="361" showgridx showgridy usegridx usegridy>
<tr height="6">
<td width="325" height="6" colspan="8"></td>
<td width="1" height="6"><spacer type="block" width="1" height="6"></td>
</tr>
<tr height="114">
<td width="6" height="114"></td>
<td width="319" height="114" colspan="7" valign="top" align="left" xpos="6">
<table width="125" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<div align="center">
<b><font size="3">Member List</font></b></div>
</td>
</tr>
<?php $MemberList->MoveFirst(); ?>
<?php $MemberList->Move($MemberList->FirstRecordOnPage() - 1); ?>
<?php while (!$MemberList->EOF() && !$MemberList->EOB()) { ?>
<tr>
<td><font size="2"><a href='MemberList.php?mname=<?php echo $MemberList->Value("screenname")?>&start=6&end=10'><?php echo $MemberList->Value("screenname")?></a></font></td>
</tr>
<?php $MemberList->MoveNext(); ?>
<?php } ?>
</table>
</td>
<td width="1" height="114"><spacer type="block" width="1" height="114"></td>
</tr>
<tr height="240">
<td width="24" height="240" colspan="2"></td>
<td cslocked content csheight="18" width="18" height="240" valign="top" xpos="24"><a <?php echo LinkToPreviousRecord($MemberList)?>><font size="-1"><<</font></a></td>
<td width="6" height="240"></td>
<td content csheight="20" width="42" height="240" valign="top" xpos="48"><font size="-1">Home</font></td>
<td width="6" height="240"></td>
<td cslocked content csheight="18" width="18" height="240" valign="top" xpos="96"><a <?php echo LinkToNextRecord($MemberList)?>><font size="-1">>></font></a></td>
<td width="211" height="240"></td>
<td width="1" height="240"><spacer type="block" width="1" height="240"></td>
</tr>
<tr height="1" cntrlrow>
<td width="6" height="1"><spacer type="block" width="6" height="1"></td>
<td width="18" height="1"><spacer type="block" width="18" height="1"></td>
<td width="18" height="1"><spacer type="block" width="18" height="1"></td>
<td width="6" height="1"><spacer type="block" width="6" height="1"></td>
<td width="42" height="1"><spacer type="block" width="42" height="1"></td>
<td width="6" height="1"><spacer type="block" width="6" height="1"></td>
<td width="18" height="1"><spacer type="block" width="18" height="1"></td>
<td width="211" height="1"><spacer type="block" width="211" height="1"></td>
<td width="1" height="1"></td>
</tr>
</table>
<p></p>
</body>
</html>
<?php if (false) { ?><!-- Mock Content
"MemberList/<TABLE>" html {$$lttr$$gt$$lttd$$gt$$lt/td$$gt$$lt/tr$$gt$$lttr$$gt$$lttd$$gt$$lt/td$$gt$$lt/tr$$gt$$lttr$$gt$$lttd$$gt$$lt/td$$gt$$lt/tr$$gt$$lttr$$gt$$lttd$$gt$$lt/td$$gt$$lt/tr$$gt}
"MemberList/screenname" html {screenname}
--><?php } ?>
Thank You
