[SOLVED] php display grid
Posted: Thu Feb 17, 2005 7:01 am
Hi all;
I have a simple question which has to do with displaying information in a grid:
I have two relational tables which needs to instead of displaying the coulmns id code it needs to display the corresponding columns info.
For instance this is how it looks:
id | category | name
---------------------
1 | 1 | first
2 | 2 | second
3 | 3 | third
4 | 4 | fourth
and this is how i need it to look:
id | category | name
---------------------
1 | type a | first
2 | type b | second
3 | type c | third
4 | type d | fourth
Hopefully you understand what I mean, as I can't seem to find the correct query syntax for this particlur problem.
THanks all
I have a simple question which has to do with displaying information in a grid:
I have two relational tables which needs to instead of displaying the coulmns id code it needs to display the corresponding columns info.
For instance this is how it looks:
id | category | name
---------------------
1 | 1 | first
2 | 2 | second
3 | 3 | third
4 | 4 | fourth
and this is how i need it to look:
id | category | name
---------------------
1 | type a | first
2 | type b | second
3 | type c | third
4 | type d | fourth
Hopefully you understand what I mean, as I can't seem to find the correct query syntax for this particlur problem.
THanks all