We supply the pictures, you supply the captions http://www.sha-crawford.co.uk/captions pictures.dateTime,captions.dateTime,pictures.dateTime) AS maxDateTime FROM pictures LEFT JOIN captions ON captions.pictureID=pictures.id LEFT JOIN people ON people.id=captions.who ORDER BY maxDateTime DESC LIMIT 60 ) AS pictures LEFT JOIN peopleLinks ON pictures.id=peopleLinks.pictureID LEFT JOIN people ON peopleLinks.personID=people.id GROUP BY pictures.cid, pictures.id ORDER BY maxDateTime DESC "; $result = mysql_query($sql); while ($picture = mysql_fetch_assoc($result)) { $picture['title'] = str_replace("&", "and", $picture['title']); $picture['title'] = str_replace("<", "<", $picture['title']); $picture['title'] = str_replace(">", ">", $picture['title']); $rssDate=makeRSSdate($picture['maxDateTime']); $sql = "SELECT captions.id, people.hidden FROM captions LEFT JOIN people ON captions.who=people.id WHERE captions.id={$picture['cid']}"; $resultC = mysql_query($sql); $caption = mysql_fetch_assoc($resultC); print_r($caption); if($picture['caption']=="") { $line="No captions yet."; } else { if($caption['hidden']>1){ $who="Private Member"; } else { $who= "{$picture['caption_name']}"; } $line="{$picture['caption']} - $who"; } if($picture['hidden']<2) { $imgPath="<img src=http://www.sha-crawford.co.uk/captions/images/{$picture['id']}.jpg /><br/>"; $note=""; } else { $imgPath="<img src=http://www.sha-crawford.co.uk/captions/images/mo/{$picture['id']}_sm_mo.jpg /><br/>"; $note="<br/>You must be a member to view full sized image"; } print " $imgPath $line $note $rssDate http://www.sha-crawford.co.uk/captions?id={$picture['id']} http://www.sha-crawford.co.uk/captions?id={$picture['id']}&cid={$picture['cid']} "; } print " "; ?>