title: Setting default value of Mysql Columns using PHP Input Box Value
body: <p>I am very new to PHP and MySql. Is there any method by which using PHP script taking value through input box can we set the default value of the column using an update query with this value, rather than alter table function?</p>
  
  <p><strong>Update 1:</strong></p>
  
  <p>I want whatever value I send through my form to become default value of that column. There will be some other columns, whose values should change and not set as default, while other default values should appear in the input box for further updating. </p>
  
  <p>For example, there are 3 columns: <code>A</code>, <code>B</code>, <code>C</code>.  Column <code>A</code> has <code>currdate</code> value. Columns B and C are some integer values. Say a user opens the form, he sees the currdate is <code>02-07-2012</code> for the column A. Then he enters some values: B = 5, C = 6. The next day when the user opens the form, the currdate will become 03-07-2012. Simultaneously the value of <code>B</code> and <code>C</code> will automatically change from <code>null</code> to 5 and 6, with previous row value the same as default value.</p>
  
  <p>So is it possible that every new row takes the previous value entered from the form as the default value of the column set in the mysql table?</p>