HTML form element - navigation MySQL record

[banderaz]

Hello,

I am developing a user form to manage data on a MYSQL database.
One of the graphical elements on the form is a navigation button: go to the next / previous record.

I am planning to display the value of the array $row in the given form objects for the record. The $row array would be executed as many times as the user clicks on the next button. (incremented by variable $i from Javascript)

for ($j=0;$j<$i;$j++)
{
$row = mysql_fetch_row($result); // fetch NEXT record
}

As an amateur programmer I would like to ask if there is any better solution.

Kind regards
Banderaz

[jdorsch]

You want to use limit

SELECT * FROM mytable LIMIT {$i}, 1

This will select 1 record starting from $i. Make sure and escape $i or whatever if its coming from javscript.