Join

  • Resolved legalfiction

    (@legalfiction)


    13 years, 6 months ago

    Hi Tobias,
    This seems to be a excellent plug-in. I am trying to built a race result website, it will have a couple of tables like “Driver” “Year Born” “Car”. Is it possible to use data from these last two tables in the table “driver”. By using a join or so?

    If not, is there a workaround?

    Thanks!
    Aldo

    http://ww.wp.xz.cn/extend/plugins/tablepress/

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    13 years, 6 months ago

    Hi,

    no, sorry, this is not possible. TablePress is not intended to be a database-like system. For that, I suggest that you investigate an approach that directly uses a database.

    Regards,
    Tobias

    Thread Starter legalfiction

    (@legalfiction)

    13 years, 6 months ago

    Hi Tobias,
    Ok i will have a look.

    Aldo

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    13 years, 6 months ago

    Hi,

    ok. Sorry that I couldn’t help with a solution here.

    Best wishes,
    Tobias

    Thread Starter legalfiction

    (@legalfiction)

    13 years, 6 months ago

    No problem Tobias, i am thinking of having the source in Google spreadsheet, i can make the joins over there. Your poorpigs frontpage is exactly what i look for, now i will have a close look how make a joint field like your team-roster page.

    Should all data be in the same table or is it possible to make joins on the frontpage

    Thread Starter legalfiction

    (@legalfiction)

    13 years, 6 months ago

    [double post]

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    13 years, 6 months ago

    Hi,

    the poorpigs.de website doesn’t use any joins either, as this is not possible with TablePress at all. All of the tables that you see there are separate tables.

    Regards,
    Tobias

    Thread Starter legalfiction

    (@legalfiction)

    13 years, 6 months ago

    Hi Tobias, Sorry, what i ment was i try to find out how to make a link on a name so it can give (call) a detail page. Like on your website.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    13 years, 6 months ago

    Hi,

    those are just plain HTML link, inserted via the “Insert Link” button. The rest is then some extra functionality, ie. an AJAX call is made to script that fetches extra data. This is not done in TablePress directly, though.

    Regards,
    Tobias

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘Join’ is closed to new replies.