Comparing multiple field from mysql database and output the results

Cerrado Publicado Apr 27, 2009 Pagado a la entrega
Cerrado Pagado a la entrega

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

PHP

Nº del proyecto: #425067

Sobre el proyecto

14 propuestas Proyecto remoto Activo Jul 26, 2009

14 freelancers están ofertando un promedio de $60 por este trabajo

lightcresent

Yes can be done... Thanks

$50 USD en 0 días
(520 comentarios)
9.2
soner

I can offer my high quality programming services to you. Please contact if interested.

$45 USD en 0 días
(134 comentarios)
8.8
VALUEONWEB

We are ready to do this. Please provide details

$30 USD en 0 días
(212 comentarios)
7.9
SunFlowerBiz

Hi, please view PM for our portfolio. Regards,

$50 USD en 2 días
(102 comentarios)
7.7
kraynyukov

The project is clear. Get it done within 2 hours. Thanks.

$30 USD en 0 días
(14 comentarios)
5.0
NashTrump

Hi, I am an expert VBA, Excel, Database, Mysql, Website scraper, Data extraction and Automation expert.I have over 11 years experience in the above categories and would like very much to have the opportunity to work Más

$120 USD en 0 días
(1 comentario)
3.2
CodrFrank

Hello, I have worked with PHP/MYSQL and I can get this done quickly.

$30 USD en 0 días
(3 comentarios)
3.0
vvaheed

Hi I can do this quickly for you.

$30 USD en 1 día
(0 comentarios)
0.0
designwork

by today i can provide you a solution.promise....

$30 USD en 0 días
(0 comentarios)
0.0
donparrivera

I am interested..

$50 USD en 1 día
(0 comentarios)
0.0
eet072423

Sir , i can do this project .Please see PM

$45 USD en 1 día
(0 comentarios)
0.0
fgctechlution

I can do this for you. Regard!

$30 USD en 1 día
(0 comentarios)
0.0
mia8aim

hey let me know ti get started on this project, you will be smily with in a day. regards MIA

$44 USD en 1 día
(0 comentarios)
0.0