Help with array?

[sks1024]

I have a table that has a field with a organizational code and description for each department.

i.e.

104444 Finance
104445 IT
104446 HR

i have another table that has items belonging to those departments with the organizational code in each record of each item

i.e

104445 Dell

I want to show the description field of the organizational code instead of the number from the first table when outputting info from the second table.

I thought about a switch but that is alot of typing.

Thanks,
Stan

[Weedpacket]

Here's a hint.

$mapping['104444']='Finance';

echo $mapping['104444'];

[sks1024]

All I see that doing is creating a varialbe with a hard coded value.

maybe I am not seeing what you think I should

[Weedpacket]

Well, I said it was a hint; maybe it was too subtle.

Get the code and the description out of the table and make an array; use the code for the array key and the description for its value. Then whenever you have the code and need the description, you can just look it up in the array.

If a database is involved this can also be done with a basic query. Not having any idea how you've got any of your data organised all I can do is make vague gestures.

[sks1024]

This is a database and I am confused a bit.

table orgs

field org field description
104444 Finance
104445 IT
104446 HR

$Link = mysql_connect ($Host, $User, $Password) or die ("The database connection could not be established!");
$query = "SELECT * From orgs";
$result = mysql_db_query($DBName, $query, $Link) or die('Could not complete database query' . mysql_error());

while ($row = mysql_fetch_array($result)) {
$description = $row['description'];
$org = $row['org'];
}

I now have the values of org and description

what next - is this looking somewhat correct

$array = array("org" => $org, "description" => $description);

I now output the org info associated with an item from a second table and a second sql query

HTML OUTPUT BELOW
Name Location Service Tag Model Year Leased

user1 104410 JH3T631 Optiplex GX260 2003

I want to add the descprtion info from the org table as well as keep the org code already displayed.

Thanks,
Stan