Echo contents of array based on value of column in array?

[Robert Thompson]

I have been working on this for a few days now, and I have not given
up. I am reading and re-reading through the PHP on-line manual with no
luck (so far).

Here's my problem:

I have a working .php page, but it takes 218 seconds to load. Now let
me explain why. I am doing 80 selects, and each select takes roughly 2
seconds. I am trying to condense all of my data into one select then
pull it out <b> based on the content of the row </b> IE: I want to
echo a row that contains the value "excel".

So, how do I echo one row of an array where row [0] col [0] contains
"excel"? This column will always be unique.

Here is my select and my array:

$query = "SELECT transaction_id,AVG (resultValue) FROM
event_meter WHERE (Date_Time BETWEEN $wk_start AND $wk_end) group by
transaction_id ORDER BY transaction_id ASC";
$result = mssql_query ($query,$connection) or DIE ("Query
Failed");
$test = mssql_fetch_array ($result);

So my multi-dimensional array looks like this (representation):

excel 20hits
word 50hits
citrix 70hits
notepad 15hits

I may have 100 rows in my array, but I just want to echo the row that
contains notepad in [0][0].

I have experimented with some 10 PHP functions with no luck.

Any insight would be GREATLY appreciated :o)

Bobby Thompson
SmartStream Inc.
bobby...@smartstream.net
remove NOSPAM to reply