[violatordead]

Hello Webmasters,
This is my first post, and I am very glad that I am found this forum, a lot of usefull info! [thanks to forum creators!!!]

So my task briefly, I did develop web site for real estate agent http://www.luckymountainhome.com

Now I need to implement custom MLS listing for this web, already got IDX access for summit county. FTP access, 4 zip files with data and 4 zip files with pictures, 4 meaning RESIDENTIAL, PARTIAL, LAND and COMMERCIAL databases.
and separeted 4 folders with images for each item.

I am able to import each database (TXT format with Field delimiter : "|") to MS Access DB. Problem starts here

Database (TXT file) do not have image names for each property. The only field that some how can be related to the images can be MLS # Field and Images Count Field - cause image name contain MLSNUMBER_XXX_XX.jpg

So I did following using ASP >

<img src="imagesmls/<%=(Recordset1.Fields.Item("Field1").Value)%>_101_ 11.jpg" width="115">

_101_12.jpg - 90% of properties have this picture.

rest of them can be MLSNUMBER_101_22.jpg or MLSNUMBER_101_56.jpg

But there is a logic chain : if Property have 8 pictures than:
In database theres id field PROPERTYMLSNUMBER and field Image Count : [8]

and Image folder will contain folowing related images to this Property

MLSNUMBER_101_12.jpg
MLSNUMBER_201_32.jpg
MLSNUMBER_301_56.jpg
MLSNUMBER_401_23.jpg
MLSNUMBER_501_25.jpg
MLSNUMBER_601_22.jpg
MLSNUMBER_701_45.jpg
MLSNUMBER_801_22.jpg


see screen shot >>>


I am still dont know what last 2 numbers mean in image file name....but anyway,
may be somebody already had same task and issues

this is basically question about ASP
script should check first 7 symbols (mls number) and then add extension jpg removing last 7 digits...kinda wild card...

<img src="imagesmls/<%=(Recordset1.Fields.Item("Field1").Value)%>[WILD CARD].jpg" width="115">

this is about main listing page,

but for the detailed page

need to check image count field and if it = a
than create image list:
MLSNUMBER_101_XX.jpg
MLSNUMBER_201_XX.jpg
MLSNUMBER_301_XX.jpg
................................
MLSNUMBER_a01_XX.jpg

-----------------------------------------
Its Scenario...


so, i dont know may be some of the Guru will say - "PHP"
any advice will be helpfull
Thanks!!!!