Re: [Dave] Multiples field from on table populate one field from an othe table

Sat, 20 Sep 2008 12:16:44 -0700

Hi Dave
I am using the same function to display more that one field element from related item, How do I add a link to this related item?

Cheers
Simon

Re: [Donna] Relevant infromation with links

Sat, 20 Sep 2008 12:14:30 -0700

Hi Donna

ok the link is working perfect, maybe I didnt explain properly previousley, sorry, This issue is the when I click the related news piece, the echo is seeing it from current item, so item 3 and its following this value through when linking to the related news so isnt displaying the correct related news piece once clicked. Its displating the value of the prvious item "3".

I need to extract the value from the related news so it can link to it, I am using a SQL query that looks like this:

SELECT CONCAT_WS(" ", related_title, summary_short), CONCAT_WS(" ", related_title, summary_short) FROM cms_news

Do i need the num of the related news piece

Re: [Donna] Relevant infromation with links

Fri, 19 Sep 2008 03:47:55 -0700

Hey Donna.

Thanks for the reply.

I have implemented what you suggested, which seems to work to a degree, apart from the related item is referencing the num value of the page its beingdisplayed on and not the value of itself.

Here is the code now:

So the record 'number' is referencing the page it resides and not the item itself.

Thanks
Simon

Relevant infromation with links

Thu, 18 Sep 2008 06:58:51 -0700

Hi

I am using the List value to select relevant information on each content item, I have the following that pulls the information from the database:

SELECT CONCAT_WS(" ", related_title, summary_short), CONCAT_WS(" ", related_title, summary_short) FROM cms_news

and the PHP value on the actual page that looks like this:

I cant seem to get the related new item to link through to that item,

Any suggestions
Cheers
Simon

Re: [Dave] Get options from MySQL query

Mon, 15 Sep 2008 11:19:40 -0700

Cheers Dave I have solved the issue from a previous thread using:

SELECT CONCAT_WS(" ", related_title, summary), CONCAT_WS(" ", related_title, summary) FROM cms_news

to pull different information from the database.

Regards
Simon

Get options from MySQL query

Mon, 15 Sep 2008 07:35:45 -0700

Hi I am wanting display more than one item from a specific table using the "list" option, I have selected the "Get options from MySQL query" and have enter this into the form filed "SELECT summary, title, date FROM cms_news". The results are only bringing back the first entry "summary", what else do I need to change to show all resluts "summary, title and date"
Thanks
Simon