[RESOLVED] Array element matching..not sure where to start

[Chris_96_WS6]

I have a web application which is importing data from an Oracle table. Some of this information, such as a "status" field, only outputs numeric values....I have to assign a label to that value on the GUI end.

I've stored a matching set of values and corresponding labels in a MySQL table.

What I haven't figured out is how to match up and display the correct label.

So I have table rows like this from Oracle:

Title..............Status
ExampleA..........2
ExampleB..........4
ExampleC..........3

and labels like this from MySQL

val....label
2......Active
3......Expired
4......Pending

and I want this:

Title..............Status
ExampleA..........Active
ExampleB..........Pending
ExampleC..........Expired

I don't want to query the MySQL table for each printed row. So I think I need feed the MySQL table into an array, and then somehow match each row's status val to the corresponding array element. Just not sure how to code it.

[nemonoman]

There are 2 ways. Since I don't know current methods with Oracle, you'll have to a little work -- but the pseudocode is easy.

First: Just include status names in your Oracle query. There is some equivalent to a MySQL case statement:

SELECT name, CASE status
    WHEN 2 THEN 'Active'
   WHEN3 THEN 'Pending'
   WHEN 4 THEN 'Expired'
END CASE

Or do a string replace on the row returned. I don't know for sure, but I'll just call the row $row and the status element $row['status'],

$kill=array('2','3','4')
$replacewith=array('active','pending','expired')

Then in your row fetching:

$row['status']=str_replace($kill,$replacewith,$row['status'])

[niroshan]

you can first populate the mysql table values to an array as,

$sql ='SELECT * FROM lables';
$row = mysql_query($sql);

while($result=mysql_fetch_array($row))
{
     $lablesArr[$result['id']]=$result['name'];
}

then when ever you want you can just call it as,

$oracleStatus = <-- oracle table value -->

print $lablesArr[$oracleStatus];

Hope this helps,

Regards,
Niroshan

[bradgrafelman]

All you need is a simple JOIN here...

SELECT t.title, s.label status
FROM titles t
LEFT JOIN status s
ON t.status = s.val;

That's assuming your two tables are named "titles" and "status" respectively.

[Chris_96_WS6]

Thanks to you both. Took a little expirimentation with your suggestions but I have it working now.

My first "associative array" if you can believe that.