fetching DB entries

Hi All, This is just a bit of a 'throw it out to the masses' sort of question to see what people might recommend. At the moment, if I am retrieving a single record from the DB, my code looks like this: $query = "SELECT * FROM table WHERE id=1"; $result = mysql_query($query); while($row = mysql_fetch_array($result)) { return $row; } Now, aside from the actual SQL involved, is this efficient? Would it gain me anything if I used mysql_result() statements instead, or would that only be efficient if there were a small number of fields I was retrieving data for? Should I use something else entirely? I've not got to the testing this myself, as I figured something like this might be common knowledge for all of you who are better than me at optimisation. Is it even an issue if I'm only retrieving a single record in this manner (I always make my id field in a table the primary key, so it means I won't ever be retrieving more than one record) Thanks in advance for any input you guys have! Thanks, Ash http://www.ashleysheridan.co.uk