Drewdle Posted January 21, 2011 Share Posted January 21, 2011 What's the best way to do previous employer form: It would have field like: Company Name | Position Held | Date Started | Date Ended | Company Address The only problem I have is Joe Bloggs might have 7 previous jobs and Fred Biggins might have only 3 previous jobs... How would I create a table for such a form? Would I have to have them enter each job one at a time and create an add row query?... I think I could add a hidden username field so when I call it back it would display only those rows relevant to that username.... Link to comment https://forums.phpfreaks.com/topic/225146-best-way/ Share on other sites More sharing options...
KevinM1 Posted January 21, 2011 Share Posted January 21, 2011 You'll need multiple tables. At least one for users and one for job listings. The job listings table would have the users table's id column as a foreign key value, thereby allowing any number of job listings per user. Link to comment https://forums.phpfreaks.com/topic/225146-best-way/#findComment-1162826 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.