just a little point; u can replace <?echo $search_result2[a.retired_flag]?> by <?=$search_result2[a.retired_flag]?> which is better imho.
and you're entitled to it, but it's not better. Shorter isn't always better.
Your code will break if enable_short_open_tags is disabled in php.ini or an .htaccess file. Sure, it's on by default, but some people turn it off, especially when dealing with XML a lot.
-- ---John Holmes...
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/
PHP|Architect: A magazine for PHP Professionals – www.phparch.com
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php