The limit clause allows you to specify the offset to the start of the records to retrieve
and the number of records to retrieve.
>Hello everyone,
>Sorry for the title,
>but you got to admit,it got your attention,
>I am a programmer working for a dot com company and
>i've designed a search engine for a
>personals/classifieds project.
>Everything is working fine but i just dont know how to
>do one thing......
>when you search the net you get 30 answers to your
>query adn a link for the balance
>eg
>"Next 30 answers...click here"
>
>how do they do that?
>My search brings all the data in one page,i know by
>using limit i can limit the data but what about the
>rest?
>Any ideas will be totally appreciated.
>
>And i promise if any of your ideas work i'll tell you
>guys some jokes that you NEVER heard before,
>i'm desperate and my job hangs in the balance.
>Cheers Ryan.
>
>
>__________________________________________________
>Do You Yahoo!?
>Kick off your party with Yahoo! Invites.
>http://invites.yahoo.com/
>
>--
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/php/manual.php" before
>posting. To request this thread, e-mail mysql-thread46456@stripped
>
>To unsubscribe, send a message to:
> <mysql-unsubscribe-cj=interlog.com@stripped>
>
>If you have a broken mail client that cannot send a message to the above
> address(Microsoft Outlook), you can use http://lists.mysql.com/php/unsubscribe.php
Christopher R. Jones, P.Eng.
14 Oneida Avenue
Toronto, Ontario M5J 2E3
Tel. 416 203-7465
Fax. 416 203-3044
Email cj@stripped
| Thread |
|---|
| • SEX,mysql and Java Servlets | Ryan Ahmed | 2 Aug |
| • Re: SEX,mysql and Java Servlets | Steve Ruby | 2 Aug |
| • Re: SEX,mysql and Java Servlets | Laszlo G. Szijarto | 2 Aug |
| • LIMIT and DBI placeholders | Ephraim Dan | 3 Aug |
| • Re: LIMIT and DBI placeholders | Jeremy Cole | 3 Aug |
| • Re: SEX,mysql and Java Servlets | Christopher R. Jones | 2 Aug |
| • Re: SEX,mysql and Java Servlets | Ryan Wahle | 2 Aug |
| • Re: SEX,mysql and Java Servlets | Jeremy Cole | 2 Aug |
| • Re: SEX,mysql and Java Servlets | Dana Powers | 2 Aug |
| • Re: SEX,mysql and Java Servlets | Eric Cox | 2 Aug |
| • Re: SEX,mysql and Java Servlets | Paul Schmidt | 3 Aug |
| • Re: SEX,mysql and Java Servlets | Milk Man | 5 Aug |
| • Re: SEX,mysql and Java Servlets | Ryan Wahle | 5 Aug |