< Last & Next> Page coding.

[mabans]

I'm trying to break up the information that comes in from a database into separate pages. but it doesn't seem to be working. Any help would be great. thanks in advance.

<?php

//The Required Files to access the data base
require("../../../includes/configs/config.cfg");
require("../../../includes/configs/select_db.cfg");
//The Required Files to access the data base

if(!isset($_GET['page'])) $page = 0;

$query = "SELECT * FROM 'poster' LIMIT " . $page . ", 10";

$result = mysql_query($query);



$query2 = "SELECT count(*) as count FROM 'poster'"; 
$result2 = mysql_query($query2);
$row = mysql_fetch_array($result2);
$numrows = $row['count'];


if($_GET['page'] > 0) 
echo "<a href=\"" . $PHP_SELF . "?page=" . ($page - 10) .  "\">Previous</a><BR>\n";

if($numrows > ($_GET['page'] + 10)) 
echo "<a href=\"" . $PHP_SELF . "?start=" . ($page + 10) . 
"\">Next</a><BR>\n";


?> 

[leatherback]

Hi,

In the previouslink you use page, in the nextlink you use start..

J

[mabans]

correct but I get this error, which is what I was getting before.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in/home/www/dinaart/test/includes/main_stage_items/results/poster_pages.php on line 18

http://69.13.156.225/test/includes/main_stage_items/results/poster_pages.php

I'm sure there is somethign wrong with the way I'm even approaching it.

[leatherback]

Hi,

i don't see to much fundamentally wrong with your approach. (But then again, 'I ain't no pro').

Looks like your queryis wrong.

Echo the query srting. And you place quotes around the tablename. You do not need them (Might even be the problem??)

J.
PS: next time paste this error with it directly: Saves a lot of people going through your code. this points directly to the area of problem.)