This Red/White -:- XL ~ 168;Red/White -:- One Size ~ 0 into a select list

[MaxBodine]

I am new to this. Using dreamweaver, php and mySQL. I will receive a xls file to upload into mySQL. One of the fields contains the Color, size and qty. I am not sure how to take these and populate a select list? Here is an example of 4 products and the data I get for each. It looks like I should be seperating them after each simicolon. I was reading split should not be used. Just lost. Thanks for any help, I attached a file to look at.

 

Black -:- One Size ~ 0;Black -:- XL ~ 636;Red -:- One Size ~ 0;Red -:- XL ~ 232;White -:- XL ~ 0;White -:- One Size ~ 0

 

Red/White -:- XL ~ 168;Red/White -:- One Size ~ 0

 

Red/White -:- XL ~ 192

 

Light Pink -:- XL ~ 0;Light Pink -:- S/M ~ 0;Light Pink -:- M/L ~ 0;Black -:- S/M ~ 0;Black -:- M/L ~ 0;Black -:- XL ~ 0;White -:- S/M ~ 12;White -:- M/L ~ 0;White -:- XL ~ 0;Red -:- S/M ~ 20;Red -:- M/L ~ 0;Red -:- XL ~ 0

 

 

[attachment deleted by admin]