Thank you, Richard, I simply change this part (select * from openart_table) into (select substring(loc1, 1, 3) as THREE_LETTER_CODE, * from openart_table) but Ive got this error, whats wrong with it? Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\apache......\openart\test\openart_search.php on line 98 Records Found Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\apache....\openart\test\openart_search.php on line 100 Cheers -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
