Forums
This topic is locked
Issue with using a DISTINCT in my sql
Posted 29 Jul 2002 19:00:37
1
has voted
29 Jul 2002 19:00:37 Zain Magsi posted:
I have a page where I need to list items from two colums. One is for an image (path) and one is the title of the image. There are multiple occurances of similar images and titles in the table which are sorted by a category passed to the page in the url. I want therefore show each record only once even though it has multiple occurances in the db table. I am using a DISTINCT in my sql which is doing the job well but I have to do it separately for the image and the title since the DISTINCT wont work with multiple records. This is forcing me to create two HTML tables side-by-side, one for each record with their own repeat regions. This way the webpage shows the title next to the image when viewed in the browser but not perfectly. What I want to do is, show the titles right below their images and put the whole thing in a horizontal loop.
How in the world do I achieve that? Please Help!
Zain Magsi