On Sun, 16 Feb 2003 12:51:58 +0100 [EMAIL PROTECTED] (Hans Prins) wrote:
> 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
>
>
$query = "SELECT * FROM polls ORDER BY pollID ASC LIMIT 1";
Thats the only row.
Regards,
--
Thomas Seifert
mailto:[EMAIL PROTECTED]
http://www.MyPhorum.de
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
