[RESOLVED] Weird.....can you have a look

[dst101]

This code below works fine on my local machine, linux and fine with our development server but when uploaded to a clients server the pagination doesnt work properly. It won't receive the next set of results.

<td valign='top' class='bodytext'><br /><br /><span class='bigtext'>Image Gallery</span><br /><br />
<table width='90%' cellpadding='0' cellspacing='2' border='0'><tr>
<?
openConn();#OPEN DB CONNECTION
#QUERY RECORDS FOR PAGE NUMBERING SYSTEM            

$numresults=@mysql_query("SELECT * FROM br_photography ORDER BY id ASC"); #QUERY RECORDS
$numrows=@mysql_num_rows($numresults); 
if(!$numrows){
NOPICS();
}else {
}
if (empty($offset)){ 
  $offset=1; 
} 
#VARIABLES FOR SETTING HOW MANY PICTURES YOU WISH TO DISPLAY BEFORE HAVING TO 'TURN' THE PAGE
$limit = "4"; 
$Prev = "Previous"; 
$Next = "Next";    

#SET 3 TO 4 OF YOU WANT 4 COLUMNS. SET IT TO 5 IF YOU WANT 5, ETC THIS HAS TO SIT HERE BEFORE WE ACCESS THE DATA
$numcols = 2;# HOW MANY COLUMNS TO DISPLAY
$numcolsprinted = 0; #NO OF COLUMNS SO FAR
#ACTUALLY PULL THE DATA NOW            

$sql = "SELECT * FROM br_photography WHERE public = 1 ORDER BY id ASC limit $offset,$limit "; 
$result = @mysql_query($sql) or die("Could not execute query."); 
while ($row = @mysql_fetch_array($result)) 
{ 
#SHORTEN CODE BY USING VARIABLES
  $title= $row['title'];
  $description= $row['description'];
  $thumbnail = $row['thumbnail'];
  $picture = $row['picture'];
  $height = "125";
  $width = "125";  

  $images = "images/photos/";
  $id = $row['id'];
  $imageBig ="javascript:popUp('imageBig.php?id=$id')";
#DISPLAY INFORMATION FROM DBASE IN THE FORMAT DECIDED ABOVE $numcols, $numcolsprinted etc  

  if ($numcolsprinted == $numcols){
  print "</tr>\n<tr>\n";
  $numcolsprinted = 0;
  }
  # OUTPUT ROW FROM DATABASE
  PRINT "<td class='bodytext1' valign='top'><a href=$imageBig><img src='$images$picture' width='$width' height='$height' /></a><br /> <strong>$title</strong><br /></td>\n";
  # BUMP UP ROW COUNTER
  $numcolsprinted++;
} # END WHILE LOOP
$colstobalance = $numcols - $numcolsprinted;
for ($i=1; $i<=$colstobalance; $i++) {
}
?>
<table width='100%' cellpadding='0' cellspacing='0' border='0'><tr><td align='center'>
<?
 /** PAGE NUMBERING SYSTEM IN AN INCLUDE FILE pageNumbering.inc.php **/
 #include('scripts/pageNumbering.inc.php');
$pages=intval($numrows/$limit); 
$pages1=intval($numrows/$limit); 
if ($pages1 > 10) { 
  $pages=10; 
} else { 
  $pages=$pages1; 
} 
 if ($numrows%$limit) { 
  $pages++; 
} 
if ($offset>1) { 
  $prevoffset=$offset-$limit; 
   print "<a href=\"$PHP_SELF?offset=$prevoffset\">$Prev</a> \n"; 
} 
for ($i=1;$i<=$pages;$i++)  { 
   $newoffset=$limit*($i-1); 
   print "<a href=\"$PHP_SELF?offset=$newoffset\">$i</a> \n"; 
} 
 if ($numrows>($offset+$limit))  { 
   $nextoffset=$offset+$limit; 
   print "<a href=\"$PHP_SELF?offset=$nextoffset\">$Next</a>\n"; 
 }
?>
</td></tr></table>
<? mysql_close($dbConnect);#CLOSE THE CONNECTION ?>
<img src='images/logos.gif' width='340' height='100' alt='' /></td>
<td valign='top' bgcolor='#0a2342'><img src='images/r_banner/rotator.php' width='180' height='320' alt='' /></td></tr></table>
</body></html>

Can you see anything that would hinder this?

Thanks in advance... it's driving me mad!

[vattila]

maybe because the difference of the sql select queries, you check for all recs to determine numrows etc. then select records where public=1 so the tne number of rows can be different. If on your dev. environment all records has public=1 then it makes no sense.

[dst101]

Sorry don't know what you are talking about.
Could you explain?!

[vattila]

U are checking for the number of records for display with the query:

$numresults=@mysql_query("SELECT * FROM br_photography ORDER BY id ASC"); #QUERY RECORDS 
$numrows=@mysql_num_rows($numresults); 

but displaying

$sql = "SELECT * FROM br_photography WHERE public = 1 ORDER BY id ASC limit $offset,$limit ";

in your page calculations the total no of records to display assumed to be the in $numrows variable but in the real situation it could be less if not all record has the value of the public field is set to 1. So try put the where clause into the first query string also like this:

$numresults=@mysql_query("SELECT * FROM br_photography WHERE public = 1 ORDER BY id ASC"); #QUERY RECORDS 
$numrows=@mysql_num_rows($numresults); 

[dst101]

Hi,

Thanks for explaining that..
I actually tried that, but nothing happened, same result.
I tried three different coded versions from the internet, all work locally, but when uploaded and tested on the clients server, nothing gets resolved.
I am beginning to think that there is an issue with the clients server setup, but can't think of what it could be.....

[vattila]

Means no records in the result set, or what happens?

[dst101]

Resolved:

$offset = $_GET['offset'];

This needed to be at the top of the page....