Hey Jason,
Thanks so much for replying so quickly! I'm running PowerStore 3. I can't find that exact code that you mentioned to change on my orders_Detail.php page. Or even on the site.
Here's the code that sort of contains what you're talking about. I just don't want to limit the maxRows that are displayed on that page.
<?php
$maxRows_WADAorderdetails = 5;
$pageNum_WADAorderdetails = 0;
if (isset($_GET['pageNum_WADAorderdetails'])) {
$pageNum_WADAorderdetails = $_GET['pageNum_WADAorderdetails'];
}
$startRow_WADAorderdetails = $pageNum_WADAorderdetails * $maxRows_WADAorderdetails;
$colname_WADAorderdetails = "-1";
if (isset($_GET['OrderID'])) {
$colname_WADAorderdetails = (get_magic_quotes_gpc()) ? $_GET['OrderID'] : addslashes($_GET['OrderID']);
}
mysql_select_db($database_PowerStoreConnection, $PowerStoreConnection);
$query_WADAorderdetails = sprintf("SELECT DetailID, DetailProductID, DetailName, DetailPrice, DetailSKU, DetailQuantity, DetailDiscount FROM ps3_orderdetails WHERE DetailOrderID = %s", GetSQLValueString($colname_WADAorderdetails, "int"));
$query_limit_WADAorderdetails = sprintf("%s LIMIT %d, %d", $query_WADAorderdetails, $startRow_WADAorderdetails, $maxRows_WADAorderdetails);
$WADAorderdetails = mysql_query($query_limit_WADAorderdetails, $PowerStoreConnection) or die(mysql_error());
$row_WADAorderdetails = mysql_fetch_assoc($WADAorderdetails);
if (isset($_GET['totalRows_WADAorderdetails'])) {
$totalRows_WADAorderdetails = $_GET['totalRows_WADAorderdetails'];
} else {
$all_WADAorderdetails = mysql_query($query_WADAorderdetails);
$totalRows_WADAorderdetails = mysql_num_rows($all_WADAorderdetails);
}
$totalPages_WADAorderdetails = ceil($totalRows_WADAorderdetails/$maxRows_WADAorderdetails)-1;
?>
I really appreciate the help!
Carlene :)