Using MEDIUMTEXT to store site disclaimers in DB using phpmyadmin

[Popgun]

Hi all,

 

I have a fairly complex need to store site disclaimers in a DB, so I carved out the actual table containing the various disclaimers as follows:

 

disclaimer_ID MEDIUMINT         UNSIGNED

tos                 MEDIUMTEXT NOT NULL

legal                 MEDIUMTEXT NOT NULL

privacy         MEDIUMTEXT NOT NULL

 

This is carved out for business reasons as the disclaimer text may change and we have to track what set of disclaimers the user agreed to and when.

 

Ok well now the stupid question:

 

How do I input the disclaimer text into the mediumtext fields using PHPmyadmin? OR do I need to create a PHP page tied to this and input it via form?

 

I know this is probably a stupid question but thanks for the help in advance

 

[elflacodepr]

You can simply make a query like this in phpMyAdmin:

 

INSERT INTO disclaimer VALUES ('PUT YOUR DISCLAIMER MESSAGE HERE');

 

• You will write your Disclaimer message inside the '
  
• Change "disclaimer" to the desired table name.
   
  

 

BUT...as you say the disclaimer may change you better use a PHP application to update them