Glad to help.

pr0gr4mm3r — Wed, 22 Oct 2008 21:11:47 +0000

Glad to help.

Hello pr0gr4mm3r you always

benf — Wed, 22 Oct 2008 19:44:29 +0000

Hello pr0gr4mm3r you always answer my questions promptly - appreciated.

It works perfectly.

Although the tables are not

pr0gr4mm3r — Wed, 22 Oct 2008 14:22:24 +0000

Although the tables are not being joined correctly, this should work with the method you are using:

$sql1 = 'SELECT * FROM
   imageGallery,
   imageCat,
   phpbb_users
          WHERE
    imageGallery.catid = imageCat.ID
  AND
    imageGallery.userID = phpbb_users.user_id'
  AND
    imageGallery.catid = '.$db->sql_escape($catid).';

Joining the table using WHERE clauses is not the proper way to do it, though. Try something like this:

$sql1 = 'SELECT * FROM
   imageGallery
  INNER JOIN imageCat ON imageCat.ID = imageGallery.catid
  INNER JOIN phpbb_users ON phpbb_users.user_id = imageGallery.userID
  WHERE
    imageGallery.catid = '.$db->sql_escape($catid).';