with php: echo $result['field_number_of_bedrooms'] . " Bedrooms"; wih SQL: SELECT CONCAT(field_number_of_bedrooms, ' Bedrooms') as field_number_of_bedrooms from table; echo $result['field_number_of_bedrooms']; -- Maxim Maletsky maxim@php.net On Sun, 2 Feb 2003 12:46:16 -0600 Addison Ellis <addison@bellsouth.net> wrote: > hello, > i have a form someone fills out, say with the field # of > bedrooms. they submit. data goes into db. how can i get the # of > bedrooms to print "4 Bedrooms" instead of just "4"? > thank you, addison > -- > Addison Ellis > small independent publishing co. > 114 B 29th Avenue North > Nashville, TN 37203 > (615) 321-1791 > addison@bellsouth.net > info@smipco.com > subsidiaries of small independent publishing co. > info@gloabaldog.com > info@momandpocentral.com > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php