[RichieBoy67]

I don't know why but that wasn't working. I must be doing something wrong. I figured I was missing something..

Thanks so much Lynne, I will try again and figure out what I was doing wrong...

Thanks Lynne... Just me being stupid again..

PHP Code:

SELECT ,user.username
     , user.email
     , userfield.userid
     , userfield.field19
     , userfield.field20
     , userfield.field12
     , userfield.field13
     , userfield.field18
     , userfield.field14
     , userfield.field15
     , userfield.field16
    FROM userfield
INNER
  JOIN user
    ON user.userid = userfield.userid
 WHERE user.usergroupid = 15 


I see the problem now.. It is the "," on the first line... I have wasted the last 3 hours because of one ","!!! Who knows how much longer I would have spent on this if you didn't rescue me.

Thank you very much..