angelll gave me a great pointer to use GROUP_CONCAT to allow filenames to be grouped under their titles.
this was the result:
..........................
......
title1
file_text1
file_text2
filename1.pdf,filename2.pd
f
title2
file_text-a
file_text-b
filename-a.pdf,filename-b.
pdf
........................
I need to add the 'filename's as links on each of the 'file_text's but currently I'm getting the following when I add the links in html:
<body>
<p>title1</p>
<p><a href="uploads/filename1.pd
f,filename
2.pdf">fil
e1<br />file2</a></p>
<p>filename1.pdf,filename2
.pdf</p>
<p>title2</p>
<p><a href="uploads/filename3.pd
f,filename
4.pdf">fil
e-a<br />file-b</a></p>
<p>filename3.pdf,filename4
.pdf</p>
<p>title3</p>
<p><a href="uploads/filename5.pd
f">file-1a
</a></p>
<p>filename5.pdf</p>
<p>title4</p>
<p><a href="uploads/filename6.pd
f">file-aa
</a></p>
<p>filename6.pdf</p>
<p>title9</p>
<p><a href="uploads/filename7.pd
f">file-aa
a</a></p>
<p>filename7.pdf</p>
</body>
and the query for above:
$query_Recordset1 = "SELECT title, download_titles.title_id, download_files.title_id, GROUP_CONCAT(DISTINCT file_text SEPARATOR '<br />') file_text, GROUP_CONCAT(DISTINCT file) file FROM download_titles JOIN download_files ON download_titles.title_id = download_files.title_id GROUP BY download_titles.title_id, title ORDER BY download_titles.title";
thanks
Start Free Trial
