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
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
Webmaster, SEO Analyst, Social Media Analyst
www.gabrielcoder.com
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:
Hope this helps.
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/
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] Link to an other table
By gcod - July 26, 2010
I should have known that.
Thanks!
Thanks!
---------------------------------------------------
Webmaster, SEO Analyst, Social Media Analyst
www.gabrielcoder.com
Webmaster, SEO Analyst, Social Media Analyst
www.gabrielcoder.com