[snip] 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. [/snip] Yes...take out the while.... $row = mysql_fetch_array($results); echo $row['CustomerNumber'] . '\n'; -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php