i have a database called class and in this databasei have a table call students. So if i do describe student then you will see student name, grade, graduationdate, if you do select grade from Students then it will describe the grades for each student . Well what i want to do is to add another section to table students so that means in table student i want to add one more table name average so all the colums of student will now be student name grade graduationdate and average - is this possible if yes what is the syntax to do so if it doesnt make sense what i am asking pleaes im me at rcubes85 on aim

PHP Code:

$addColumn = mysql_query("ALTER TABLE students ADD COLUMN average INT NOT NULL AFTER graduation");