query("select id from ecmproducts where code='$code' and deleted=0"); while ($p = $db->fetchByAssoc($z2)) { $w = $db->query("select id from ecmstocks where deleted='0'"); while ($r = $db->fetchByAssoc($w)) { $ss->UpdateStockState($r['id'], $p['id']); } $w = $db->query("select quantity,stock_name,price,product_code from ecmstockstates where product_id='" . $p['id'] . "' and deleted='0'"); while ($s = $db->fetchByAssoc($w)) { echo $s['product_code'] . " " . $s['stock_name'] . " " . $s['quantity'] . " " . $s['price'] . "
"; } } }