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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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
>
>
>



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to