database select
| From: | Hans Prins | Date: | Sun, 16 Feb 2003 11:10:29 +0000 |
| Subject: | database select | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-94272@lists.php.net to get a copy of this message | ||
Hello,
Im trying to select only one row in a mysql database (in this case a poll
with the smallest pollID)...........
Each row has a field called "pollID" which is the primary key and is auto
incremented when a new row is inserted.
I could possible do the following but I think its a bit extensive:
$query = "SELECT * FROM polls ORDER BY pollID ASC";
$result = mysql_query($query);
for ($count = 0; $count < 1 $count++) {
$data = mysql_fetch_array($result);
$pollID = $data['pollID'];
}
$query = "SELECT * FROM polls WHERE pollID = $pollID";
Does anyone now a solution for this that requires less code?
Thx