database select

From: 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

« previous php.dev (#94272) next »