I m makin database in which i hav 10 tables for each sem storeing student result.
i hav link this with php...and giving access to students to see thier results and administrator to edit them olso.
i hav a problem in updating the fields.
first i authenticate the user,ask for sem in which he wants to change (in case of adminisrator) , take the inputs.and insert it back to the database.
Now my question is :
since each table having the students of different stream ( no of subjects are diffrent )..!!
so i m not able to put bak these updated values bak into the database.
(At the time of takin values from admin,i only show those fields which are olready set in database...but at the time of inserting i am not able to insert these values back to table) .
(if i inserted all the values bak to table ...then the unsetted fields olso get sets,, and the next tym when admin see the result the unnecessary fields will olso show as they hav been set to zero( since default value for postin is zero ) in previous insertin...i dont want this... plezzz help me out...:(
its hurry....plezzz.thank you