Re: DB row selection

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/