ARI Soft - Populating records into complex table

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 Smart Content

Populating records into complex table

(1 viewing) (1) Guest

Page: 12 3 4 5

TOPIC: Populating records into complex table

Forum Tools

#30918

Populating records into complex table 12 Years, 3 Months ago	Karma: 0
These are awesome tools. But I cannot determine how to populate table cells with database field values. The table layout is moderately complex, and it will contain only about a dozen rows/records. No paging is necessary. I presume I will use {arisqltable} to iterate the database records. But, then, how do I populate the table rows with the field values? Thanks, David.

dwoosley

Reasonably nice guy.

The administrator has disabled public write access.

#30922

Re:Populating records into complex table 12 Years, 3 Months ago Karma: 760

Hello,

If you want to show data from a database, use "ARI SQL Table" plugin. A sample code:

Code:



{arisqltable}

  {arisqltablequery}

    SELECT id,title

    FROM #__content

  {/arisqltablequery}

{/arisqltable}

Regards,
ARI Soft

admin

The administrator has disabled public write access.

#30929

Re:Populating records into complex table 12 Years, 3 Months ago Karma: 0

I thought using "ARI SQL Table" is what I mentioned in my second paragraph.

I envision something that works like this:

Code:



{arisqltable}

    {arisqltablequery}

        SELECT * FROM myTable 

    {/arisqltablequery}

    <tr>

        <td>{AAA}</td>

        <td>{BBB}</td>

        <td><img src="path/{CCC}.jpg"/></td>

    </tr>

    <tr>

        <td colspan="3">

             {DDD}

        </td>

    </tr>

{/arisqltable}

... and how to obtain the database field values for AAA, BBB, CCC, and DDD is what I don't understand. And, notice that the record requires two rows.

David.

dwoosley

Reasonably nice guy.

Last Edit: 2012/08/26 22:27 By dwoosley.

The administrator has disabled public write access.

#30938

Re:Populating records into complex table 12 Years, 3 Months ago	Karma: 760
The extension doesn't support ability to show data from one database record on several row in HTML table, but it is possible to format values with help of {arisqltablecolumn} tag. Regards, ARI Soft

admin

The administrator has disabled public write access.

#30963

Re:Populating records into complex table 12 Years, 3 Months ago	Karma: 0
Which combination of tools can I use to create the list of locations shown on this page: http://www.gofarmersbank.com/service_branch_list.go Thanks.

dwoosley

Reasonably nice guy.

The administrator has disabled public write access.

#30964

Re:Populating records into complex table 12 Years, 3 Months ago	Karma: 760
Plugins from "ARI Smart Content" package can't show data from a database in format like on provided page. Regards, ARI Soft

admin

The administrator has disabled public write access.

Page: 12 3 4 5

Useful Links