I currently have the following array,
Array (1) 0 => Array (5) productid => 1 qty => 1 materialid => 12
and I have the following two queries which are
select name as productname, price from products where productid=1
and
select name from materials where materialid=12
I need to link these queries such that the array output is like this or similar:
Array (1) 0 => Array (5) productid => 1 qty => 1 materialid => 12 productname => Toothbrush price => £3.00
This is basically to output the content on to a basket page. Note that the queries can not be joined as there isn't any joins on the two tables.
Thanks