Gossamer Forum
Home : Products : Gossamer Links : Discussions :

how to display the content of an other table ?

Quote Reply
how to display the content of an other table ?
Hi

I use LSQL as a news manager

I have add a "partners" table

ID
Name
Description
Site_URL

Then In my links table I have add a news column : "ID_partners"

What I would like to to is to "attach" these 2 tables

then Wen I add A news I can say it has been written with such or such partners

then In my templates (link.htm category.htm and detailed.html) I would like to display the partner's name, a link tyo his website...)


Txs

FMP
Quote Reply
Re: [fmp] how to display the content of an other table ? In reply to
I guess you have to add def for your custom table into the def files so linksql knows that there is a table there.
Quote Reply
Re: [long327] how to display the content of an other table ? In reply to
Hi


txs for your answer... do you (or does anyone else) have a step by step guide on how to to it?

Txs
FMP
Quote Reply
Re: [fmp] how to display the content of an other table ? In reply to
It's a bit too complicated for a message. The best thing is to have someone write a custom plugin, that will set up the table, the def file, indexes and a foreign key relation.

To add a table you need to both create the table, and then a .def file. You can use a copy of any other .def file, as long as you immediately trick the system into resyncing it. A custom plugin is much easier, unless you want to hack around links and unix.


PUGDOG´┐Ż Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.