The problem with LIMIT is that this table is not the same always, the ordering depends on data that changes.
I am ordering a table that contains webpages by the number of times they have been visited. Then, for a specific page of them, I want to say in which position of popularity it is. I think, in the meantime, I found the way. I will make a COUNT of all pages, then I will make a COUNT of the pages that have been visited less times than the one I want and then I will add 1 to that. Am I in the right direction. Thanks for your interest. Roger Baklund wrote: >* 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
