Allow user to add the new fields in the tables

Replies

• 

  dilipmathi

  Hi
  
  Any suggestions?
  
  Thanks
  
  Dilip
• 

  PraveenKumar Purushothaman

  If you have a numeric read of fields, then your code itself is wrong... In case of PHP and MySQL, what I do is,
  

      $res = mysql_query("SELECT * FROM `table`");
    while ($dat = mysql_fetch_row($res))
        // Display the rows.


  This way, it iterates through all the possible fields... 😀 Not just a set of fields you hard-coded... 😀
• 

  dilipmathi

  Hi
  
  Thank you so much for your reply.
  
  When the user adding the new fields changing the table structure is a good idea?
  
  Or any other ways to achieve it?
  
  Please help me
  
  Thanks
• 

  PraveenKumar Purushothaman

  Changing the table structure is the WORST idea... BTW, what is your scenario, so that I can guide you... 😀
• 

  dilipmathi

  Hi
  
  Thanks again for your reply
  
  If let say we have an contact information table with the following fields (First name , Last name) . The user wants to add an new field called Address.
  
  How to achieve the above scenario?
  
  Thanks
  
  Dilip
• 

  PraveenKumar Purushothaman

  Use joins... Have you heard of tags??? And BTW, for your particular query, I have sent you a link in your VM... How to use tags and stuff in database... 😀 Enjoy... 😀
• 

  dilipmathi

  I have sent you a link in your VM... How to use tags and stuff in database... 😀 Enjoy... 😀

  How can i find it?
  
  Thanks
• 

  PraveenKumar Purushothaman

  Go to your profile... #-Link-Snipped-# And see the link.
• 

  dilipmathi

  Hi
  
  Thank you much for your help. I got an idea to do that.
  
  Can you please share your ideas on this thread?
  
  #-Link-Snipped-#
  
  Thanks in advance
  
  Dilip
• 

  PraveenKumar Purushothaman

  Sure Dilip! 😀
• 

  PraveenKumar Purushothaman

  Dilip I posted there. Do check it out... And also, please read this excellent tutorial by GF... 😀
  #-Link-Snipped-# 😀
• 

  PraveenKumar Purushothaman

  I will be posting more information about CRM in my blog soon... 😀