[ivan]

need a script.
i have a table in mysql
id | name | email | address | job
1 | agnes | agnes@aha.com | new york | accounting
3 | jose | jose@bla.com | california | manager
5 | robert | robert@xxx.com | new jersey | IT

display query page :
1. agnes (link to detail)
2. jose (link to detail)
3. robert (link to detail)

when i click link above(ex: jose), display detail data for jose

name : jose (jose@bla.com)
address : california
job : manager
<< previous (agnes) || next (robert) >>

also when i click link robert, display detail data for robert
name : robert (robert@xxx.com)
address : new jersey
job : IT
<< previous (jose) || next (agnes) >>

help me..

[Stefan]

this is pretty basic php coding, instead of asking here you might want to try this yourself and get a bit better at php. I'll give you some pointers:

there are two files:

overview.php
details.php

overview.php should only get the id and name of the person from the database, then link to details.php and pass on the id... something like details.php?id=1

then details.php should retrieve all information from the database for that one id.

the previous and next links are a bit more tricky. you'll need to find out the previous id and the next id, then retrieve the name for those id's from the database and create the links.

[ivan]

name : jose (jose@bla.com)
address : california
job : manager
<< previous (agnes) || next (robert) >>
agnes with id=1 and robert with id=5

how to make previous id and the next id, then retrieve the name for those id's from the database and create the links.
thanks for reply.