multiple pages from MySQL Database

[Anon]

Hi, I am Javed and am beginner in PHP and SQL. I have created a database in MySQL named SOFTWARE,
and I have these tables in it :
1. MAINLIB ( For keeping the names of IMAGE LIBRARY names )

---

Fields are a. newlibrary varchar(60)
b. idmain int(10) ( Primary key - Autoincrement )

							2. UNDRLIB ( For keeping the names of IMAGE CATEGORY under library names )
							----------
				Fields are  a. newcategory varchar(60)
							b. idmain int(10) ( to relate it to MAINLIB )
							c. idcat int(10) ( Primary key - Autoincrement )

							3. DSGNLIB ( For keeping the names of IMAGES under selected categories and libraries )
							----------
				Fields are  a. idmain int(10) ( to relate it to MAINLIB )
							b. idcat int(10) ( to relate it to UNDRCAT )
							c. smallthumblink varchar(60) ( to keep small thumbnail link names of images )
							d. bigimageanddesc varchar(60) ( to keep big images link names and description )
							e. iddsgn int(10) ( Primary ket - Autoincrement )

Now I want to give the preferances to the user to select a library name and category and accrodingly I want to
display small thumbnail images to the user. The problem is image library is bit big and I want to display
these images on subsequent pages. That is in first page suppose I want to display 10 images. Then when the
user press NEXT button it should display the next 10 images and so on. If the user press PREVIOUS button
then it should display PREVIOUS 10 images to the user. When the user right clicks on any of the images it
should provide a link to the BIG IMAGE FILE.

I dont know how to handle it, so can anybody guide me?

Thanking You. I remain

Javed.

[Anon]

Hi, here's a function I wrote for a site, which browses throught categories and prints all business in those categories. I've modified it a bit to try not to confuse you, but work your way through and it should help. Its PHP and HTML mixed up.

1. The page requires a $page to be passed, so initially this will be 1.

2. Basically, you need to use the MySQL LIMIT function.

3. There are 2 queries. First count how many in your query, then select your records.

4. HTML to print the records.

5. Then a footer with next, previous and page links. e.g. [previous][1][2][3][next]

6. The mysql queries are functions in a library, so you may have to change those.

Good luck

Function PrintImageList($page)
{

$totperpage = 10;

$cid = db_query("
SELECT count(*)
FROM table");

$tot = db_fetch_row($cid);
$totalincat = $tot[0];
$startrange = (($page-1) * $totperpage);

$qid = db_query("
SELECT fields
FROM table
ORDER BY field_name
LIMIT $startrange, $totperpage ");

$x = ($page-1)*$totperpage;

print "<TR><TD>";
print "<TABLE>";

while ($r = db_fetch_object($qid)) {

    $x++;

    print"<TR height='25' valign='bottom'><TD width='20'>";
    pv($x);
    print".</TD><TD align='left'>";

    print"<A href='yourpage.php'>";

    Image Code Here

    print "</A>";
    print"</TD></TR>";

}

if ($totalincat>0) {

  print"<TR height='25' valign='bottom'><TD width='20'>&nbsp;";
  print"</TD><TD align='left' class=pagenav><B><FONT color='#000000'>Result Pages:</FONT></B>";
  print "&nbsp;";
  print "&nbsp;";

  if ($page > 1) {
     print "[";
     print"<A class=pagenav href='yourpage.php?page=";
     $prev = $page-1;
     print $prev;
     print "'>";
     print"&lt;&lt;prev";
     print"</A>";
     print"]";
  }

  $totalpages = ceil($totalincat / $totperpage);

  for ($loop = 1; ;$loop++) {

      if ($loop > $totalpages) {
         break;}

      if ($loop == $page) {
         print "&nbsp;";
         print $loop;
         print "&nbsp;";}
      else {
         print "&nbsp;";
         print"<A class=pagenav href='yourpage.php?page=$loop'>";
         print $loop;
         print"</A>";
         print "&nbsp;";
      }

  }

  if ($page <> $totalpages) {
     print "[";
     print"<A class=pagenav href='yourpage.php?page=";
     $next = $page+1;
     print $next;
     print "'>";
     print">>next";
     print"</A>";
     print"]";
  }


  print "</TD></TR>";

}

print "</TABLE>";
print "</TD></TR>";
}