Hi Bill could you supply the database structure for all the tables in your project. I suspect you are needlessly duplicating data or access to it and seeing the structure may help to suggest a better one. For example you seem to be storing the species_name twice, once in the main table and again in the uvphotos table. That should never be necessary with a relational Db. Other ideas may also be obvious on seeing the current structure. -- Niel Archer -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php