Counting down
From: <bit-naughty_at_hotmail.com>
Date: Sun, 20 Aug 2017 20:46:39 -0700 (PDT)
Message-ID: <cf5c00cc-4534-4716-bd34-136a598e5bb5_at_googlegroups.com>
[Quoted] [Quoted] [Quoted] I have a DB, say 10 rows, with a primary key, numbered 1 to 10. Now, according to a PHP variable I have, say $i, I would like to fetch the 10th - $i field in the DB, ie. if $i is 3, then I wanna retrieve the 7th field in the DB. (it'll have to be sorted in DESC order, right?) How do I word the SQL statement, putting the $i into it? The quoting and stuff confuses me.... :)
Date: Sun, 20 Aug 2017 20:46:39 -0700 (PDT)
Message-ID: <cf5c00cc-4534-4716-bd34-136a598e5bb5_at_googlegroups.com>
[Quoted] [Quoted] [Quoted] I have a DB, say 10 rows, with a primary key, numbered 1 to 10. Now, according to a PHP variable I have, say $i, I would like to fetch the 10th - $i field in the DB, ie. if $i is 3, then I wanna retrieve the 7th field in the DB. (it'll have to be sorted in DESC order, right?) How do I word the SQL statement, putting the $i into it? The quoting and stuff confuses me.... :)
Thanks. Received on Mon Aug 21 2017 - 05:46:39 CEST