same thing.... $query = "SELECT * FROM polls ORDER BY pollID DESC LIMIT 1";
dont need both params for LIMIT. just the num of rows u want back works too. Joel "Hans Prins" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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" <[EMAIL PROTECTED]> schreef in bericht > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > 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
