PHP/MySQL - Best way to return a single value

[seventeen]

What is the best way to return a single value from a mysql query with php? Rather than use mysql_fetch_array or assoc...

Basically is there a mysql function i can use to return the value into a single variable?

ex:

$single_value = mysql_...($resource);

 

[Volante]

http://www.php.net/mysql_result

Retrieves the contents of one cell from a MySQL result set.

 

[seventeen]

wow, thanks so much. I had no idea that existed. hah.