I am trying to add a new column to my MYSQL table using PHP. I am unsure how to alter my table so that the new column is created. In my assessment table I have:
assessmentid | q1 | q2 | q3 | q4 | q5
Say I have a page with a textbox and I type q6 in to the textbox and press a button then the table is updated to:
assessmentid | q1 | q2 | q3 | q4 | q5 | q6
My code:
include 'core/init.php';
include 'core/admininit.php';
include 'includes/overall/overall_header.php';
adminprotect_page();
include 'includes/adminmenu.php';
?>
mysql_query("ALTER TABLE `assessment` ADD newq INT(1) NOT NULL AFTER `q10`");
?>
Input Career Name
Career Name
name="submit" value="Submit">