Hey Guys, I've got two sets of results from two different queries. The fields in both tables are almost identical, the one field I need to access is. My question is before I continue to do the foreach loop to return the appropriate field, can I merge the two results together prior to my foreach loop? It would basically help condense some of the repetitive code. the only field I am interested in retrieving from both datasets is called dataPlot.

$dataset1 = $fm->newFindAllCommand('table_dataset1');

$result1 = $dataset1->execute();

$dataset2 = $fm->newFindAllCommand('table_dataset2');

$result2 = $dataset2->execute();

 

Many thanks

Jalz

Figured it out, array_merge() is the command thats required