Please help me w/ this audio DB

[madcat]

Hi:

I'm trying to build a database of audio files (.mp3 & .wav) for a new production studio. Since they're new, they don't have an invoice # for their samples. In my table, I want one row to have the following elements: Sample#, Date Input, Listen .mp3, Listen .wav, and Purchase (Check, money order, PayPal). This line would be output in the webpage as one line...

1. Does PayPal offer a way to link the for sale item with some sort of invoice/reference #?

2. Since they don't have invoice #'s, should I just make up a corresponding reference # and have people type it in when the order? Should I let MySQL increment and simply use that as the invoice/reference # for the sample?

Do you see what I mean? And how would you do this type of thing? There won't be a merchant account at this point, so these payment methods are the only ones available.

Thanks for any suggestions, I do need them,

M

[paulnaj]

Hi madcat,

Not sure about the Pay Pal stuff ... I would have thought that they would give you a pre-designed form that you need to embed in your HTML and maybe a field for some details that you'll need so that you can identify the sale. Check with them.

You should have a primary key for this table anyway, so use the auto_increment as you suggested. But if you're likely to sell audio files to more than one client (per file) then I would put 'payment' data in a separate table to the actual audio files.

Hope that helps.

Paul.

[madcat]

Thanks,

...so the payment data including invoice/ref#, price & primary ID? Would I need too much more than that...?

[paulnaj]

Maybe the date?