alas this only works on phpmyadmin, I though was possible to have this query on a eg custom page inside the forum, darn I searched on the web and though was possible, maybe they refereed another "forum" s/ware not phpBB sorry for this OOT post ! thanks anyway for the help, sorry mate for m...