MySQL Forums
Forum List  »  Newbie

How to store data
Posted by: 6killer
Date: August 19, 2005 12:44AM

I'm new to MySQL but have experience in FileMaker Pro. Here's my issue.

I'd like to setup the two (2) tables to have relational information, which would be the "job_code".

1. I have one table that has the following fields:
a.) job_code (4-digit #)
b.) job_description (text)

2. I have another table that has the following fields:
a.) applicant_id (5-digit #)
b.) applicant_name (text)
c.) job_codes_interested_in (multiple entries) (i.e. 1001, 1004, 1005)

I'd like the report format to look something like:

Applicant ID: 34329
Applicant Name: John Smith
Jobs Interested:
1001 Electrician Apprentice
1003 Plumber
1021 Secretary

My question is, HOW do I enter in the information in the field in 2C? Do I use a comma, colon or a space as a delimeter? I'm using PHP and currently, the table displays correctly now ONLY if there is a single job_code in 2C. If there is more than one job_code_interested_in, I get empty fields for the job_code and the job_description.

Thanks for your patience and helping out a newbie.

Options: ReplyQuote

Written By
How to store data
August 19, 2005 12:44AM
August 19, 2005 02:49AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.