Now Reaaaaly close to finishing my project =), had a bit of scope creep with the person we are doing the project for. uffff, yea i know...
so now im saving all the details to my mysql database.
like this field. "name" of the person, i would save it like this
Butttt nowww.... i have a "student_level_ID" field in my Student table, which is a secondary key, related to "Level_id" in my Level table. so now if i want to save the data in the "level textbox" to the students secondary key, HOw would i do it?
Tables = Students and Student level
Fields = in Students = Student_level_ID
.........in Student level = Level_ID
for instance. Textbox Level --> "Advanced"
but now in my student table, i have to insert a 2 in the "student_level_ID" as that is the primary key in the "Level" table.
Ive tried a few ways, without much success.
Would be much appreciated if you could point me in the right direction once again.
thank you. =)