result +1

[adzie]

Hello folks,

 

I want to display the next available row in my DB, I can get it to display the last row but want it to show that +1 ie the next available row.  Any thoughts

 

					$qry = "SELECT * FROM user ORDER BY user_id DESC LIMIT 1"; 
					$res = mysql_query($qry);
					$row = mysql_fetch_array($res);

[haku]

$qry = "SELECT * FROM user ORDER BY user_id DESC LIMIT 2, 1"; 

 

The limit says "start at the second entry, and get 1 entry.

[Zhadus]

$qry = "SELECT * FROM user ORDER BY user_id DESC"; 
$res = mysql_query($qry);
while ($row = mysql_fetch_array($res)) {
echo $row;
$values[] = $row;
}

You could load all the values up and display exactly what you need.