, February 12, 2002 11:40 PM
Subject: Re: [PHP-DB] Flipping through database records
Actually, now that I think of it... how would you move from one record to
the next, if not querying by userid?
Optimally, I would like to have a page that displays one row from a table,
and links
Dan,
Here's an idea for you:
Rather than try to pass the uid through the pages, pass a counter that will
act as an index to your result array. For example, let's say you have a
query like: select * from myTable order by someCol; The order by will help
give some sort of uniformity to the list
Interesting Jason, just to make sure I'm clear:
basically, you would query the table and
while loop through the query result and create an
array and then store that in a session?
olinux
--- Jason Cox [EMAIL PROTECTED] wrote:
Dan,
Here's an idea for you:
Rather than try to pass the uid
how about just not do it by userid? query some other column thats in there
maybe by last name?
SELECT * FROM $tablename WHERE lname = $lname LIMIT [#results per page]
That should eliminate gaps
Olinux [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Interesting
] Flipping through database records
how about just not do it by userid? query some other column thats in
there
maybe by last name?
SELECT * FROM $tablename WHERE lname = $lname LIMIT [#results per page]
That should eliminate gaps
Olinux [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED
think how you would do that querying by,
say, lname or the like.
- Original Message -
From: Todd WIlliamsen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 12, 2002 10:09 PM
Subject: Re: [PHP-DB] Flipping through database records
how about just not do it by userid? query