Link to an other table

3 posts by 2 authors in: Forums > CMS Builder
Last Post: July 26, 2010   (RSS)

By gcod - July 22, 2010

Hi,

In know my title is shitty but I can't find a good one. (change it if needed).

Here is my problem.

I have a page with a product (a wine) that has a producer which is listed in the backend from an other table (producer table).

On this wine page I'm showing the wine AND I'm listing all the other wines that has the same producer.

The question is simple: I'd like to link back the producer name, in the list of wine with the same producer, to the producer page.

I attached the code of the page.

Thanks and let me know if you have questions.

GaB
---------------------------------------------------
Webmaster, SEO Analyst, Social Media Analyst
www.gabrielcoder.com
Attachments:

vin.php 6K

Re: [gcod] Link to an other table

By Jason - July 23, 2010

Hi,

How to go about doing this depends on a couple of different things:
-What is the name of your producer page
-What is the field in your producer table that stores their name?

After that it's just a matter of putting in the link.
For example, it may look like this:

<td><a href="producer.php?name=<?php echo $record['producer'];?>"><?php echo $record['producer'] ?></a></td>

Hope this helps.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/