Gustav Wiberg wrote:
Hi there!
Is there any function in PHP that gives an ID from a MySQL-db based on
which position the record has in the table?
Let's say, there's a table like this:
1. Record1 ID 33
2. Record2 ID 76
3. Record3 ID 100
If I know position 2, I want to get ID 76. Is the only way to loop
through the recordset?
Why don't you use MySQL's LIMIT clause? Example:
SELECT * FROM myTable LIMIT 1,1
will retrieve the second row from myTable. You could combine that with
WHERE clauses or whatever. Note that the LIMIT syntax is LIMIT
[rowcount] or LIMIT [offset],[rowcount] and the offset starts at 0.
--
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/
If you find my advice useful, please consider donating to a poor
student! You can choose whatever amount you think my advice was
worth to you. http://tinyurl.com/7oa5s
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
