I am building a custom forum system and am having trouble with the output of
pictures that are posted to a reply. Currently I have a replies table that
stores the reply text and a unique key for the pictures table. If the person
uploads pics, up to three max, then the pictures table stores 3 rows with pic
info and the unique id.
When I output the forum reply, I can only output one of the pics... Not sure
why? I am doing
<cfoutput query = "forum_reply">
<cfquery name = "pics" db = "db">
SELECT * FROM pics WHERE unique_id = '#unique_id#'>
I think I may need to loop through the reply rows or maybe a query of a query?
I'm not sure what I need to do but when there is a reply with more than 1 pic,
I need all to display.