Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SQL/Database Question - For Music Store


islanddog

Recommended Posts

Would like to create a store that sells Music CDs. The problem is that I want to be able to add the individual song information to a single product so that you can do a search by the artist or song title.

 

Has anyone ran into anything similiar to this and resolved it??

 

Thanks

ROdney

Link to comment
Share on other sites

In the amdin , your product has three fields:

 

Manufacturer - could be the label / record company

Name - could be the artist's name

Model - could be the album title.

 

Now your customers can search by album title using the basic search.

 

Off the wall - would give Michael's ALbum

 

But to search for a track, e.g., Rock with You they need to use Advanced search. Since your track listings can be in the products description.

The advance search looks in the products description.

 

What you need to do is link the search box to the advance search, rather than a basic search. I think this would work!

 

PM if you have any more questions (as I'm a big music fan )

 

Today's Featured Artist is: Courtney Pine - New Jazz for everyone

Special Effects / 3d + Flash

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...