One more question about this: If I wanted to select the last row, would I use this code?
$query = "SELECT * FROM polls ORDER BY pollID DESC LIMIT 0,1"; "Hans Prins" <[EMAIL PROTECTED]> schreef in bericht [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > thank you, > > that did the trick :) > > "Thomas Seifert" <[EMAIL PROTECTED]> schreef in bericht > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > 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
