I am creating a jobs database and I’m trying to code the output. Instead of seeing “TX” for a state, I’m seeing it’s ID value of “1”
What code Do I need to script in order to display it’s value and not the ID?
Here is the table setup:
Table 1: _state
Row1: ID INT AUTOINCREMENT
Row2: State VARCHAR
Table 2: _city
Row1: ID INT AUTOINC
Row2: StateID INT
Row3: City
Table 3: _jobs
Row1: ID INT AUTOINC
Row2: CityID INT
Row3: StateID INT
Row4: Job Title VARCHAR
Here’s the php code, data is being taken from table 3 _jobs:
My output looks like this:
City State Job Title
1 1 Test Job 1