I have a database table filled with interesting data. On my webpage I would like to let a user pick two rows in the table and compare the data to see how it differs. Picking what rows to compare would be done by two dropdown lists.
The data in the table is structured so that in a single row: the 10 first fields are descriptive of the rowdata, next ten are "one set of values (totals)" and next ten "another set of values (a breakdown of the totals)" and so on and i would like the user to be able to switch between these "sets" in the rows they already choose in the dropdown.
what I have done so far is constructing a php page with userlogin (thanks to angry-frog.com) designed the overall look of the page and made a semifunctional dropdown that displays the approriate rows from the table depending on who the user is.
I dove into this headfirst trying to code it but bumped into several hurdles and recently started a thread about one of them (http://www.daniweb.com/web-development/php/threads/426093/dropdown-to-output-corresponding-row-values-but-not-all)
but now I'm thinking of taking a step back and getting input on what the best approach is regarding getting this to work. I have limited knowlage in php and mysql (wich i just started learning) but I'm willing to look into any language that would make this a smooth ride :)
Humble for any and all suggestions :)