Hi there,
I made a collaboration system (weblog style). I can post messages with text and images.
From this weblog i've made a SQL report to show these posts.
But i can't get the select images (in sql query) to show these pictures. Somebody please help me with this topic.

the query

"select ad.title, ad.url, CONCAT(SUBSTRING(ad.synopsis,1,300),'...') AS synopsis from asset a, assetData ad where a.parentId='-9bCVvj2Ubm7QpfZclIFgA' and a.assetId=ad.assetId
and ad.status='approved'
and ad.isHidden=0
group by ad.title, ad.url
order by ad.revisionDate DESC
limit 1,3;" 

My question is what should i use to get the images and witch template var i must use to show the pictures om the webpage.

Many Thanks,

Rene

--- (Edited on 4/18/2008 2:29 am [GMT-0500] by rene) ---