Create a column like.person_id with the auto_incr flag set. Every
record will be given a unique id starting at 1 and incrementing by 1 each
time. Then you can query based on person_id field to get an individual
record
-Original Message-
From: Tyler Durdin [mailto:[EMAIL PROTECTED]]
You would need to use SQL to identify which columns and rows you need to retrieve,
then use various MySQL PHP functions to gather the information.
For your two queries, they would appear thus, respectively:
SELECT firstname FROM tablename WHERE id=16
and
SELECT firstname FROM tablename ORDER
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
Yes, that will indeed return the rows specified, but the result is very unstable. By
it's nature, MySQL does not have to conform to any sorting method unless you specify
it. So it's very good practice when retrieving multiple rows to ALWAYS order them.
Just my thoughts :o)
Martin
Tech
4 matches
Mail list logo
