Re: DB row selection

That's weird.............. that was the first thing I tried (DESC), but it gave me a syntax error at runtime...... however, when I tried it now, it worked.......... I probably had another error that confused me. Thx a bunch :-) "Ernest E Vogelsinger" <ernest@vogelsinger.at> schreef in bericht news:5.1.1.6.2.20030219110047.0320a588@mail.vogelsinger.at... > 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/ > >