Selection of records in list

[Jean Biver]

Dear folks:

I was wondering how to query MySQL to display only a selection (1-20,
21-40) of a query in an HTML list. Can that be done in an SQL
statement, or do you have to use PHP to dissect the returned array
with for n elements to n+20 elements. How does Google achieve the
returning of results in its search engine. I imagine that the same
query may not necessarily be executed each page listing. I am
wondering whether the results from the query would return an array of
say 36000 elements.

Regards,
Jean Biver

[Tony Marston]

jb****@internet.lu (Jean Biver) wrote in message news:<f8**************************@posting.google. com>...

Dear folks:

I was wondering how to query MySQL to display only a selection (1-20,
21-40) of a query in an HTML list. Can that be done in an SQL
statement, or do you have to use PHP to dissect the returned array
with for n elements to n+20 elements. How does Google achieve the
returning of results in its search engine. I imagine that the same
query may not necessarily be executed each page listing. I am
wondering whether the results from the query would return an array of
say 36000 elements.

Regards,
Jean Biver

Read the MySQL manual at
http://www.mysql.com/documentation/m...ce.html#SELECT

and check out the 'LIMIT [offset,] rowcount' option. This will do
precisely what you want. I use it all the time.

Tony Marston
http://www.tonymarston.net/