Re: Counting down

On 21/08/17 04:46, bit-naughty_at_hotmail.com wrote:
> 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.
>
$query=sprintf("select myfields from mytable where id='%d'",10-$i);

-- 
"The great thing about Glasgow is that if there's a nuclear attack it'll 
look exactly the same afterwards."

Billy Connolly