ARI Soft - The problem with the link to the article

Home

News

Forum

About Us

Demos

Products

F.A.Q.

Featured Demos

ARI Smart Content demo

ARI Quiz demo

WordPress Quiz plugin

WordPress Lightbox plugin

e-mail: info@ari-soft.com

Shopping Cart

You currently have 0 items in your cart.

Show Cart

Recent Events

23/11/2024 Black Friday 2024

BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

more...
31/12/2023 New Year SALE

We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

more...

2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft.

Welcome, Guest
Please Login or Register. Lost Password?

ARI Soft Forum

Joomla components

ARI Data Tables

The problem with the link to the article

(1 viewing) (1) Guest

Page: 12 3 4

TOPIC: The problem with the link to the article

Forum Tools

#10889

The problem with the link to the article 13 Years, 9 Months ago	Karma: 0
Hi need help necessary to make this article on the material in the format of writing "<a href="index.php?option=com_content&view={$columns:title}"> {$ value} </ a>" How to? Thanks in advance

install

Last Edit: 2011/02/10 21:07 By install.

The administrator has disabled public write access.

#10892

Re:The problem with the link to the article 13 Years, 9 Months ago	Karma: 760
Hello, Could you provide more information, do you use SQL query that get data from "jos_content" table and you want to create links to articles or you mean something another? Regards, ARI Soft

admin

The administrator has disabled public write access.

#10897

Re:The problem with the link to the article 13 Years, 9 Months ago	Karma: 0
Hello, I am using a query SELECT title, transport, way, cost, duration, sectionid, catid, id, alias FROM jos_content output the table of materials articles from Joomla and other fields article and i want that to when you click on the article title takes you to the article itself article title is a reference to the article itself Thanks in advance

install

Last Edit: 2011/02/10 22:35 By install.

The administrator has disabled public write access.

#10898

Re:The problem with the link to the article 13 Years, 9 Months ago Karma: 760

Thank you for the explanation. Use the next format string:

Code:



<a href="index.php?option=com_content&view=article&id={$columns:id}">{$value}</a>

Regards,
ARI Soft

admin

The administrator has disabled public write access.

#10899

Re:The problem with the link to the article 13 Years, 9 Months ago	Karma: 0
Thank you, wise man I want to ask one more question In my case, I take the basic data from jos_content and in the same table you want to paste the article belongs to the category but not id and self title, which is in the table jos_categories

install

Last Edit: 2011/02/10 23:34 By install.

The administrator has disabled public write access.

#10906

Re:The problem with the link to the article 13 Years, 9 Months ago Karma: 760

You can use the following SQL query:

Code:



SELECT 

  C.title, 

  C.transport, 

  C.way, 

  C.cost, 

  C.duration, 

  C.sectionid, 

  CT.title AS cat_title

  C.id, 

  C.alias

FROM 

  #__content C LEFT JOIN #__categories CT

   ON C.catid = CT.id

Regards,
ARI Soft

admin

The administrator has disabled public write access.

Page: 12 3 4

Useful Links