Tricky Image Question

James0816

First off, I have a table in my database with three fields for images (right, front, left). On my page, I have a table configured as (2 rows, 3 columns). The first row the columns are merged to form of course on single cell. The bottom three are then filled with the values of right, front, left. When I click on the item in my menu, the table gets populated and the top cell is filled with the front image. What I am trying to do is configure the right and left to be links and change the image above for the respective image (i.e. click on right and the right side image shows in the cell above. Same for front and left).

Is this possible or will I need to create a seperate table to house the images?

Thx,
Jim

onion2k

Have I missed something? This sounds simple.

In your database store the filenames of the images as front, right and left, and have an id to tell which thing they're an image of.

Then have your menu links going to the id of the thing.. say 1. Then the 3 images across the bottom would be links to, for example,

index.php?id=1&view=r
index.php?id=1&view=f
index.php?id=1&view=l

If your index page doesn't have a view defined, that is to say $view is blank, then you know someone has clicked the menu link and just default to the front view.

James0816

zowy!.....kinda lost me there fer a bit. I am new to PHP and MySQL so you will have to bear with me. The bottom three items are just text links. The only picture shown will actually be in the cell above. Don't recon you have or know where to find a sample coding snippet for me to look over to try and understand that concept would you?

thx

James0816

Here's the coding for the table I am using. I know it's probably bad since I'm not versed in PHP so bare with me.....I'm using Adobe GoLive as well to help me until I learn it well enough to write code on my own.

You'll see where the image is display up top in the merged cell and that the links are to be located in the next row. If I click on a link, then I want the picture to change to the next value (in this case it will the field from my database of picimg2). So if I click on the link for RIGHT, PicImage will change to picimg2.

My database has three fields for image locations (picimg, picimg2, picimg3).

Hope this helps a little better.

		<table width="473" border="0" cellspacing="0" cellpadding="0" cool gridx="6" gridy="6" height="383" showgridx showgridy usegridx usegridy>
			<tr height="382">
				<td width="472" height="382" valign="top" align="left" xpos="0">
					<table width="471" border="3" cellspacing="0" cellpadding="0" height="375">
						<tr>
							<td>
								<table width="462" border="0" cellspacing="0" cellpadding="0" height="364">
									<tr height="346">
										<td colspan="3" width="462" height="346"><img src='<?php echo mapPath($ItemPics->Value("picimg"), "./")?>' alt="" name="PicImage" height="354" width="462" border="0"></td>
									</tr>
									<tr height="18">
										<td width="154" height="18">
											<div align="center">
												<font size="1">Right</font></div>
										</td>
										<td width="154" height="18">
											<div align="center">
												<font size="-1">Center</font></div>
										</td>
										<td width="154" height="18">
											<div align="center">
												<font size="1">Left</font></div>
										</td>
									</tr>
								</table>
							</td>
						</tr>
					</table>
				</td>
				<td width="1" height="382"><spacer type="block" width="1" height="382"></td>
			</tr>
			<tr height="1" cntrlrow>
				<td width="472" height="1"><spacer type="block" width="472" height="1"></td>
				<td width="1" height="1"></td>
			</tr>
		</table>