fahim74

I have been practicing mysql and then i have came accross a issu that i can't solve ... i have also asked in different forum and dont find any suitable ans ..... so here i am ... I am making a large form that will be able to store information from user in the database .. I have managed to make and store data from simple form fields like Name, Country , Age , Interest and etc using mysql and php ... I have a table called users in my database which have approximate 15 column for different data like Name , Country , Age etc .... Now I have added this from field to my from and confused about how to store data from this field .. here is the img of my form .... the above table says.....each separate user will have separate employment histroy which will be submitted through row 1-4 and Employer's Name , Country , Position etc (4 row of them) will go in columns called emp_name , emp_country, emp_pos etc. . Even if i create a different table ex - emp_history then how to store data from this form for each user ? than you for understanding ...

well i am trying to write a simple script for my online ticket shop ... just for local area based ... I have managed to install a open source PHP login script and designed a simple template and thats all there is in my site for now .... I have been planing to put some custom Field in registration form where user can input a verification code and the amount of tickets they want and when they will enter the code and the amount of tickets then they will have the ticket in their account from my database where i have already stored them ... In my database i have a table called 'ticket' and inside i have 'id' , and some 'html' code in text field Now i have managed the verification process and stuck at here .... well , when a user will demand , for instant - 5 tickets then the ticket from 1-5 will store in their account and if another user demand 6 tickets after that then the ticket 6-12 will go to their account .... Any kind of help will be appreciable like working code or Pseudocode