mp3 and url problem

Report · Mar 10, 2009

Hi everyone!

I have searched here on this forum, but I haven´t found a solutions for my two problems or
I haven˝t searched properly.

My first problem is with mp3 files. I have created a mysql database for my mp3 files
like this: id (int), date (date), content (varchar), file (varchar) and now my problem is
how to set up the page so the file loads on the page and the user
can be listend to it.

My second problem is with url. I have created a image gallery for my banners on the site.
My SQL table is setup like this: id (int), client (varchar), banner (varchar), link (varchar), startingdate (date) and
endingdate (date). I would like to setup is like this: if an user clicks on the banner it will take him to the
clients site.

I thank everyone in advance for any tips I can get to solve my two problems.

Report · Mar 10, 2009

Heya,

Pretty much same solution for both. Create a recordset for table then filter id from URL parameter so when user visits page.php?id=2 they have content from DB table with id 2 displayed on page. Place content from filtered recordset onto page by dragging from bindings tab.

Basically it's all about creating recordsets and placing the bindings onto the page.

Hope that helps!

Report · Mar 10, 2009

quote:

Originally posted by: DWFAQ.info
Heya,

Pretty much same solution for both. Create a recordset for table then filter id from URL parameter so when user visits page.php?id=2 they have content from DB table with id 2 displayed on page. Place content from filtered recordset onto page by dragging from bindings tab.

Basically it's all about creating recordsets and placing the bindings onto the page.

Hope that helps!

I tried, but I couldn´t get it right. I am totally new to this kind of developing and could you please guide me to get this right.
How should it look like ni the Recordset window.
Filter : _________(I wrote ID) = (or should I choose something else)
Url Parameter - _________________(I wrote File)

How do I then connect the folder audio where my audio files are placed.

Thank for your help if you decide to help me.

Report · Mar 11, 2009

Heya,

You wrote:
"How should it look like in the Recordset window.
Filter : _________(I wrote ID) = (or should I choose something else)
Url Parameter - _________________(I wrote File)"

It should look like this:

Filter:__________ id
(id lowercase is the primary key auto increment integer for your item you create a DB table field for as described in your original post.)

=

URL Parameter:_________ id (or whatever name you want)

Then place dynamic info into page by dragging table field from Binding Window onto page as described in earlier post. Then when you visit your_page.php?id=3 you will see table info placed from binding tab where id = 3. 4 for 4, 5 for 5, etc. If you put something else like File in URL parameter filter then visiting your_page.php?File=3 will show info from table placed in page from binding tab where primary key id = 3 etc.

That should be more than enough information to get you on your way!

Report · Mar 11, 2009

quote:

Originally posted by: DWFAQ.info
Heya,

You wrote:
"How should it look like in the Recordset window.
Filter : _________(I wrote ID) = (or should I choose something else)
Url Parameter - _________________(I wrote File)"

It should look like this:

Filter:__________ id
(id lowercase is the primary key auto increment integer for your item you create a DB table field for as described in your original post.)

=

URL Parameter:_________ id (or whatever name you want)

Then place dynamic info into page by dragging table field from Binding Window onto page as described in earlier post. Then when you visit your_page.php?id=3 you will see table info placed from binding tab where id = 3. 4 for 4, 5 for 5, etc. If you put something else like File in URL parameter filter then visiting your_page.php?File=3 will show info from table placed in page from binding tab where primary key id = 3 etc.

That should be more than enough information to get you on your way!

Thank you DWFAQ.info for the HELP! it´s working now.

Report · Mar 17, 2009

DWFAQ.info I need a little more help.

I have worked out with the mp3 files, but I can´t figure out with the banners. I have done the same thing, but when the your clicks on the banner it opens a blank page. How do I set up the linked page that is shows the site of the customer when the user clicks it.

I thank you again in advance.

Report · Mar 18, 2009

Heya,

For banners it's pretty much the same concept as previously described; create a recordset then link bindings to the page. So link to banner should look something like the following with bindings where indicated:

<a href="banner_url_binding"><img src="banner_image_binding" alt="banner" /></a>

Hope that helps!