Re: DB row selection

You might want to look at mysql_data_seek() HTH RVW Quoting Hans Prins <HPrins@xgn.nu>: ### 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? ### ### Or is there a way to do this without an extra query? ### ### thx, ### ### Hans ### ### ### ### -- ### PHP General Mailing List (http://www.php.net/) ### To unsubscribe, visit: http://www.php.net/unsub.php ### ### -- Richard Whitney * Transcend Development Producing the next phase of your internet presence. rw@xend.net * http://xend.net * 602-971-2791 * * * * * *__ * * _/ \___ * * / * \* * */ * * \ * */\_ |\ / \_ / \ / \____/ \ / \ / \ / \