* Nikolas > If I have a table ordered by something, is it possible to select fields > from a record that appears on the table in a specific row number. > And if yes, how can I do it? > > By row number, I mean that if the table has 10 records, I want to select > something from the record that is in the 6th row, for example.
You can use the limit clause of the select statement: SELECT * FROM mytable ORDER BY something LIMIT 6,1; The first parameter of LIMIT says where you want to start, the second says how many rows you want. <URL: http://www.mysql.com/doc/S/E/SELECT.html > -- Roger query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
