Get next data set

[Merlin <news.groups@xxxxxx>]

Hi there,

I am trying to figure out how to write a sql statement for mysql with php that 
returns the next possible data set. For example I do have the ID number of a 
current data set, now I would like to retrieve the next data set with the next 
higher ID number. Sometimes there are deleted Ids, thats why one cant just 
increment the data ID.

Here is how I tried it:
	$stmt ="			
		SELECT
			g.place
		FROM
			$T33 g
		WHERE
			g.ID < $prev[id]
		LIMIT  1
	";

That unfortunatelly returns the very first row in the table.

Any ideas how to solve that?

Thanx for any help,

Merlin

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php