$mch = mysql ($db, "SELECT MUSEUMch.chid, MUSEUMch.chname, MUSEUMchm.chval FROM MUSEUMch, MUSEUMchm
WHERE MUSEUMchm.mid = $mid AND MUSEUMchm.chid=MUSEUMch.chid
ORDER BY MUSEUMchm.norder") or die (mysql_error());
$mchnum = mysql_numrows ($mch);
for ($i=0;$i<$mchnum;$i++) {
$chid = mysql_result($mch, $i, 0);
$chname = mysql_result($mch, $i, 1);
$chval = mysql_result($mch, $i, 2);
if ($i%2) $bgcolor = "#dbe0ef";
else $bgcolor = "#ffffff";
?>
|
|
}
?>
|
$mph = mysql ($db, "SELECT * FROM MUSEUMph WHERE mid = $mid");
$mphnum = mysql_numrows ($mph);
for ($i=0;$i<$mphnum;$i++) {
$sphname = mysql_result ($mph, $i, 1);
$bphname = mysql_result ($mph, $i, 2);
?>

}
?> |