retrieve single field from database without while loop

Is there a way to retrieve and display a single value (customer number) from a database and display it without using while ($row = mysql_fetch_array) ($result)){ I have a value I know the query will only ever return a single value. I want to get it from the database and convert it to a variable so I can use it on my php page. Thanks in advance, Ross