Actually Doug Thompson hit the nail on the head. i'm working on one server but the DB is on a different server, and I did not have delete privileges for that user. I blame myself for being a php/mysql newbie and not realizing that earlier. Thanks to all that replied. I'd like to add; I've been reading postings to this list for a few weeks now and am very impressed by the response time and the level of support provided to all with a minimum of flames. thanks again, cameron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php