i have the following code :
<?php
include("connect.php");
$query=("SELECT `uid` FROM `lagina` . `users`");
$select=mysql_query($query);
$row=mysql_fetch_array($select);
$id=$row[uid];
if (isset($_POST['next'])) {
$query_1=("SELECT `uid` FROM `lagina` . `users` WHERE `uid` > $id");
$select_1=mysql_query($query_1);
$row_1=mysql_fetch_array($select_1);
$id_1=$row_1[uid];
}
?>
<html>
<form action="test.php" method="POST">
<input type="submit" name="prev" value="pre">
<input type="submit" name="next" value="next">
<input type="hidden" name="pro" value="1">
</form>
</html>
all i need is each time i click next i go to the next uid and each time i click prev i go to the perv record so any body can help ?