Start Free Trial

asked on

How to design database using MS Access

Hi EE!

I don't know how explain exactly what my problem is, in regards to designing a database & to link it to my page (ASP).
Here it goes:
I have a structure like this:
STE Products
- Shower Unit
- Multi Point Unit
- Storage
... etc.

under Shower Unit
-- AQ Series
-- DD Series
-- DDC Series
... etc.

inside each series, it has many photos inside, such as:
(for AQ Series)
--- AQ 35 E.jpg
--- AQ 45 E.jpg

(for DD Series)
--- DD 35 E.jpg
--- DD 45 E.jpg
--- DD 60 E.jpg

... etc.

How can I do the design of it or what is the best design I can do for it.
I have a table named: STEProd, and the Field Names are ID (Auto#), Series, Photo, Link (Optional).
If I put the series for example AQ 35E under the series, and the path of its Photo, how can I link it to the web (ASP). Is it <img src="<%=rsSTEProd("Photo")%>"/> ? But it'll show or run continuously until the end of the database. what i want is if it's for AQ Series, it will show the photos of AQ 35E & AQ 45E only. So if 1 series have many photos inside, it doesn't matter, the only thing is I want the photos by each series to be shown.

I have on my mind, to create a Table for each series. What do u think?

But I'm searching for other opinion or advise from EE.

Thank you & wait for EE's reply then....

stiebel

Well, I must admit I've understood exactly what you want but I'll try to help.
First of all let's see if I've understood the database structure. You have products, each product have one or more series and each serie has only one photo. If that's the structure... I think the best would be to have one table for the products (with the ID and NAME), and one for the series (PRODUCTID SERIEID PHOTO LINK)
Next, to show the photos, <img src=<%=rs("Photo")%>"/> is the right choice, but to get only the photos you want you have to write the corresponding sql statement. If you explain me exactly how you want to show the things I can make it for you.

ASKER

Thanks Saphira for your prompt response!

I have a tree-view menu. But I'll skip into some parts & jump into part where I stopped.
I have a structure like this:
STE Products
- Shower Unit
- Multi Point Unit
- Storage
... etc.

under Shower Unit
-- AQ Series
-- DD Series
-- DDC Series
... etc.

inside each series, it has many photos inside, such as:
(for AQ Series)
--- AQ 35 E.jpg
--- AQ 45 E.jpg

(for DD Series)
--- DD 35 E.jpg
--- DD 45 E.jpg
--- DD 60 E.jpg

... etc.

Each series have a minimum of 2 photos inside its folder. Other series have more than 2.

I want to show the image in another _blank page, in whereas the photos of that series only. So for example I click the AQ Series, only the photos of AQ Series will show. AQ 35E & AQ 45E.
What do u mean for the PRODUCTID? Is PHOTOLINK is the path where the photo is located?

Wait for your reply again soon...
Thanks!

Ok, now I understand
The ProducID is just an identificator, it can be just a sequential number like 1,2,3 etc. It's just because I preffer not to use text columns as keys, but that's my opinion, you can just use the name as the table key.
Next, knowing that one serie can have more than one photo, I would change a bit the structure..
PRODUCT (PRODUCTID, PRODUCTNAME)
SERIE (PRODUCTID, SERIEID, SERIENAME)
SERIE_PHOTOS (SERIEID, PHOTO, LINK)
The url to the photo is stored in the PHOTO column, and LINK... I just put it because you had it in the first post as optional but I don't know for what you need it :P

I've writed also the sql statement. Look at it and tell me if it's what you needed

SELECT P.PHOTO
FROM SERIE_PHOTOS AS P
INNER JOIN SERIE AS S ON S.SERIEID=P.SERIEID
INNER JOIN PRODUCT as PR ON PR.PRODUCTID=S.PRODUCTID
WHERE P.PRODUCTNAME='Shower Unit' AND S.SERIENAME='AQ Series'

Open in new window

ASKER

Hello there Saphira! To tell you straight, I'm really boggled on what you advised. I don't know where to start & what will be the next... :-(
I'm kinda confuse here... as u can see from my message ID 30005194, from the structure that I showed, the STEProducts doesn't have Shower Unit only, it has Multi Point Unit, Storage, etc.
So I'm thinking what if the selection would be from Multi Point or Storage or Heat Pump or etc.?

OK,

The SQL was just an example. Where I've put Showe Unit you could write any other Product and the same with the Serie. That sql just gets from a serie of a product all of its photos.

What I don't know is if you want to get the photos for more than one product or serie at the same time. if this is the case you would need a different sql.

Tell me where you get confused or what you need and I'll try to help.

ASKER

Hi Saphira!

I have created an idea on my mind already & attached are the codes:

The name of my table is Products.
I have columns ID, Series, iPhoto, SeriesID, Type, & Remarks.
The name of that page is ste-shower-AQ.asp (for test only, then will change the name later).

Then I have a page named: ste-shower.asp , and it has a links inside, something like this:
<a href='ste-shower-AQ.asp?SeriesID=1'>AQ Series</a>

That link should call the data from the other page (ste-shower-AQ.asp) that has attached database with table named Products.

The problem is, everytime I click the said link above, it shows this error:
The page cannot be displayed
Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/iPhoto/ste-shower-AQ.asp, line 9

And line 9 is: Set rsProducts = myConnection.Execute(sqlContent)

What I want to happen is to show the content under SeriesID = 1. So if I have a link that the SeriesID = 2, it should show the content of that SeriesID.

But when I change the: "&SeriesID into '1'", it will show the data. But what if I have 200 or more data, I need to create 200 or more pages for it. I only want to design 1 page that will change the inside data bec. of SeriesID.

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>

Open in new window

In the DB, Seriesid what type is it?
The error I think is because the Seriesid you give and the one in the DB have different types.
Also try to write to the page the value of seriesid you get because it can be retrieving null or something like that.

ASKER

Hello to you again Saphira!

I changed the type of the SeriesID, from Text to Number.It worked! But the problem is, with the image, I have 2 images that I want to show. AQ 35 E.jpg & AQ 45 E.jpg
I have this code <img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>

It only show 1 image, the AQ 35 E.jpg. and the other image is not.

Could you please advise where is the problem?

Thanks in advance!

Well, one thing less :)

Are you writing the code inside a loop?

While not rsProduct.EOF
%>
  <img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
<%
  rs.MoveNext
Loop

Open in new window

ASKER

No it's not. It's not inside the loop. I tried your code, but it didn't work.
I'll attach my code.

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
..................
</head>
..................
<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+2"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
...........................
</html>

Open in new window

Ok, try this one.

I don't know if you want a for each picture. In my code is done in that way. If you want all the pictures inside the same just put the before the DO while and the afte Loop.

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
        Set myConnection = Server.CreateObject("ADODB.Connection")
        Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
..................
</head>
..................
<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
	<%
	Do While not rsProducts.EOF
	%>
	    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+2"> - <%=rsProducts("Remarks")%></font></b></a>
        </td>
	<%
		rsProducts.MoveNext
	Loop
	%>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
                <img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
...........................
</html>

Open in new window

ASKER

Got error:
Error Type:
ADODB.Field (0x80020009)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/iPhoto/ste-shower-units.asp

And this one?
The error is because it's trying to read data afte having reached last row.. but don't know why right now...

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
        Set myConnection = Server.CreateObject("ADODB.Connection")
        Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
..................
</head>
..................
<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
        <%
        Do Until rsProducts.EOF
        %>
            <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+2"> - <%=rsProducts("Remarks")%></font></b></a>
        </td>
        <%
                rsProducts.MoveNext
        Loop
        %>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
                <img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
...........................
</html>

Open in new window

ASKER

Still the same error:
Error Type:
ADODB.Field (0x80020009)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/iPhoto/ste-shower-units.asp

ohhhh I've seen the problem. Sorry, my mistake...
I left out of the while the las image so when it tried to read the column it gave error because we where after the last row...

Try with this one. (The appearence might not be what you want, but you can change it ;) )

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
        Set myConnection = Server.CreateObject("ADODB.Connection")
        Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
..................
</head>
..................
<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <%
	Do Until rsProducts.EOF
  %>
  <tr>
    <td>&nbsp;</td>
            <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+2"> - <%=rsProducts("Remarks")%></font></b></a>
        </td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
                <img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
	</td>
  </tr>
	<%
			rsProducts.MoveNext
	Loop
	%>
...........................
</html>

Open in new window

ASKER

I revised the code, please see the attached code. But the result isn't arrange correctly.
Kindly check the attached image. And is it possible to have it close together & in 1 row should be 4 images, then next would be on the next row...

<td>&nbsp;</td>
    
    <% 
        Do Until rsProducts.EOF 
    %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
        
       
    <br /><br />
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a>

    <% 
                rsProducts.MoveNext 
        Loop 
    %> 
    <td>&nbsp;</td>

Open in new window

I need a bit more of information...

What's this for?

»  STE Shower Units - - <%=rsProducts("Remarks")%>

and the images of the top which are?
Maybe it would be better if you paste all the code again...

Also a suggestion... don't use tables for the page design. Now css and divs is what it's used. But you choose :)

ASKER

What's this for?
<td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
» <img src="IMG/imgfolder.gif" /> STE Shower Units - <font face="verdana" size="+2"> - <%=rsProducts("Remarks")%></font>
</td>
-- "IMG/imgfolder.gif' is just a small folder icon beside a series title, but it's not the main subject image that I want to show accordingly.
-- <%=rsProducts("Remarks")%> --> from my database, it represents as the Series of each model. Such as: STE Shower Units - AQ Series

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <% 
        Do Until rsProducts.EOF 
    %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
        
       
    <br /><br />
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a>

    <% 
                rsProducts.MoveNext 
        Loop 
    %> 
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">&nbsp;
		
    </td>
  </tr>
   <tr>
    <td>&nbsp;</td>
    <td align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

Let's see if this one fits your requirements :)

If not, please attach and image of what is shown to see how to fix it

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
   <tr>   
<% 
dim i=0
Do Until rsProducts.EOF 
   end if
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>		
	</td>
	<td align="left" bordercolor="#999999" bgcolor="#FFFFFF">&nbsp;</td>
	<%
	if i>2 then
	%>
  </tr>
  <tr>
    <% 
		end if
		if i>2 then
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
%> 
    
  <tr>
	<td><a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font><a></td>
  </tr>
   <tr>
    <td>&nbsp;</td>
    <td align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

ASKER

Hello there Saphira!

I would like to apologize to you if I can't be able to respond to your response urgently. I'm out of the country right now for my vacation. I'm trying to remote my server so I can apply your advise, but the problem is i can't remote it. I think need to restart the server forcefully. This week, Thailand is on holiday, so no one is in our office, so I'll try to send message to my colleague by next week to help me restart it. However, if I can get chance this week, I'll let you know asap for the result.

Thanks!

ASKER

hello to you Saphira!

I'm back! And we can now continue to discuss this open thread again...
I tried your last advise, but still have error problem. Kindly check the attached image for the error result.

I'm just wonderin, you don't have "IF" in this part:
<%
dim i=0
Do Until rsProducts.EOF
end if
%>

but you have "end if" already...

Thank you again & hope to hear from you again soon...

Error2.jpg

Oh, sorry for that :S

It's true, delete that first end if inside the loop and tell me if it works

Really sorry...

ASKER

Still the same error.
Another thing is, why does the number is color red?
I know that if it's red in color, it has error in result...

Please check...

You mean why the numbers are in red?
Well, that's only the way the editor writes numbers, nothing more. (at least it's what I've seen this far

And could you show me again a picture of the error it's giving you (like the one before), and also paste all the code please.

I know this would be faster if I could try it, but I can't right now...

ASKER

The error is the same error message as in ID: 32132001.

I'm attaching the whole code below...

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>

<!--date-->
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <% 
		dim i=0
			Do Until rsProducts.EOF 
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
  	</td>
	<td align="left" bordercolor="#999999" bgcolor="#FFFFFF">&nbsp;</td>
	<%
	if i>2 then
	%>
  </tr>
  <tr>
    <% 
		end if
		if i>2 then
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
%>
  </tr>
  <tr>
    <td>       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a>
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">&nbsp;
		
    </td>
  </tr>
   <tr>
    <td>&nbsp;</td>
    <td align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

Well, I don't see anything strange...

Try the code below and tell me, if error, in wich line does it say it is. Just copy the Error type segment

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>

<!--date-->
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <% 
	dim i=0
	Do Until rsProducts.EOF 
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
  	</td>
	<td align="left" bordercolor="#999999" bgcolor="#FFFFFF">&nbsp;</td>
	<%
		if i>2 then
	%>
  </tr>
  <tr>
    <% 
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
%>
  </tr>
  <tr>
    <td>       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a>
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">&nbsp;
		
    </td>
  </tr>
   <tr>
    <td>&nbsp;</td>
    <td align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

ASKER

I just copied the script above, like what you've said, there's no strange from that codes.
But, still the same error.

Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/iPhoto/ste-shower-units.asp, line 105, column 5

I just copy & paste the scripts above to my previous codes, but still the same error...

oh, ****
I know what's the problem (I think) and it's a stupid mistake that I usually make when I left asp for a long time...
Copy this code and I think it should work.

The problem is that in asp you cannot define a variable and assign a value in the same line, so
dim i=0 gives error
it should be
dim i
i=0

Sorry for that :S

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>

<!--date-->
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <% 
	dim i
        i=0
	Do Until rsProducts.EOF 
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
  	</td>
	<td align="left" bordercolor="#999999" bgcolor="#FFFFFF">&nbsp;</td>
	<%
		if i>2 then
	%>
  </tr>
  <tr>
    <% 
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
%>
  </tr>
  <tr>
    <td>       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a>
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">&nbsp;
		
    </td>
  </tr>
   <tr>
    <td>&nbsp;</td>
    <td align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

ASKER

Got error again, but different line.
Please see the attached image for the error result.

Thanks!
Error3.jpg

ASKER

Hello Saphira! Please ignore my previous response, with ID: 32331897
It worked, but the images are still scattered.
Kindly check out the attached image...
Error4.jpg

Hi again, sorry for the waiting.

Try this one, and if it's not what you want, tell me how you want it and we'll try to get it.

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>

<!--date-->
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <% 
	dim i
    i=0
	Do Until rsProducts.EOF 
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
  	</td>
	<%
		if i>2 then
	%>
  </tr>
  <tr>
    <% 
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
%>
  </tr>
  <tr>
    <td>       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a>
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">&nbsp;
		
    </td>
  </tr>
   <tr>
    <td>&nbsp;</td>
    <td align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

ASKER

Hello to you Saphira!

We're already near to what I want! Kindly check the image named Blank space. What I mean with that is is it possible not to have a space, a big space in the middle of it? What I want is something like at Error5 image.
But i just copy & paste 1 image to show u what I want to happen...
About 4 image in 1 row, until there are no more image from the database to show. 4 images in a row.
So there will be different images in a row.

Then I have another requirement with this page, not only showing them, will let u know later after we done with this page.

Hope to hear from you again soon!
:-)
Error5.jpg
space-error5.jpg

Ok, I think this one should work...

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>

<!--date-->
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
</table>
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>    
    <% 
	dim i
    i=0
	Do Until rsProducts.EOF 
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
  	</td>
	<%
		if i>3 then
	%>
  </tr>
  <tr>
    <% 
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
%>
  </tr>
  <tr>
    <td colspan="2">       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a></td>
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">&nbsp;
		
    </td>
  </tr>
   <tr>
    <td>&nbsp;</td>
    <td colspan="3" align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

ASKER

It worked, Saphira! But I found a problem regarding the spacing, specially if its 2 images only. You can check the image attached named Space for 2 image.
But if its more than 2, if the images are 3 or more, it has no problem. Please check the another attached photo.

And what if I would like to add the NAME of each image below each image.

Another is, there'll be a login page for the users to download the original ZIPPED file of it. Because the images are only in Thumbnails & the original will be bigger & larger in size. And it's in CMYK format. But not all of users can download these images, that's why we need to have login page.
(Do I need to open a new thread for this login query or can continue with this thread?)
Then after that, it's done.

Hope to hear from you again soon!
:-)
Error6.jpg
correct.jpg

Hi,

About the login.. I think it would be better to open a new thread so other people can also help

I will check the code again to try to obtain what you want :)

ASKER

Ok. Will be waiting then... :-)

I don't know if this one will work, but let's try...

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>

<!--date-->
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
</table>
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>    
    <% 
	dim i
    i=0
	Do Until rsProducts.EOF 
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
		<br/>
		<p><%=rsProducts("Remarks")%></p>
  	</td>
	<%
		if i>2 then
	%>
  </tr>
  <tr>
    <% 
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
	if i<>0 then
	   %>
	   <td colspan="<%=(4-i)%>">&nbsp;</td>
	   <%
	end if
%>
  </tr>
  <tr>
    <td colspan="2">       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a></td>
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">&nbsp;
		
    </td>
  </tr>
   <tr>
    <td>&nbsp;</td>
    <td colspan="3" align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

ASKER

That's it! I just changed the COLUMN name so it'll show the name of each image.
Would it be possible to move 1 column to the right, all the images? Attached is the sample...

Thanks!
Move-img.jpg

Try this
Well, change again the column name :P

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>

<!--date-->
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
</table>
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr> 
	<td>&nbsp;</td>
    <% 
	dim i
    i=0
	Do Until rsProducts.EOF 
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
		<br/>
		<p><%=rsProducts("Remarks")%></p>
  	</td>
	<%
		if i>2 then
	%>
  </tr>
  <tr>
	<td>&nbsp;</td>
    <% 
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
	if i<>0 then
	   %>
	   <td colspan="<%=(4-i)%>">&nbsp;</td>
	   <%
	end if
%>
  </tr>
  <tr>
    <td colspan="2">       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a></td>
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">&nbsp;
		
    </td>
  </tr>
   <tr>
    <td>&nbsp;</td>
    <td colspan="3" align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

ASKER

Hello to you again Saphira!

The result, still the same. Didn't move 1 column to the right.
And like what I asked you earlier, the if the images are only 2, there's a space between them, but if its 3 or more, no problem.

Please check... Thanks!

Mmm, I thought it'll move...
Let's try again...

And if it doesn't work maybe it would be faster if you try also :)

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>

<!--date-->
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
</table>
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr> 
	<td>&nbsp;</td>
	<td>&nbsp;</td>
    <% 
	dim i
    i=0
	Do Until rsProducts.EOF 
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
		<br/>
		<p><%=rsProducts("Remarks")%></p>
  	</td>
	<%
		if i>2 then
	%>
  </tr>
  <tr>
	<td>&nbsp;</td>
	<td>&nbsp;</td>
    <% 
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
	if i<>0 then
	   %>
	   <td colspan="<%=(6-i)%>">&nbsp;</td>
	   <%
	end if
%>
  </tr>
  <tr>
    <td colspan="2">       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a></td>
    <td>&nbsp;</td>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">&nbsp;
		
    </td>
  </tr>
   <tr>
    <td>&nbsp;</td>
    <td colspan="3" align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

ASKER

I think the previous design is better, just move 1 column to the right.
Because the new code that you advise, moves just a little & the link below isn't ok, it doubles the line. So I return back to the previous codes that you advise...

Could you show some images of the codes, the last and the previous one please?

ASKER

Please see the attached files for the comparison of the previous codes with the latest codes.
previous-code1.jpg
previous-code2.jpg
latest-code-01.jpg
latest-code-02.jpg

Let's try if this one works better

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>

<!--date-->
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
</table>
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr> 
	<td width="134">&nbsp;</td>
    <% 
	dim i
    i=0
	Do Until rsProducts.EOF 
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
		<br/>
		<p><%=rsProducts("Remarks")%></p>
  	</td>
	<%
		if i>2 then
	%>
  </tr>
  <tr>
	<td>&nbsp;</td>
    <% 
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
	if i<>0 then
	   %>
	   <td colspan="<%=(4-i)%>">&nbsp;</td>
	   <%
	end if
%>
  </tr>
  <tr>
	<td width="134">&nbsp;</td>
    <td colspan="4">       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a></td>		
  </tr>
   <tr>
    <td width="134">&nbsp;</td>
    <td colspan="4" align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

ASKER

Please see the attached images for the result of 2 images, 3 images, & more than 3 images.
If it's more than 3 images, kindly check the attached picture for the result of it...

Kindly check the img named Alignment, for you to see what alignment I require...

Thanks again for the support! We're almost near :-)

Then I need to open a new thread for the link & login right?
2-img.jpg
3-img.jpg
alignment.jpg
more-than-3img.jpg

Could you tell me the width of the image logo_res.jpg?

And I would preffer if you opened a new thread for the other question :)

ASKER

Log_res.jpg size: W = 200px; H = 223px

And this one?

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>

<!--date-->
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
</table>
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr> 
	<td width="200">&nbsp;</td>
    <% 
	dim i
    i=0
	Do Until rsProducts.EOF 
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
		<br/>
		<p><%=rsProducts("Remarks")%></p>
  	</td>
	<%
		if i>2 then
	%>
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    <% 
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
	if i<>0 then
	   %>
	   <td colspan="<%=(4-i)%>">&nbsp;</td>
	   <%
	end if
%>
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    <td colspan="4">       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a></td>		
  </tr>
   <tr>
    <td width="200">&nbsp;</td>
    <td colspan="4" align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

ASKER

2 images, are fit correctly. But for 3 or more images, still the same.

So with 2 images shows ok but with 3 or more not? Still too to the left?
Strange...

Image please?

ASKER

Please see the attached files.
2-img.jpg
3-img.jpg
more-than-3img.jpg

Try this one. If this down't work I'd need more time to check it...

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>

<!--date-->
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
</table>
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr> 
	<td width="200">&nbsp;</td>
    <% 
	dim i
    i=0
	Do Until rsProducts.EOF 
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
		<br/>
		<p><%=rsProducts("Remarks")%></p>
  	</td>
	<%
		if i>2 then
	%>
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    <% 
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
	if i<>0 then
	   %>
	   <td colspan="<%=(3-i)%>">&nbsp;</td>
	   <%
	end if
%>
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    <td colspan="4">       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a></td>		
  </tr>
   <tr>
    <td width="200">&nbsp;</td>
    <td colspan="4" align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

ASKER

Still the same... no changes...

Could you send me the code that is being generated?
I'm a bit confused... :S

ASKER

What do u mean? I just used your advised code from ID: 32651197

I mean the html code that's generated when the asp page is executed.
Click with the right button and then show code or something like that.

ASKER

Please see the attached generated html code.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
 
<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
 
<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">
 
<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css"> 
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;
 
	}
 
	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}
 
	.b
	{
		font-color:#0A0EB7;
	}		
 
-->
</STYLE>
 
<!--date-->
<SCRIPT LANGUAGE="JavaScript"> 
 
<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>
 
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
 
 
</head>
 
<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - DD Series</font></b></a>
	</td>
 
  </tr>
</table>
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr> 
	<td width="200">&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DD/DD 35 E.jpg" alt="DD Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DD Series</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DD/DD 45 E.jpg" alt="DD Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DD Series</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DD/DD 60 E.jpg" alt="DD Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DD Series</p>
  	</td>
	
	   <td colspan="0">&nbsp;</td>
	   
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    <td colspan="4">       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a></td>		
  </tr>
   <tr>
    <td width="200">&nbsp;</td>
    <td colspan="4" align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

I'm starting to get reaaaaally lost....
Try this...

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb")
	Set myConnection = Server.CreateObject("ADODB.Connection")
	Set rsProducts = Server.CreateObject("ADODB.Recordset")
SeriesID = request.QueryString("SeriesID")
myConnection.Open connectString
sqlContent = "SELECT ID, Series, iPhoto, SeriesID, Type, Remarks FROM Products WHERE SeriesID ="&Seriesid
Set rsProducts = myConnection.Execute(sqlContent)
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">

<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css">
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;

	}

	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}

	.b
	{
		font-color:#0A0EB7;
	}		

-->
</STYLE>

<!--date-->
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>


</head>

<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - <%=rsProducts("Remarks")%></font></b></a>
	</td>

  </tr>
</table>
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr> 
	<td width="200">&nbsp;</td>
    <% 
	dim i
    i=0
	Do Until rsProducts.EOF 
   %>
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="<%=rsProducts("iPhoto")%>" alt="<%=rsProducts("Remarks")%>"/>
		<br/>
		<p><%=rsProducts("Remarks")%></p>
  	</td>
	<%
		if i>2 then
	%>
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    <% 
			i=0
		else
			i=i+1
		end if
        rsProducts.MoveNext 
    Loop 
	if i<>0 and (4-i)<>0 then
	   %>
	   <td colspan="<%=(4-i)%>">&nbsp;</td>
	   <%
	end if
%>
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    <td colspan="4">       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a></td>		
  </tr>
   <tr>
    <td width="200">&nbsp;</td>
    <td colspan="4" align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

ASKER

Still the same...
2 images are fine, 3 images, little fine, but 4 or more images, are still not aligned.

generated HTML code please?

Also, have you tried changing it someway? Just wanted to know to not try the same ones...

ASKER

Here are the generated HTML codes:

I haven't tried to change it, because I'm searching where do u change the spaces... I couldn't find it...

 
 
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
 
<meta name="Author" content="Oliver Dan A. Arcillo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
 
<meta name="GENERATOR" content="Mozilla/4.7 [en] (Win98; I) [Netscape]">
 
<title>..:: Stiebel Eltron's iPhoto Stock Gallery - Powered by STE IT Dept. ::..</title>
<style TYPE="text/css"> 
<!--
	a
 	{
  		color:#000080;
		font-family:verdana;
		text-decoration:none;
		font-size:12px
	}
	
	
	a:active
 	{
  		color:red;
 
	}
 
	a:hover
 	{
  		color:#FF0000;
		text-decoration:none;
		cursor:crosshair;
	}
		
	table
	{
		font-family:verdana;
	}
	
	td
	{
		font-family:verdana;
		font-size:10e;
	}
 
	.b
	{
		font-color:#0A0EB7;
	}		
 
-->
</STYLE>
 
<!--date-->
<SCRIPT LANGUAGE="JavaScript"> 
 
<!-- Begin
dayName = new Array("", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿", "¿¿¿¿¿¿¿")
monName = new Array("¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿", "¿¿¿¿¿¿", "¿¿¿¿¿¿¿¿¿", "¿¿¿¿¿¿¿")
now = new Date
//  End -->
</script>
 
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
 
 
</head>
 
<body bgproperties="fixed" background="IMG/Background.jpg" onLoad="javascript:startmenu()">
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr>
    <td width="134"><img src="IMG/logo_res.jpg" alt="STIEBEL ELTRON" /></td>
    <td width="620" valign="bottom"><img src="IMG/header-pic.jpg" width="750" height="122" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
    » <img src="IMG/imgfolder.gif" />&nbsp;<a href="javaScript:menu0func()">STE Shower Units - <b><font face="verdana" size="+1"> - DJC Series</font></b></a>
	</td>
 
  </tr>
</table>
<table width="760" border="0" cellspacing="3" cellpadding="1">
  <tr> 
	<td width="200">&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 25 E.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 25E</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 35 E.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 35E</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 45 E.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 45E</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 55 E.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 55E</p>
  	</td>
	
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 60 E.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 60E</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 65 E.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 65E</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 70 E.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 70E</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 75 E.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 75E</p>
  	</td>
	
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 80 E.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 80E</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 85 E.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 85E</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 25.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 25</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 35.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 35</p>
  	</td>
	
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 45.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 45</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 55.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 55</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 60.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 60</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 65.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 65</p>
  	</td>
	
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 70.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 70</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 75.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 75</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 80.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 80</p>
  	</td>
	
    <td align="left" bordercolor="#999999" bgcolor="#FFFFFF">
		<img src="../iPhoto/PROD-IMG/STE Product Picture/Shower Unit/DJC/DJC 85.jpg" alt="DJC Series"/>
		<br/>
		<p align="center"><font face="Tahoma, Geneva, sans-serif" size="1">DJC 85</p>
  	</td>
	
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    
  </tr>
  <tr>
	<td width="200">&nbsp;</td>
    <td colspan="4">       
    <a href = "javascript:history.back()"><font size="0.5e">BACK TO TOP</font></a></td>		
  </tr>
   <tr>
    <td width="200">&nbsp;</td>
    <td colspan="4" align="center" bgcolor="#999999">
    	<a href = "http://10.100.128.214"><font size="0.5e">BACK TO MAIN&nbsp;<img src="IMG/base.gif" alt="BACK TO MAIN PAGE" border="0" /></font></a>
    </td>
  </tr>
  
</table>
</body>
</html>

Open in new window

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

It's ok! Work! :-)

So for my next query, I must open a new thread for it, right? Regarding login issue...

Yes, please.
This way other people can also help :)