Re: pulling records from mysql
| From: | Tech Support | Date: | Thu, 25 Jul 2002 16:09:31 +0000 |
| Subject: | Re: pulling records from mysql | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-109527@lists.php.net to get a copy of this message | ||
This query will return only the 16th row
SELECT firstname FROM table_name LIMIT 16, 1
This query will give you all rows up to 15
SELECT firstname FROM table_name LIMIT 1, 15
Jim Grill
Support
Web-1 Hosting
http://www.web-1hosting.net
----- Original Message -----
From: "Tyler Durdin" <linuxgeek23@hotmail.com>
To: <php-general@lists.php.net>
Sent: Thursday, July 25, 2002 10:18 AM
Subject: [PHP] pulling records from mysql
> I have a column in my table named firstname with twenty records in it. How
> can i use php to pull out individual records (say for ex. record 16)?
Also,
> how could i pull out all records upto number 15? Thanks in advance.
>
>
>
> _________________________________________________________________
> Send and receive Hotmail on your mobile device:
> http://mobile.msn.com
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>