Extract and sum specific fields in FFD

[isnotchicago]

I have a flat file database with data like the following:

01|Greg|5
02|John|1
02|John|5
03|Mary|3
04|Matt|2
02|John|3

with the form being ID|Name|Hours. How can I extract just, for instance, John's hours and show that he has worked 9 hours total (1 + 5 + 3)? I have found from various sites how to display a single person's information, but no idea how to do the rest.

[bradgrafelman]

Well, if you just want a specific person's totals:

$file = file('db.txt');
$file = array_map( create_function('$a', 'return explode("|", $a);'), $file);
for($i=0,$total=0; isset($file[$i]); $i++)
	if($file[$i][1] == 'John')
		$total += $file[$i][2];

echo "John's total is: $total hours!";

[isnotchicago]

That is beautiful, thank you!