hello
I thinking about wht is the best create many or just litle field in table a database :
ex:
I want create this :
----------------------------------------------------------------------------------------------------------------------------
| ID_U | firsname | lastName | email | biograp | comment | status_res | activatio | aim | jabber |
----------------------------------------------------------------------------------------------------------------------------
| 1 | fekke1 | laldjajdd | e@d.dcom | ndndn | blalalalal | a,ama | ,,,,,,,,, |....... | kakdd
| 2 | dekj4 | jdhkhjdh | d@d.dcom |kskksk |blalalalal | a,amnka |,,,,,,,,,,, | ,,,,,,,,| ksjdhd
|------------------------------------------------------------------------------------------------------------------------------
you can look in above I create 10 field in my table ,
Now I thingking only will make 4 field look ex below :
--------------------------------------------------------
| ID_MG | ID_UMG | KEY_MG | VALUE_KEY |
--------------------------------------------------------
| 1 | 1 | firsname | blalalalal |
| 2 | 1 | lastName | blalalalal |
| 3 | 1 | email | blalalalal |
| 4 | 1 | biograp | blalalalal |
| 5 | 1 | comment | blalalalal |
| 6 | 1 | status_res | blalalalal |
| 7 | 1 | activatio | blalalalal |
| 8 | 1 | aim | blalalalal |
| 9 | 1 | jabber | blalalalal |
---------------------------------------------------------
you could look both example at above ,
first table with many field and second just with 4 field ,
now , in two way that, what the best way for on use database ..
thanks for explain to me
regards