Pagination question

[bri4n]

Hi everyone!

 

I have a page that has 10 rows appear on it, but I also want 4 columns (not just 1). I was wondering if someone could tell me how I can go about and get 4 columns and 10 rows to appear on each page. Here is the code below:

 

<?php

include("include/assorted.inc.php");

 

/*Connect to database*/

$connection=mysql_connect($host,$user,$password)

or die("Could not connect to the server");

$db=mysql_select_db($database,$connection)

or die("Could not connect to the database");

//This checks to see if there is a page number. If not, it will set it to page 1

if (!(isset($pagenum)))

{

$pagenum = 1;

}

 

//Here we count the number of results

//Edit $data to be your query

$data = mysql_query("SELECT firstname,lastname FROM userinfo") or die(mysql_error());

$rows = mysql_num_rows($data);

 

//This is the number of results displayed per page

$page_rows = 10;

 

//This tells us the page number of our last page

$last = ceil($rows/$page_rows);

 

//this makes sure the page number isn't below one, or more than our maximum pages

if ($pagenum < 1)

{

$pagenum = 1;

}

elseif ($pagenum > $last)

{

$pagenum = $last;

}

 

//This sets the range to display in our query

$max = 'limit ' .($pagenum - 1) * $page_rows .',' .$page_rows;

 

//This is your query again, the same one... the only difference is we add $max into it

$data_p = mysql_query("SELECT firstname,lastnameFROM userinfo $max ") or die(mysql_error());

 

//This is where you display your query results

while($info = mysql_fetch_array( $data_p ))

{

Print $info['firstname']. ' '.$info['lastname'];

echo "<br>";

}

echo "<p>";

 

// This shows the user what page they are on, and the total number of pages

echo " --Page $pagenum of $last-- <p>";

 

// First we check if we are on page one. If we are then we don't need a link to the previous page or the first page so we do nothing. If we aren't then we generate links to the first page, and to the previous page.

if ($pagenum == 1)

{

}

else

{

echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=1'> <<-First</a> ";

echo " ";

$previous = $pagenum-1;

echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$previous'> <-Previous</a> ";

}

 

//just a spacer

echo " ---- ";

 

//This does the same as above, only checking if we are on the last page, and then generating the Next and Last links

if ($pagenum == $last)

{

}

else {

$next = $pagenum+1;

echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$next'>Next -></a> ";

echo " ";

echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$last'>Last ->></a> ";

}

?>

 

Thanks for any help and pointers!!

Brian 

[sasa]

change line $page_rows = 10; to $page_rows = 40;

and part

//This is where you display your query results
while($info = mysql_fetch_array( $data_p ))
{
Print $info['firstname']. ' '.$info['lastname'];
echo "
";
}
echo "<p>";

to

//This is where you display your query results
echo '<table>';
$i = 0;
while($info = mysql_fetch_array( $data_p ))
{
if($i % 4 == 0) echo '<tr>';
Print '<td>'. $info['firstname']. ' '. $info['lastname']. '</td>';
echo "
";
if(++$i % 4 == 0) echo '</tr>';
}
if($i % 4 != 0) echo '</tr>';
echo '</table>';
//echo "<p>";

[bri4n]

Hi sasa!

 

Thanks for your help, that got it! 

 

Many thanks,

Brian 

[maxudaskin]

Mark TOPIC SOLVED