code for next & prev buttons

[gat]

I have 'pic_path' in mysql.
(which is the path to specific images)

I want a page with next and previous buttons to flic through the images.

is this simple code?

please help.

[cahva]

This issue has been discussed million times in these forums. Use the search button! Phpbuilder.com even has an article on this issue. Sorry if I sound a little unhelpfull and rude, but seriously the same question pops up atleast 5 times a week 🙂

[gat]

Could you pint me in the direction of these tutirials please.
im searching for next, prev, etc.... and finding nothing relevent.
I dont have any arrays or anything, just a list of paths.

i did post in newbs for a reason

[kevinsequeira]

here you go

http://www.phpbuilder.com/columns/rod20000221.php3

reg
kevin

[gat]

thanks

[kevinsequeira]

sorry my mistake wrong copy 'n paste ...

i edited the post ..

http://www.phpbuilder.com/columns/rod20000221.php3

reg
kevin

[gat]

<?php
$conn= @mysql_connect("localhost","*****","****")
   or die("Err:Conn");

$rs= @mysql_select_db("kriminalyouth", $conn)
   or die("Err:Db");

$limit=10; 
$numresults= mysql_query("select * from walls_berks ");
$numrows= mysql_num_rows($numresults);
if (empty($offset)) {
    $offset=1;
}
$result=mysql_query("select pic_path " ." from walls_berks $offset,$limit");
while ($data=mysql_fetch_array($result)) 
{
}
if ($offset==1) 
{ 
    $prevoffset=$offset-20;
    print "<a href=\"$PHP_SELF?offset=$prevoffset\">PREV</a> &nbsp; \n";
}
$pages=intval($numrows/$limit);
if ($numrows%$limit) 
{
    $pages++;
}
for ($i=1;$i<=$pages;$i++) 
{ 
    $newoffset=$limit*($i-1);
    print "<a href=\"$PHP_SELF?offset=$newoffset\">$i</a> &nbsp; \n";
}
if (!(($offset/$limit)==$pages) && $pages!=1) 
{
    $newoffset=$offset+$limit;
    print "<a href=\"$PHP_SELF?offset=$newoffset\">NEXT</a><p>\n";
}
?> 

ok, now i get this error.

---

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\program files\apache group\apache\htdocs\ky\slideshow.php on line 15

Notice: Undefined variable: PHP_SELF in c:\program files\apache group\apache\htdocs\ky\slideshow.php on line 21
PREV

Notice: Undefined variable: PHP_SELF in c:\program files\apache group\apache\htdocs\ky\slideshow.php on line 31
1

Notice: Undefined variable: PHP_SELF in c:\program files\apache group\apache\htdocs\ky\slideshow.php on line 31
2

Notice: Undefined variable: PHP_SELF in c:\program files\apache group\apache\htdocs\ky\slideshow.php on line 31
3

Notice: Undefined variable: PHP_SELF in c:\program files\apache group\apache\htdocs\ky\slideshow.php on line 31
4

Notice: Undefined variable: PHP_SELF in c:\program files\apache group\apache\htdocs\ky\slideshow.php on line 31
5

Notice: Undefined variable: PHP_SELF in c:\program files\apache group\apache\htdocs\ky\slideshow.php on line 31
6

Notice: Undefined variable: PHP_SELF in c:\program files\apache group\apache\htdocs\ky\slideshow.php on line 31
7

Notice: Undefined variable: PHP_SELF in c:\program files\apache group\apache\htdocs\ky\slideshow.php on line 31
8

Notice: Undefined variable: PHP_SELF in c:\program files\apache group\apache\htdocs\ky\slideshow.php on line 31
9

Notice: Undefined variable: PHP_SELF in c:\program files\apache group\apache\htdocs\ky\slideshow.php on line 36
NEXT

---

this help is much apreciated.
gat