Re: [PHP-DB] Flipping through database records

2002-02-13 Thread Jason Cox
Dan Swensen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, 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? >

Re: [PHP-DB] Flipping through database records

2002-02-12 Thread Dan Swensen
x27;t 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

Re: [PHP-DB] Flipping through database records

2002-02-12 Thread Dan Swensen
, 2002 10:09 PM Subject: Re: [PHP-DB] 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

Re: [PHP-DB] Flipping through database records

2002-02-12 Thread Todd WIlliamsen
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]... > Interes

Re: [PHP-DB] Flipping through database records

2002-02-12 Thread olinux
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 t

Re: [PHP-DB] Flipping through database records

2002-02-12 Thread Jason Cox
g the card catalog at the library... :) Hope that helps, Jason Cox - Original Message - From: "Dan Swensen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 12, 2002 5:30 PM Subject: [PHP-DB] Flipping through database records > > Hello,

[PHP-DB] Flipping through database records

2002-02-12 Thread Dan Swensen
Hello, I am attempting to put together a page whereby results from a database are displayed, and previous / next hyperlinks allow the user to "flip" through records, one at a time. I attempted to do this by using a unique ID (that auto increments) and then including links like so at the bottom o