Image Variable in Link Row based on Link Variable

[ezykiwi]

Just wondering if anyone can help out with this...

I have added a custom field in my links table called linkdata

what I would like... is for it to show a image in the rows.html based on this variable

for example

if $linkdata = '1'

then $dataimage = "http://www.url.com/image1/jpg"

else if $linkdata = '2'

then $dataimage = "http://ww.url.com/image2.jpg"

Just wondering where i should insert the code... and where i should call the variables from the database... so that I can insert <%dataimage%> into rows.html

[ezykiwi]

Solved.... Found a work around....

[inspireme]

If anybody is intrested jsut have a text field and either have the field filled iwth a 1 or 2, then call the field like this : <img src="whatever.com/images/<%fieldname%>.jpg"> then depending on whats in the field either 1.jpg or 2.jpg is loaded.

Not sure how ezykiwi did it, but this is how i do it

[ezykiwi]

Yeh... thats the way I had it... due to some other mods ive done i needed to find a way to choose which location based on a link variable..

but yeh that works totally if all the images are named as their linkid