please help...problem with prev next nav

[sundogro]

i have read all the articles about it. i modified a snippet of code like this:

<?php

if (!$newsstart) {
$limit = "7";
$nstart = "0";
$nprev = "0";
$nnext = "$limit";
} else {
$newprev = ($newsstart - $limit);
$newnext = ($newsstart + $limit);
}

$con = mysql_connect("localhost", "sundog", "specialk") or
die(mysql_error());
$db = mysql_select_db("excel1",$con) or die(mysql_error());
$news = mysql_fetch_row(mysql_query("SELECT * FROM test1 where 1 limit $newsstart,$limit"));

$con = mysql_connect("localhost", "sundog", "specialk") or
die(mysql_error());
$db = mysql_select_db("excel1",$con) or die(mysql_error());
$sql = "SELECT * FROM test1";
$result = mysql_query($sql,$con);
while ($art = mysql_fetch_array($result)) {

echo $art[0];echo $art[1];
echo "<br>";

}

echo ("<a href=\"?newsstart=$nprev\">Back</a> <a
href=\"?newsstart=$nnext\">Next</a>");

?>

i get a "Warning: Supplied argument is not a valid MySQL result resource in c:\phpweb/muci.php on line 16"

line 16:

$news = mysql_fetch_row(mysql_query("SELECT * FROM test1 where 1 limit $newsstart,$limit"));

and it does not work either, it lists all the records. i have a large database with about 8000 records ? can anyone help me ?
i need to deliver a functional admin interface( nothing fancy) but i can't list 8000 records on one page? if someone knows a functional script for prev/next, please tell m, because i have tried about 6 of them

[Anon]

Try this... i use it on my Guestbook script (UG😎 * i totally modified it for my script though but this is the original.

You need to put the My SQL queries after the
"// Get results" line ok ?

"IF" u still can't embed Prev/Next send your "WHOLE" script to [e-mail] and i will add it for you and send it back.

I hope this helps you...

<code>

<?php

$limit=20; // rows to return
$numresults=mysql_query("select * from TABLE where YOUR CONDITIONAL HERE order by WHATEVER");
$numrows=mysql_num_rows($numresults);

// next determine if offset has been passed to script, if not use 0
if (empty($offset)) {
$offset=1;
}

// get results
$result=mysql_query("select id,name,phone ".
"from TABLE where YOUR CONDITIONAL HERE ".
"order by WHATEVER limit $offset,$limit");

// now you can display the results returned
while ($data=mysql_fetch_array($result)) {
// include code to display results as you see fit
}

// next we need to do the links to other results

if ($offset==1) { // bypass PREV link if offset is 0
$prevoffset=$offset-20;
print "<a href=\"$PHP_SELF?offset=$prevoffset\">PREV</a> &nbsp; \n";
}

// calculate number of pages needing links
$pages=intval($numrows/$limit);

// $pages now contains int of pages needed unless there is a remainder from division
if ($numrows%$limit) {
// has remainder so add one page
$pages++;
}

for ($i=1;$i<=$pages;$i++) { // loop thru
$newoffset=$limit*($i-1);
print "<a href=\"$PHP_SELF?offset=$newoffset\">$i</a> &nbsp; \n";
}

// check to see if last page
if (!(($offset/$limit)==$pages) && $pages!=1) {
// not last page so give NEXT link
$newoffset=$offset+$limit;
print "<a href=\"$PHP_SELF?offset=$newoffset\">NEXT</a><p>\n";
}

?>

</code>