DB row selection
| From: | Hans Prins | Date: | Wed, 19 Feb 2003 09:57:51 +0000 |
| Subject: | DB row selection | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-136131@lists.php.net to get a copy of this message | ||
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