Hi All,
New here and i need some help with this...
I am designing a website which will list names depening on which letter you select from the list...
for this example, ill use letter S.
below is the code i have
function myS(){
if (isset($_GET["page"])) { $page = $_GET["page"]; } else { $page=1; };
$start_from = ($page-1) * 1;
$result = @mysql_query("SELECT idinfo, fldName FROM info WHERE fldName LIKE 's%' ORDER BY fldName LIMIT $start_from, 1");
while ($row = mysql_fetch_assoc($result)) {
echo ("<p>" . $row["fldName"] . "</p>");
}
$rs_result = @mysql_query("SELECT Count(idinfo) from info WHERE fldName LIKE 's%'");
$row1 = mysql_fetch_row($rs_result);
$total_records = $row1[0];
$total_pages = ceil($total_records / 1);
for ($i=1; $i<=$total_pages; $i++) {
echo "<a href='index.html?run=s&page=".$i."'>".$i."</a> ";
}
}
i have it so it shows one record per page, and when i click the next page i want it to show the next record for that page, but its not working and i think its something to do with this part of the coding:
echo "<a href='index.html?run=s&page=".$i."'>".$i."</a> ";
for testing purposes i am only showing 1 record per page, once i have it fully working, i will list around 5-10, but i know how to get that changed, just cant get this page change to work.
Any help with this will be great.
-DreamOn
P.S - sorry if its in the wrong section, could a mod move it if so.