shawntbanks
Programmer
I am trying to have a list of artist, and beside them on the page a list of all artwork that is related to that artist. for example
artist 1:
artwork1
artwork2
artwork3
artwork4
This is my query.
<cfquery datasource="artworks" name="get_artist">
select artist.fname, artist.lname, artwork.name
from artist
inner join artwork on artist.artist_id = artwork.artist_id
group by artist_id
order by fname</cfquery>
This is where I am trying to make the table
<table><tr><td><div class="heading1">
Current Artists:</div></td></tr>
<cfoutput query="get_artist">
<tr><td valign="top">#fname# #lname#</td><td valign="top">#name#</td></tr>
</cfoutput>
</table>
I am probably missing the obvious.
Thanks in advance for your help
artist 1:
artwork1
artwork2
artwork3
artwork4
This is my query.
<cfquery datasource="artworks" name="get_artist">
select artist.fname, artist.lname, artwork.name
from artist
inner join artwork on artist.artist_id = artwork.artist_id
group by artist_id
order by fname</cfquery>
This is where I am trying to make the table
<table><tr><td><div class="heading1">
Current Artists:</div></td></tr>
<cfoutput query="get_artist">
<tr><td valign="top">#fname# #lname#</td><td valign="top">#name#</td></tr>
</cfoutput>
</table>
I am probably missing the obvious.
Thanks in advance for your help