Re: database selection

thank you, that did the trick :) "Thomas Seifert" <thomas.seifert@myphorum.de> schreef in bericht news:20030216141748.6aa1753d.thomas.seifert@myphorum.de... > On Sun, 16 Feb 2003 12:51:58 +0100 HPrins@xgn.nu (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:thomas.seifert@myphorum.de > http://www.MyPhorum.de