Page 1 of 1

Create multidimensional array from sql query and display in

Posted: Tue May 18, 2010 2:00 pm
by mazola
Good day
I am fairly new to php and have a problem.
I have two tables in mysql, that is dividendparams and dividendhistorydetails. dividendparams has fields paramid,paramname while dividendhistorydetails has fields detailsid,paramid,year,dividenditem.

I would like to query data from both tables and display as follows;
Year1 Year2 Year3 Year4
Paramname1 Dividenditem1 Dividenditem2 Dividenditem3 Dividenditem4
Paramname2 Dividenditem5 Dividenditem6 Dividenditem7 Dividenditem8
Paramname3 Dividenditem9 Dividenditem10 Dividenditem11 Dividenditem12
Paramname4 Dividenditem13 Dividenditem14 Dividenditem15 Dividenditem16
Paramname5 Dividenditem17 Dividenditem18 Dividenditem19 Dividenditem20

the number of paramname and year can increase, thereby increasing the dividenditem too.

Any help on this will be appreciated.
Thank you

Re: Create multidimensional array from sql query and display

Posted: Tue May 18, 2010 2:21 pm
by mikosiko
What have you tried so far?

Do you have errors in your code and you need help on those?