Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your 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.

  • 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.


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




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Article title link
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Article title link
#30300
Article title link 12 Years, 3 Months ago Karma: 0
with this SQL string I get article title
SELECT title
FROM #__content
WHERE catid =17

Can I use this title as link to article?
The administrator has disabled public write access.
 
#30310
Re:Article title link 12 Years, 3 Months ago Karma: 760
Hello,

Use the next SQL query:

Code:


SELECT id, title
FROM #__content
WHERE catid =17



Set "Columns settings -> ID" parameter to id value and set "Columns settings -> Hidden" to "Yes".

Set "Columns settings -> ID" parameter to title value and "Columns settings -> Format" parameter to the next value:

Code:


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



Regards,
ARI Soft
The administrator has disabled public write access.
 
#30319
Re:Article title link 12 Years, 3 Months ago Karma: 0
Yes this work for me thanks very much
The administrator has disabled public write access.
 
Go to topPage: 1