Multi query listing

jray214

Does anyone know how to do the following.

I have a query that was 100 records. In a display I want to display the first 25 and create a button that does the following

[Prev 25] [Next 25]

[1-25] [26-50] [51-75] [76-100]

Of course the table could have more then 100 records. Any help would be great.

Jim

cgraz

you can find what you want here

Cgraz

jray214

cgraz,

That is close but I want to do the following.

List to first 10 records.

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.

Something more like this.

Your code give be this results

380 matches found
Results 1 to 0.026315789473684 shown.
1 2 3 4 5 6 7 8 9 10 Next 0.026315789473684 »

Thanks again for the help.

Jim

cgraz

could you post your code? Did you use the first chunk of code in my first reply to that thread? Cause later on, I think someone wanted only a maximum of 10 pages, and I posted how I thought that would work, so if you used that code instead of the first code I posted, that may be why you're getting those results.

Cgraz

jray214

here you go buddy,

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
<title>Title here!</title>
</head>
<body>
<?php
$server = "localhost";
$username = "root";
$password = "admin";
$database = "copswest";
$table = "vendor";

// Connect To MySQL Server
@mysql_connect($server, $username, $password) or die("Couldn't Connect to Database");

// Select Database
@mysql_select_db($database) or die("Couldn't Select Database");

// set number of results to display per page
$pagelimit = "1";

// run query (change yourtable to the name of your table)
$strSQL = mysql_query("SELECT * FROM $table");

// count number of matches
$totalrows = mysql_num_rows($strSQL);

// calculate how many pages this would be
$pagenums = ceil ($totalrows/$pagelimit);

// checks to see how many pages this comes out to
if ($pagenums <= 10) { // came out to 10 pages or less

// don't do anything

} else { // more than 10 pages. Calculate how many results p/page to display so thta the page number comes out to 10

$pagenums = "10"; // set your pagenumber to 10
$pagelimit = $pagenums/$totalrows; // figure out how many results per page this would need to display

}

// if no value for page, page = 1
if ($page==''){
$page='1';
}

// create a start value
$start = ($page-1) * $pagelimit;

// blank matches found
echo "<b>" . $totalrows . " matches found</b><br>\n";

// Showing Results 1 to 1 (or if you're page limit were 5) 1 to 5, etc.
$starting_no = $start + 1;

if ($totalrows - $start < $pagelimit) {
$end_count = $totalrows;
} elseif ($totalrows - $start >= $pagelimit) {
$end_count = $start + $pagelimit;
}

echo "Results $starting_no to $end_count shown.<br>\n";

// create dynamic next, previous, and page links

/ lets say you're set to show 5 results per page and your script comes out with 7 results.
this will allow your script to say next2 if you're on the first page and previous5 if you're on the second page. /

if ($totalrows - $end_count > $pagelimit) {
$var2 = $pagelimit;
} elseif ($totalrows - $end_count <= $pagelimit) {
$var2 = $totalrows - $end_count;
}

$space = " ";

// previous link (make sure to change yourpage.php to the name of your page)
if ($page>1) {
echo "« <a href='yourpage.php?page=".($page-1)."' class=main>Previous" . $space . $pagelimit . "</a>" . $space . $space . "";
}

// dynamic page number links (make sure to change yourpage.php to the name of your page)

for ($i=1; $i<=$pagenums; $i++) {
    if ($i!=$page) {
        echo " <a href='yourpage.php?page=$i' class=main>$i</a>";
    }
    else {
        echo " <b class='red'>$i</b>";
    }
}

// next link (make sure to change yourpage.php to the name of your page)

if ($page<$pagenums) {
    echo "" . $space . $space . $space . $space . " <a href='youerpage.php?page=".($page+1)."' class=main>Next " . $var2 . "</a> »";
}

/* output your data wherever you'd like.

BUT

in order for this all to work, before outputting your data, you have to run the query over using MySQL's LIMIT. This will limit how many results are actually displayed on the page. */

$strSQL = mysql_query("SELECT * FROM $table LIMIT $start,$pagelimit");

// LIMIT 0,10 will start at 0 and display 10 results
// LIMIT 10,5 will start at 10 and display 5 results

/ now you can do whatever you'd like with this query. it will only output one page at a time. change the $pagelimit variable to whatever to output more than 1 result per page. /

?>
</body>
</html>

jray214

I forgot to say, yes I did you the first part of the code.

Hope this is helpful.

Jim

cgraz

that's probably why it doesn't work. Try using the first chunk. The second chunk of code that displays 10 pages max was just my untested attempt at it; that code has never been tested. The first code I posted has been tested and works great.

Cgraz

jray214

Thank you and I will do the following code changes

// Connect To MySQL Server

@mysql_connect($server, $username, $password) or die("Couldn't Connect to Database");

// Select Database

@mysql_select_db($database) or die("Couldn't Select Database");

// set number of results to display per page

$pagelimit = "1";

// run query (change yourtable to the name of your table)

$strSQL = mysql_query("SELECT * FROM $table");

// count number of matches

$totalrows = mysql_num_rows($strSQL);

// determine how many pages there will be by using ceil() and dividing total rows by pagelimit

$pagenums = ceil ($totalrows/$pagelimit);

// if no value for page, page = 1

if ($page==''){

    $page='1';

}

Then the rest goes here.

Jim