since i have got some good help here and am (of course) trying to help others. so since my php skills are still new (3 weeks into this stuff) I thought I could help in the database forum as SQL syntax is pretty universal. Of course the question I answered was one that does not work in MYSQL! (versus Oracle/MSSQL). Oh well. I tried.