Re: [PHP] MySQL previous next query

2001-02-08 Thread Richard Lynch
> I need to build a query that needs to find the previous or next record in a > database using a form. The records are numbered using a field called > 'sb_num'. This field is initially set using the form. > Would something like this work > Next: > Select 'field1', 'field2' from table order by sb_n

[PHP] MySQL previous next query

2001-02-05 Thread Luis Lebron
I need to build a query that needs to find the previous or next record in a database using a form. The records are numbered using a field called 'sb_num'. This field is initially set using the form. Would something like this work Next: Select 'field1', 'field2' from table order by sb_num where $s