(Keep your mails on the list as others may benefit)
I am assuming that you already have a script that is doing a SELECT
statement? If so, then modify your SELECT like so:
SELECT * FROM test_table LIMIT 0, 4
^^^^^^^^^^
This will bring back the first 4 rows of your query
SELECT * FROM test_table LIMIT 4, 4
^^^^^^^^^^
Will bring back the next for rows, and so on...
HTH,
Mikey
> -----Original Message-----
> From: Dean Hayes [mailto:[EMAIL PROTECTED]
> Sent: 01 August 2003 12:51
> To: [EMAIL PROTECTED]
> Subject: RE: [PHP-WIN] I Need Some Help please
>
>
>
>
> I Am Sorry i did not understand what u ment by that as i am a
> newbie to PHP
> and MySQL could you show me an example of the script so i can understand
> what you mean.
>
> Thanks
>
> Dean "The Insane Guy" Hayes
> Mystical Web Designs
> http://www.mystical-sector.com
>
> <-- I design and i redesign but still i never designed true
> beauty like you
> -->
>
>
>
>
>
> From: "Mikey" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Subject: RE: [PHP-WIN] I Need Some Help please
> Date: Fri, 1 Aug 2003 12:46:31 +0100
>
> It's not really a PHP solution, but if you add LIMIT off, rows
> (where off is
> the offset from the start (0) and rows is the number of rows you want
> returned) to your query, that should do what you require.
>
> HTH,
>
> Mikey
>
> > -----Original Message-----
> > From: Dean Hayes [mailto:[EMAIL PROTECTED]
> > Sent: 01 August 2003 05:33
> > To: [EMAIL PROTECTED]
> > Subject: [PHP-WIN] I Need Some Help please
> >
> >
> >
> > Hey,
> >
> > I am doing a script that calls items from a MySQL database.
> The Database
> > holds as many rows of information as the user has entered into
> it what i
> > need to do is call information from a list of different rows like
> > 3 to 5 or
> > 3 to 15 how ever many the user wants. Is there a way i can use a
> > script to
> > get this at all?
> >
> > Thanks
> >
> >
> >
> > Dean "The Insane Guy" Hayes
> > Mystical Web Designs
> > http://www.mystical-sector.com
> >
> > <-- I design and i redesign but still i never designed true
> > beauty like you
> > -->
> >
> > _________________________________________________________________
> > ninemsn Extra Storage is now available. Get larger attachments -
> > send/receive up to 3MB attachments (up to three times more per e-mail).
> > Click here http://join.msn.com/
> >
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> _________________________________________________________________
> ninemsn Extra Storage is now available. Get larger attachments -
> send/receive up to 3MB attachments (up to three times more per e-mail).
> Click here http://join.msn.com/
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
