HI all, I am querying a db and getting the resultset, then to get out each individual field of the resultset (which is a single unique line all the time) as mysql_result($result2, 0, "p_company"). the problem is that if the actual field has a space in it say "Sun microsystems", I only get "sun" and it doesnt give me anything after the first space. I have looked at the manual but as far as im concerned its really vague in its description of alot of the mysql functions. any idea what could be causing this?? thanx Angelo -------------------------------------------------------------------- Disclaimer This e-mail transmission contains confidential information, which is the property of the sender. The information in this e-mail or attachments thereto is intended for the attention and use only of the addressee. Should you have received this e-mail in error, please delete and destroy it and any attachments thereto immediately. Under no circumstances will the Cape Technikon or the sender of this e-mail be liable to any party for any direct, indirect, special or other consequential damages for any use of this e-mail. For the detailed e-mail disclaimer please refer to http://www.ctech.ac.za/polic or call +27 (0)21 460 3911 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php