Hi,
I am hoping someone can help me. I have a small shopping cart script which lists all my products using PHP/MySQL. I have found that a page takes forever to load and now require a way of breaking up the list of products into pages of 10 products.
I would like to use the following format
Back | "page numbers" | Next
(where page numbers is generated depending on quantity of products).
I have tried using the "count" function but have been unsucessful due to my lack of knowledge with php.
Can someone please help me.
Regards
Craig
Heres the original code for the page:
<?
require("config.php");
DBinfo();
Brand();
Root();
mysql_connect("$DBHost","$DBUser","$DBPass");
if ($UID != "") {
$result=mysql( "$DBName", "SELECT * FROM Users WHERE User='$UID'");
$num=mysql_num_rows($result);
if ($num == "0") {
$dt=date( "YmdHis");
$UID= "$dt$REMOTE_ADDR";
$date=date( "z");
mysql( "$DBName", "INSERT INTO Users VALUES ('$UID','$date')");
Header( "Location: $PHP_SELF?CA=$CA&UID=$UID");
}
}
if ($UID == "") {
$dt=date( "YmdHis");
$UID= "$dt$REMOTE_ADDR";
$date=date( "z");
mysql( "$DBName", "INSERT INTO Users VALUES ('$UID','$date')");
Header( "Location: $PHP_SELF?CA=$CA&UID=$UID");
}
commonHeader("$Company","Select an item");
$result=mysql("$DBName","SELECT * FROM Items WHERE Category='$CA' ORDER BY ItemName");
fontFace("Arial","<B>Select an item:<br><br>");
echo "<table align='center'>";
while ($row = mysql_fetch_row($result)) {
$IS=$row[0];
$IN=$row[1];
$ID=$row[2];
$IC=$row[3];
$Ca=$row[4];
$SC=$row[5];
$II=$row[6];
fontFace("Arial","<table align='center' width='70%' border='0' cellspacing='0' cellpadding='0' bgcolor='#CCCCCC'><tr><td width='100%'><table width='100%'><tr><td align='left' width='20%'><a href='$Relative/description.php?II=$II&UID=$UID'><img border='0' src='$Relative/images/$II.jpg' width='75'></a></td><td valign='bottom' align='left' valign='center' width='60%'>    <b><font color='#FF0000'>$IN</font></b> <font color='#FF0000'> - $$IC </td><td width='20%' align='right'><a href='$Relative/description.php?II=$II&UID=$UID'><img border='0' src='$Relative/images/buy.gif'></a></font></td></tr></table></td></tr></table>
</P>");
if ($ID != "") {
fontFace("Arial",""); }
echo "";
}
echo "</table>";
?>
Can someone show me how to do this?
Thanks
Craig
