Re: Getting One Row of a result

mysql_fetch_array() will do....ofcourse if you know there is one result, no need to put it inside a loop. you can also use mysql_result() "Jordan Elver" <jord@theinternetone.co.uk> wrote in message news:01100912000005.01857@jordan.utopia.net... > Hi, > If I know that a query is only going to return one record, what is the mmost > efficient way of fetching that result and getting it into a variable? > > I currently use mysql_fetch_array with list, like: > > while(list($vars_here) = mysql_fetch_array($result)) { > > // do stuff > } > > ANy help would be good, > > Thanks, > > Jord