query to mysql with columns option
Posted: Tue Sep 07, 2010 5:04 pm
Hi guys. I'm trying to make a query toi mysql dbase im php, but withou success. My table have aroun 20 columns, i want to make a query with rows and columns option, eg:
table1:
col1-----col2-----col3-----col4-----col5-----col6
r1a------r1b------r1c-------r1d------r1e------r1f
r2a------r2b------r2c-------r2d------r2e------r2f
r3a------r3b------r3c-------r3d------r3e------r3f
r4a------r4b------r4c-------r4d------r4e------r4f
r5a------r5b------r5c-------r5d------r5e------r5f
r6a------r6b------r6c-------r6d------r6e------r6f
r7a------r7b------r7c-------r7d------r7e------r7f
and now, with 3 combo, (one for the columns and 2 for the rows in the 2 first columns), i want to choose the data to retrieve... how can I get this??
tku
table1:
col1-----col2-----col3-----col4-----col5-----col6
r1a------r1b------r1c-------r1d------r1e------r1f
r2a------r2b------r2c-------r2d------r2e------r2f
r3a------r3b------r3c-------r3d------r3e------r3f
r4a------r4b------r4c-------r4d------r4e------r4f
r5a------r5b------r5c-------r5d------r5e------r5f
r6a------r6b------r6c-------r6d------r6e------r6f
r7a------r7b------r7c-------r7d------r7e------r7f
and now, with 3 combo, (one for the columns and 2 for the rows in the 2 first columns), i want to choose the data to retrieve... how can I get this??
tku