At 10:57 19.02.2003, you said:
--------------------[snip]--------------------
>Hello,
>I recently learnt that with the code as stated below, I can select one row:
>
>$query = "SELECT * FROM polls ORDER BY pollID ASC LIMIT 0,1";
>
>However as far as I could figure out, I can only select the top row or tell
>it at what rownumber to start and end. What if I wanted to select the bottom
>row? Would I have to do an extra query to count the rows and then select it
>with LIMIT?
--------------------[snip]--------------------
$query = "SELECT * FROM polls ORDER BY pollID DESC LIMIT 0,1";
--
>O Ernest E. Vogelsinger
(\) ICQ #13394035
^ http://www.vogelsinger.at/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
