Lightworker Cards

"; $backLink = "Draw Again"; } else { $imageWidth = 200; // larger images for flower cards $imgDir = "

"; $backLink = "Draw Again"; } // $numOfCards = 3; // ************************************** open table that encloses entire page **************************************** echo "

"; // ************************************************ show heading in a table ***************************************************************************************************** echo ""; echo "

"; echo $imgHeader; echo "	"; echo "" . $backLink . "

"; // ************************************************ show user's question ******************************************************************************************************* echo "
" . $question . "
" ; // ************************************************ get card IDs from database *********************************************** mysql_connect($dbhost,$user,$password) or die("server error"); mysql_select_db($db) or die("database error"); srand(mktime()); // FEB02 - modified line below for deckID $result = mysql_query("SELECT cardID from cards where deckID = $inDeckID"); //%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% if doing 3 card %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% if ($numOfCards == 3) { $rnum1 = rand() % mysql_numrows($result); while ($rnum2 == "" || $rnum2 == $rnum1) { $rnum2 = rand() % mysql_numrows($result); } while ($rnum3 == "" || $rnum3 == $rnum1 || $rnum3 == $rnum2) { $rnum3 = rand() % mysql_numrows($result); } $cardID1 = mysql_result($result,$rnum1,"cardID"); $cardID2 = mysql_result($result,$rnum2,"cardID"); $cardID3 = mysql_result($result,$rnum3,"cardID"); $IDarray = array (1=>$cardID1, 2=>$cardID2, 3=>$cardID3); // (1=>80, 2=>10, 3=>20) asort ($IDarray); // (2=>10, 3=>20, 1=>80) sort array by number order but maintain keys reset ($IDarray); // put pointer at 1st item $i = 0; while (list ($key, $val) = each ($IDarray) ) { // for each key/value pair $displayRow[$key] = $i; // build array showing which SQL row to display in which order eg. array(3,1,2) $i = $i + 1; } // echo "$key => $val
"; $sql = "SELECT cardImage, cardName, cardName2, cardInfo, cardType, archetype, planet, zodiac FROM cards where cardID in (" . $cardID1 . "," . $cardID2 . "," . $cardID3 . ")"; $result = mysql_query($sql); // ************************************* Display 3 Cards in Row ************************************************* ?>

The Past
" . mysql_result($result,$displayRow[1],"cardName") . ""; ?>
"; ?>

The Present
" . mysql_result($result,$displayRow[2],"cardName") . ""; ?>
"; ?>

The Future
" . mysql_result($result,$displayRow[3],"cardName") . ""; ?>
"; ?>

The Past

"") echo "
" . mysql_result($result,$displayRow[1],"cardName2"); ?>

"") echo "
Traditional Archetype: " . mysql_result($result,$displayRow[1],"archetype") . ""; if (mysql_result($result,$displayRow[1],"planet") <> "") echo "
Planetary ruler: " . mysql_result($result,$displayRow[1],"planet") . ""; if (mysql_result($result,$displayRow[1],"zodiac") <> "") echo "
Zodiacal ruler:: " . mysql_result($result,$displayRow[1],"zodiac") . ""; ?>

The Present

"") echo "
" . mysql_result($result,$displayRow[2],"cardName2"); ?>

"") echo "
Traditional Archetype: " . mysql_result($result,$displayRow[2],"archetype") . ""; if (mysql_result($result,$displayRow[2],"planet") <> "") echo "
Planetary ruler: " . mysql_result($result,$displayRow[2],"planet") . ""; if (mysql_result($result,$displayRow[2],"zodiac") <> "") echo "
Zodiacal ruler:: " . mysql_result($result,$displayRow[2],"zodiac") . ""; ?>

The Future

"") echo "
" . mysql_result($result,$displayRow[3],"cardName2"); ?>

"") echo "
Traditional Archetype: " . mysql_result($result,$displayRow[3],"archetype") . ""; if (mysql_result($result,$displayRow[3],"planet") <> "") echo "
Planetary ruler: " . mysql_result($result,$displayRow[3],"planet") . ""; if (mysql_result($result,$displayRow[3],"zodiac") <> "") echo "
Zodiacal ruler:: " . mysql_result($result,$displayRow[3],"zodiac") . ""; ?>

Return to top

"; ?>

"; echo ""; echo ""; ?>