SQL statement help: getting previous rec

djurnoce

I've got a table set up like this:
emp_id (primary key, int) | fname (char) | lname (char) | etc...

I've got a page showing the current employees information in a form. I want to give the user the option to view the next or previous employee in the database (based on the emp_id). I know the emp_id currently being displayed, but I dont know the previous or the next. The next employee id isnt always going to be 1 + the current employee id, it can be offset by anything (from deletions, etc). How can I strutcure an SQL query to get e the previous or next record?

Thanks!

Anon

setup your scipt to accept the variable $emp_id to lug into your SQL query.

<?
$emp_id_plus = $emp_id + 1;
$emp_id_minus = $emp_id - 1;

echo "
<a href=\"$PHP_SELF?emp_id=$emp_id_plus\">go forward</a>
 
href=\"$PHP_SELF?emp_id=$emp_id_minus\">go back</a>
";
?>

If there are hole in the sequence (1, 2, 3, 5, etc...) then I would add some conditional logic to add or subtract numbers from the $emp_id to get the correct next/prev numbers.

flipis

If you are using MySQL, there is a little function named mysql_insert_id()

It returns the last inserted id

Look here:

http://www.php.net/manual/en/function.mysql-insert-id.php

fLIPIS

rrijnders

For the next employee:

$sql = "select * from employees where emp_id > $curent_emp_id LIMIT 1";

For the previous employee:

$sql = "select * from employees where emp_id < $curent_emp_id LIMIT 1";

HTH
-- Rich

Anon

Heh finally someone posts the simple solution.