Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


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

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


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?

Links to articles in table
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Links to articles in table
#12463
Links to articles in table 13 Years, 8 Months ago Karma: 0
I would like to generate a table of articles in the Joomla Database and to have the article titles displayed and work as links so that a user can open the articles.

I have my query designed but don't see a way to do this.

Is this possible using one of these components?

Thank you,
Sid.
The administrator has disabled public write access.
 
#12483
Re:Links to articles in table 13 Years, 8 Months ago Karma: 760
Hello,

You can use the next code:

Code:


{arisqltable}     
  {arisqltablecolumns}       
    {arisqltablecolumn id="title"}         
      {coltemplate}<a href="index.php?option=com_content&amp;view=article&amp;id={$id}">{$title}</a>{/coltemplate}
    {/arisqltablecolumn}
  {/arisqltablecolumns}
  {arisqltablequery}SELECT id,title  FROM #__content{/arisqltablequery} 
{/arisqltable}



Regards,
ARI Soft
The administrator has disabled public write access.
 
#12486
Re:Links to articles in table 13 Years, 8 Months ago Karma: 0
That looks excellent!

In general can any HTML code be incldued in the coltemplate?

Once again, a very cool component!
Sid.
The administrator has disabled public write access.
 
#12487
Re:Links to articles in table 13 Years, 8 Months ago Karma: 760
Yes, you can use any HTML code.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#12488
Re:Links to articles in table 13 Years, 8 Months ago Karma: 0
Thank you I will proceed as you have suggested.

Thank you
Sid.
The administrator has disabled public write access.
 
Go to topPage: 1