Search the Community

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