ARI Soft - Pre Sales Question - iTunes-like tables?

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

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

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

Pre Sales Question - iTunes-like tables?

(1 viewing) (1) Guest

Page: 1

TOPIC: Pre Sales Question - iTunes-like tables?

Forum Tools

#8107

Pre Sales Question - iTunes-like tables? 13 Years, 6 Months ago

Karma: 0

I'd like to verify the functionality I need before purchasing. I have in mind an iTunes-like site where the registered user could list their songs. The main data table to be shown would list songs and the associated artists. The issue is that there are at least three related tables, the song table, the artist table (which the song table refers to) and the user's library (which contains the references to the songs they own). So the table I'm planning on uses the user's library table to get the song ids and the song table to get the song title and the artist id and the artist table to get the artist's name.

Can I easily create the user's library table that shows this information?

Peter

pheitman

The administrator has disabled public write access.

#8114

Re:Pre Sales Question - iTunes-like tables? 13 Years, 6 Months ago Karma: 748

Hello,

We suppose JOIN operator can be used in your case that get all necessary data. SQL query will look like:

Code:



SELECT

  U.user_name,

  S.song_name,

  A.artist_name

FROM

  user_table U INNER JOIN song_table S

    ON U.song_id = S.song_id

  INNER JOIN artist_table A

    ON S.artist_id = A.artist_id

WHERE

  U.user_id = {$UserId}

Regards,
ARI Soft

admin