Help access SQL Data using Hashes

[Patrick Shoaf]

I am retrieving the following data from MySQL.  I need to access the data 
via some sort of Hash or Array.  I need to take this data and create a web 
page using some some of the data to create Java Script Arrays, while the 
rest is simply display on the web page.  Any all help is appreciated...

DATA:
Itm1,Red,S,1.00
Itm1,Red,M,1.00
Itm1,Red,L,1.50
Itm1,Grn,S,1.00
Itm1,Grn,M,1.00
Itm1,Grn,L,1.25
Itm1,Grn,XL,1.50
Itm2,Red,S,2.00
Itm2,Red,M,2.00
Itm2,Red,L,2.50
Itm2,Brn,S,2.00
Itm2,Brn,M,2.00
Itm2,Brn,L,2.25
Itm2,Brn,XL,2.50
I would need from the above sample the following outputs:

Itm1 - (Color Drop Down) - (Size Drop Down) - Price
I have Java scripts that auto change Size Drop Down and Price using Java 
Script Arrays.

I need in perl a way to create a hash/array/etc so that I can access get
 - All Unique colors for Itm1 individually through a loop (for color drop 
down)
 - All Sizes for Itm1,Color1 individually for a Java Script Array for each 
item
 - All Prices for Itm1,Color1 individually for a Java Script Array for 
each item

Patrick Shoaf
[EMAIL PROTECTED]
        
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]