Comparing multiple field from mysql database and output the results
$30-250 USD
Paid on delivery
I have Four table in mysql:
Table1 : Fieldgroup
______________________
|-groupid-|--name-----|
|_________|___________|
|-1-------|-Ram-------|
|-3-------|-Processor-|
Table2 : Fields
______________________________________________________
|-fieldid-| name-------------|-Title--------|-groupid-|
|_________|__________________|______________|_________|
|-1-------|-jr_processcor----|-Processor----|---3-----|
|-2-------|-jr_process_speed-|-Proces Speed-|---3-----|
|-3-------|-jr_proces_manufa-|-Proces Manuf-|---3-----|
|-4-------|-jr_ram_speed-----|-Proces speed-|---1-----|
|-5-------|-jr_installed_ram-|-Instaled ram-|---1-----|
Table3 : field_content
_____________________________________________________________________
|-contentid-|-jr_proces_manufa |-jr_process_speed-|-jr_installed_ram-|
---------------------------------------------------------------------
|----10-----|-intel------------|----2ghz----------|-4gb--------------|
|----11-----|-amd--------------|----1.8ghz--------|-3gb--------------|
----------------------------------------------------------------------
Table4 : content
________________________
|--id--|-----tilte-------|
-----------------------
|--10--|-Dell xps m1330--|
|--11--|-sony vaio vgn---|
------------------------
I have a form on my website that retrieve contentid submited by user.
What i want is to retrieve informations from all of those table and output the results in a features comparison charts.
Right now i am able to retrieve the content from table3 and table4 with a mysql select and an array.
But the output i would like to achieve is more something like this:
-----------------------------------------------------
Title-----------|-Sony vaio vgn---|-Dell XPS M1330--|
-----------------------------------------------------
----------------|-Processor(group)|-Processor(group)|
-----------------------------------------------------
Proces manu-----|-amd-------------|-intel-----------|
Proces speed----|-1.8-------------|-2ghz------------|
-----------------------------------------------------
----------------|-Ram (Group Name)| Ram (Group Name)|
-----------------------------------------------------
Installed ram---|-3gb-------------|--4ghz-----------|
-----------------------------------------------------
Thank you
Project ID: #425067
About the project
14 freelancers are bidding on average $60 for this job
hey let me know ti get started on this project, you will be smily with in a day. regards MIA