Increment mysql

[dreamwest]

How can i  create a query that selects (increments) the next row

 

$next = $_GET['next']; 
$next = $next +1; //increment to the next row
"SELECT * FROM red WHERE approve='1' and id='{$next}' "

 

This is ok if the are no missing ids in the table

 

1

2

3

4

5

6

 

But will create a problem with this

 

1

2

5

6

[cags]

Sound like you should be using the LIMIT keyword to limit 1 result and set the offset.

[Mchl]

If you want query to have a column with row numbers you need to do it like this

SET @rownum = 0;
SELECT @rownum := @rownum + 1 AS rowNo, t.* FROM table AS t;

 

These are two queries that have to be run one after another.

[fenway]

Why are you trying to do this?