Q) We have 4 text boxes to take input but we hav only one column in our database. How to insert the text of 4 different text boxes in to a single column of database(occupying 4 rows) one after the other.
[ 4 ur understanding I m explaining the scenario: when a teacher is uploading the test he/she will enter the question, the correct ans and the 4 choices but we hav only one column for choices not 4 different columns. We hav decided that we will save each choice accordig to quest id like for question 1 we have 4 rows, for question 2 we hav another 2 rows…… hope u r getting what im trying to say]
Q) how to keep track of no. of records entered by that time i.e every time when a new record is entered , the count shuld not get re-initialized but it shuld increment in the last value it had stroed in it.
many thanks..