J'ai fait cette requête
1 2 3 4 5 6 7
| $sql = "select distinct
( SELECT t2.itemname FROM ti_item AS t2 WHERE t2.itemnum = ti_itemmixingelement.sourceitemnum ) AS itamename1, ti_itemmixingelement.sourceitemcount
from ti_item
inner join ti_itemmixinginfo on ti_item.itemnum = ti_itemmixinginfo.targetitemnum
inner join ti_itemmixingelement on ti_itemmixinginfo.uniqueid = ti_itemmixingelement.uniqueid
WHERE ti_itemmixinginfo.targetitemnum = {$id}";
$conn = $this->bdd->prepare($sql); |
Ça fonctionne j'ai ce tableau en retour :
array(4) { ["itamename1"]=> string(20) "High Purity Catalyst" [0]=> string(20) "High Purity Catalyst" ["sourceitemcount"]=> string(1) "1" [1]=> string(1) "1" } array(4) { ["itamename1"]=> string(22) "High Purity Netine Ore" [0]=> string(22) "High Purity Netine Ore" ["sourceitemcount"]=> string(1) "2" [1]=> string(1) "2" } array(4) { ["itamename1"]=> string(8) "Edcanium" [0]=> string(8) "Edcanium" ["sourceitemcount"]=> string(1) "1" [1]=> string(1) "1" } array(4) { ["itamename1"]=> string(15) "Soft Moissanite" [0]=> string(15) "Soft Moissanite" ["sourceitemcount"]=> string(1) "1" [1]=> string(1) "1" } array(4) { ["itamename1"]=> string(6) "Nickel" [0]=> string(6) "Nickel" ["sourceitemcount"]=> string(1) "1" [1]=> string(1) "1" }
Mais ma question est comment récupérer item par item et récupérer sourceritemcount pour chaque colonne
Partager