Jamroom Logo Jamroom 5 Core
is now Open Source!
User Support Forum Archive (Read Only)
Jamroom Developers:
pulling songs/Song Images
jamesd116



Joined: 05 Jun 2006
Posts: 1559
Location: Rochester Pa

Posted: 04/23/09 22:50 
    On my form field I am trying to pull songs currently inthe system for ringtone creation so how would I pull up a drop down of the songs already in the system


    I want to pull up a the images saved in the account already how can I do this I already know how to add an image


Code
jmInput($language['rtCreator'][101],'ringtone_rtimage','file',$_rep['ringtone_rtimage']);


Can someone tell me what to use to do these 2 things Thanks


_________________
One day the court system will learn that a childs mother is not the only option...... Question is will it be too late by that time...
Back to top
jamesd116



Joined: 05 Jun 2006
Posts: 1559
Location: Rochester Pa

Posted: 04/26/09 13:41 
Can anyone tell me how I Can pull the list of songs in the artist acct
Im using Nova 4.0.10


_________________
One day the court system will learn that a childs mother is not the only option...... Question is will it be too late by that time...
Back to top
Brian
Jamroom Team


Joined: 09 Jul 2003
Posts: 37583
Location: Seattle, WA

Posted: 04/26/09 16:46 
When you say "pull a list of songs", do you mean retrieve the songs from the database for the user's profile?

Thanks!

- Brian


_________________
Make sure and check out:
* The Jamroom FAQ
* The Jamroom Documentation
Back to top
jamesd116



Joined: 05 Jun 2006
Posts: 1559
Location: Rochester Pa

Posted: 04/26/09 17:53 

bigguy:
When you say "pull a list of songs", do you mean retrieve the songs from the database for the user's profile?

Thanks!

- Brian

Yes thats what I mean sorry for any confusion
along with the ability to pull the users iumages also


_________________
One day the court system will learn that a childs mother is not the only option...... Question is will it be too late by that time...
Back to top
Brian
Jamroom Team


Joined: 09 Jul 2003
Posts: 37583
Location: Seattle, WA

Posted: 04/26/09 18:02 
You will need to select that info from the database tables:

jamroom_song_info

jamroom_user

Hope this helps!

- Brian


_________________
Make sure and check out:
* The Jamroom FAQ
* The Jamroom Documentation
Back to top
jamesd116



Joined: 05 Jun 2006
Posts: 1559
Location: Rochester Pa

Posted: 04/26/09 18:41 
which function would i use from the list of JR funtions


_________________
One day the court system will learn that a childs mother is not the only option...... Question is will it be too late by that time...
Back to top
Brian
Jamroom Team


Joined: 09 Jul 2003
Posts: 37583
Location: Seattle, WA

Posted: 04/26/09 18:53 

jamesd116:
which function would i use from the list of JR funtions


You wouldn't - you would need to create a query - i.e.


Code

$req - "SELECT *
          FROM {$jamroom_db['song_info']}
         WHERE band_id = '{$_user['user_band_id']}'";
$_rt = dbQuery($req,'NUMERIC');


$_rt will contain an array of songs.

Hope this helps!

- Brian


_________________
Make sure and check out:
* The Jamroom FAQ
* The Jamroom Documentation
Back to top
Display posts from previous:   
User Support Forum Archive (Read Only)
Jamroom Developers

 
Solutions
• Social Media Platform
• Social Networking Software
• Musician Website Manager
• Community Builder
Products
• Jamroom Core
• Jamroom Addons
• Jamroom Modules
• Jamroom Marketplace
Support
• Support Forum
• Documentation
• Support Center
• Contact Support
Community
• Community Forum
• Member Sites
• Developers
Company
• About Us
• Contact Us
• Privacy Policy
©2003 - 2010 Talldude Networks, LLC.