如何检索记录从mysql表的文本框与下一个和上一个按钮 - how to retrive record in textbox from mysql table with next and previous button

how to retrive record in textbox from mysql table with next and previous button

在我的html表单有4个文本框和2个按钮previous和next我想在form.and中显示表记录，当用户单击next按钮时，下一条记录应在文本框中获取。请帮帮我吧提前感谢

<?php
    $id = 0;  
    if(isset($_POST['next']))
    {
       $id=$id++;
       $que = mysql_query("select * from table where id ='$id'");
       $data = mysql_fetch_array();
       $data1 = $data[1];
       $data1 = $data[2];
       $data1 = $data[3];
       $data1 = $data[4];
    }
    if(isset($_POST['prev']))
    {
       $id=$id--;
       mysql_fetch_array(select * from table where id ='$id')
       $data1 = $data[1];
       $data1 = $data[2];
       $data1 = $data[3];
       $data1 = $data[4];
    }
?>
<form method = "post">
<button name="prev">
<input type="text" value="$data1">
<input type="text" value="$data2">
<input type="text" value="$data3">
<input type="text" value="$data4">
<button name="next">   
</form>