Просмотр поста

# Onatolich (22.08.2014 / 17:57)

$goods = mysql_query"SELECT * FROM `goods`;");
while($good = mysql_fetch_array($goods)) {
    $photos = mysql_query("SELECT * FROM `photos` WHERE `ref` = " . $good['id'] . ";");
}

$goods = [];
$result = mysql_query("SELECT * FROM `goods`");
while (($good = mysql_fetch_assoc($result))) {
    $good['id'] = (int) $good['id'];
    $good['photos'] = [];
    $goods[$good['id']] = $good;
}

$result = mysql_query("SELECT * FROM `photos` WHERE `ref` IN('" . join("', '", array_keys($goods)) . "')");
while (($photo = mysql_fetch_assoc($result))) {
    $photo['ref'] = (int) $photo['ref'];
    $goods[$photo['ref']]['photos'][] = $photo;
}