I'm doin a football site, and what i would like to have is a Current Form table (not form used in webstuff but form as in how well they are playing)

I've got 3 images - Win, Lose + Draw

In a DB table i'll a have a field populated with a seperate category with the fields - win, lose and draw

Ok, so i want to have a repeat region (horizontal) showing a line of images representing their performance.

Like - WWWDLLDDLLLWWWWDLDDWW but only with images.

I know how to do it for 2 images and a yes/no value but this has boggled me a bit <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Cheers chaps

Regards,
Dave

UD4 || Flash || Access ||Web Hosting

Assuming that your recordset is called RSresults:


&lt;%
Dim strResult, strDisplayImage
strResult = RSresults.fields.item("Result_Fields_Name".value
%&gt;

&lt;% If strResult = "Win" Then strDisplayImage = "Win.jpg" End IF %&gt;

&lt;% If strResult = "Draw" Then strDisplayImage = "Draw.jpg" End IF %&gt;

&lt;% If strResult = "Lose" Then strDisplayImage = "Lose.jpg" End IF %&gt;

Insert this where you want the image to appear:

&lt;img src="&lt;%=strDisplayImage%&gt;"&gt;

and add a repeat region on it. If it is not in a table it will automatically repeat across the page. Then, you can copy and paste the code into the table row (if you want it to reside there)






Regards
Vince

Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting

Is it possible to also, have the same recordest display in a table with a "style" applied depending on the result.

i.e : &lt;% If srtResults = "win" Then Response.Write "&lt;TD BGCOLOR='red'&gt;" End if%&gt;

or something along them lines

Regards,
Dave

UD4 || Flash || Access ||Web Hosting


Edited by - UltraDav on 28 Sep 2002 07:36:53

Vince the code you supplied works with no errors, only it shows only the WIN graphic.

Should look like : WWLWL
Looks Like : WWWWW

The rs is called rsClanAForm, and heres the code to display the graphics

&lt;%
Dim strResult, strDisplayImage
strResult = rsClanAForm.fields.item("Result".value
If strResult = "Win" Then strDisplayImage = "win.gif" End IF
If strResult = "Draw" Then strDisplayImage = "draw.gif" End IF
If strResult = "Lose" Then strDisplayImage = "lose.gif" End IF
%&gt;

any ideas?

Regards,
Dave

UD4 || Flash || Access ||Web Hosting

Is the code with the if statements inside the repeat region?

If it is above it, then you will only get wwww.



Regards
Vince

Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting

ah i see, will try it out.

I got the images to work ok, i had to redesign the DB , and put an IMGresult field in the main table and just filtered the records from that, worked a lot easier but made the DB much bigger, would much rather have it working the way you showed me.

I'll let you know how it goes..

page is @ www.nova-cs.co.uk/version2/clan_results.asp if u wanna have a look.

Regards,
Dave

UD4 || Flash || Access ||Web Hosting