Monopoly : Rues
prepare("SELECT rid,nom,prix FROM mono_rues ORDER BY rue,rid"); $stm2=$dbh->prepare("SELECT pid FROM mono_achat WHERE rid=?"); $stm3=$dbh->prepare("SELECT joueur FROM mono_joueur WHERE pid=?"); $stm->execute(); while($row = $stm->fetch()) { echo "
"; echo "
" . $row["nom"] . "
"; echo "
" . $row["prix"] . "
"; $stm2->execute(array($row["rid"])); if ($row2=$stm2->fetch()) { $stm3->execute(array($row2["pid"])); $row3=$stm3->fetch(); echo "
" . $row3["joueur"] . "
"; } else { echo "
"; } echo "
"; } ?>