hey i have a for loop and it is driving me crazy cuz its not working properly. below is some of my code
$currentPage = $_SERVER["PHP_SELF"];
$maxRows_pdf_downloads = 3;
$pageNum_pdf_downloads = 0;
if (isset($_GET['pageNum_pdf_downloads'])) {
$pageNum_pdf_downloads = $_GET['pageNum_pdf_downloads'];
}
$startRow_pdf_downloads = $pageNum_pdf_downloads * $maxRows_pdf_downloads;
mysql_select_db($database_safety_connection, $safety_connection);
$query_pdf_downloads = "SELECT * FROM pdf_downloads";
$query_limit_pdf_downloads = sprintf("%s LIMIT %d, %d", $query_pdf_downloads, $startRow_pdf_downloads, $maxRows_pdf_downloads);
$pdf_downloads = mysql_query($query_limit_pdf_downloads, $safety_connection) or die(mysql_error());
$row_pdf_downloads = mysql_fetch_assoc($pdf_downloads);
if (isset($_GET['totalRows_pdf_downloads'])) {
$totalRows_pdf_downloads = $_GET['totalRows_pdf_downloads'];
} else {
$all_pdf_downloads = mysql_query($query_pdf_downloads);
$totalRows_pdf_downloads = mysql_num_rows($all_pdf_downloads);
}
$totalPages_pdf_downloads = ceil($totalRows_pdf_downloads/$maxRows_pdf_downloads)-1;
$queryString_pdf_downloads = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_pdf_downloads") == false &&
stristr($param, "totalRows_pdf_downloads") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_pdf_downloads = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_pdf_downloads = sprintf("&totalRows_pdf_downloads=%d%s", $totalRows_pdf_downloads, $queryString_pdf_downloads);
this bit gets how many pages i need and displays the numbers
for ($i=0; $i <= $totalPages_pdf_downloads; $i++) {
$TFM_PagesEndCount = $i + 1;
if($i != $pageNum_pdf_downloads) {
echo '<span class="jFlowControlPDF">'. $TFM_PagesEndCount .'</span>';
}else{
echo '<span class="jFlowControlPDF">'. $TFM_PagesEndCount .'</span>';
}
}
an this is where i am going wrong, its only adding 4 items out of a total 7, i know its my for loop which is wrong, anybody have an idea on how to get around this?
This is a working example of what it is at the moment
http://www.addictivepixel.com/clients/safety-care/catalogue.php
Any help would be appreciated.
Dee
