Html table displaying mysql data

[Comtemplative]

Hi I'm pretty new to php and I have an sql statement working perfectly to output the date, time, location and home and away teams for each game... I need to fit this data into a table, obviously only showing the amount of entries that occur. I've seen many occurences of tables that after ten entries you move through the table... ie the uploaded image

Any help would be appreciated.

[coldwerturkey]

somthing similar to this -with your edits of course- could work.. take from it what you can.

<?php
//# of posts to display per page
$display = 5; 

//adds your page (if any) between like so '?{$uri}page=#'
$uri = "";

//Get current page
$page = (!empty($_GET['page'])) ? $_GET['page'] : '0'; 

//Find post to start on, depending on page
$start = ($page == 0) ? $start = 0 : $start = (($page-1)*$display);

//Print content & count number printed
$query = "SELECT * FROM table LIMIT {$start},{$display}";
$result = mysql_query($query) or die(mysql_error());
$displayed = 0;
echo "<table cellpadding=0 cellspacing=3 border=0>"
while($row = mysql_fetch_array($result)) {
    echo "<tr><td>{$row['date']}</td>$row['location']<td></td></tr>"; //or whatever
    $displayed++;
} 
echo "</table>";

//Get number of total posts
$count = mysql_query("SELECT id FROM table");
$rows = mysql_num_rows($count);

//Get number of total pages
$pages = ceil($rows/$display);

//Make next/prev links
$next = $page+1;
$prev = $page-1;

//Unlink if next/prev doesn't exsist
$prevpage = ($prev == 0 || $prev == -1) ? 
"&lt;&lt; Prev" : "<a href='?{$uri}page={$prev}'>&lt;&lt; Prev</a>";
$nextpage = ($next < $pages+1) ? 
"<a href='?{$uri}page={$next}'>Next &gt;&gt;</a>" : "Next &gt;&gt;";

//Get showing from-to numbers
$from = $start;
$from = ($from == 0) ? 1 : $from+1;
$to = $start+$displayed;

//Print stats 
$page_num = ($page == 0) ? '1': $page;
echo "Showing entries {$from}-{$to}/{$rows}, 
on page {$page_num}/{$pages} <br /><br />";

//Print individual page number links
echo "{$prevpage} &nbsp; [";
$i = 1;
while($i != $pages+1) {
    //Print pages & add coma to all but last page #
    echo "<a href='?{$uri}page={$i}'>{$i}</a>";
    if($i != $pages) {echo ", ";}
    $i = $i+1;
}
echo "] &nbsp; {$nextpage}";
?>

[Weedpacket]

Other solutions can be found by searching the forums for the word "pagination".

[Comtemplative]

I'm getting a bug in it when I apply the $limit to it. The fixtures.php page gives me this error

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-2,2' at line 3"

But If I get through it on to page one or two then it gives me the results perfectly

../fixtures.php?page=1

Then it gives me the results out perfectly.

EDIT: Sorry guys I figured it out for myself, had to change a 0 to a 1!

$page = (!empty($GET['page'])) ? $GET['page'] : '1';

I'm an idiot 🙂

Thanks for everything