Problem with multidimensional array

[Operandi]

I'm having problems extracting data from a multi dimensional array. The array is returned from the database in this format:

$report_array =
report[0][spec1][spec2][spec3] etc
report[1][spec1][spec2][spec3]
report[2] etc etc

I need to extract the spec variables for each report and pass it to a function ie

report[0] function call is afunction ([spec1], [spec2] etc )
report[1] function call is afunction ([spec1], [spec2] etc )

There must be a simple answer, but I'm stumped by it at the moment

any suggestions?

[dannys]

How about :

foreach($report_array as $report)
  afunction($report['spec1'],$report['spec2'],$report['spec3']);

[Operandi]

Danny - I had tried that , and I have just tried it again, just to make sure. All I had passed to the function was an integer. This is the code segment causing the problems

$query = "SELECT * FROM std_reports where report_group='$report'";
$result = mysql_query ( $query );
$report_array = mysql_fetch_array ( $result );

foreach($report_array as $a_row)
{

// create the report url

$report_url = create_report_url ( "inbound", $a_row[type], $period, $a_row[tryall], $a_row[varlist], $a_row[varlist_label], $a_row[graph_type], $a_row[name_list], $a_row[y_label], $a_row[interval15], $a_row[group], $a_row[colordef] );
}

Thanks

[dannys]

Well it's been a while since I last used the MySQL commands but this should work. (untested though)

<?php

$query = "SELECT * FROM std_reports where report_group='$report'";

if ($result = mysql_query ($query))
{
	while ($row = mysql_fetch_assoc ($result))
	{
		// create the report url
		$report_url = create_report_url ( "inbound", $row[type], $period, $row[tryall], $row[varlist], $row[varlist_label], $row[graph_type], $row[name_list], $row[y_label], $row[interval15], $row[group], $row[colordef]);
	}
}
else
{
	echo "Query Failed";
}

?>

[Operandi]

Thanks, (again) Danny. That worked perfectly