Вот как подсказали, работает
<?
$query="SELECT basket FROM orders WHERE date_format(times, '%Y%m') = date_format(date_add(now(), interval -1 month), '%Y%m') ";
$result=mysqli_query($dbc, $query) or die("dddd");
$prods = array();
while($row=mysqli_fetch_array($result)){
$basket=unserialize(base64_decode($row['basket']));
foreach($basket as $tovar=>$value){
if (!isset($prods[$tovar])) {
$prods[$tovar] = $value;
} else {
$prods[$tovar] += $value;
}
$query="SELECT * FROM beta WHERE article='".$tovar."' ORDER BY name ";
$data = mysqli_query($dbc, $query);
$row = mysqli_fetch_array($data);
//...
}
}
print_r($prods);
|