Finding a Value In List

[dlebowski]

What I want to be able to do is this:

 

If I have a list of values in my database:

 

1

13

26

15

12

4

 

I do a query of this database and sort it asc so it looks like this:

 

1

4

12

13

15

26

 

I want to know how I can use php and/or sql query to find these values based off of "position" in the list.

 

If I wanted the 3rd value in the list, that value would be 12.  If i wanted the 2nd value in the list it would be 4.  How would I go about doing this?

 

Thank you in advance.

 

 

 

[$php_mysql$]

$sql =" SELECT * FROM database_name ORDER BY whatever ASC";

[Andy17]

This should work (with MySQL or PostgreSQL):

 

SELECT * FROM YourTable ORDER BY TableId ASC LIMIT 1 OFFSET 20

 

Replace the 20 with 11 for getting the 12th row.

[ignace]

while($row = mysql_fetch_object($result)) {    $keys[ ] = $row->id;    $data[ $row->id ] = $row;}var_dump($data[ $keys[1] ]); // second row