Hi thanks for the reply's. Aamit I dont want to delete the duplicates I just don't want to display them when I echo out the results form the table I just want to display the results once.
Thanks ShawnCplus, but when I tryed your surgestgion I didn't get anything to display.
So still trying. Thanks though guys