hi, thanx for your input. i noticed that the last part of the create table query was the part that was causing the 'problem'. the on commit delete rows was deleting the values i inserted after executing the query therefore i couldnt select anything from it. i did try Richard Lynch's code and it works fine. thanx. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
