\n"; require ("menu.php"); echo "\n"; echo "
\n"; echo "\n"; $query1 = "select set_name, pic_file, slide, year, company from sets where set_id='$set_id'"; $result1 = mysql_query($query1) or die ("Query Failed 1.
$query1
" . mysql_error()); echo "\n"; while ($row = mysql_fetch_row($result1)) { $set_name = $row[0]; $pic_file = $row[1]; $slide = $row[2]; $year = $row[3]; $company = $row[4]; echo "\n"; echo "\n"; echo "\n"; $query3 = "select comment from sets where set_id='$set_id'"; $result3 = mysql_query($query3) or die ("Query Failed 3.
$query3
" . mysql_error()); $num = mysql_numrows($result3); if ($num >0) { while ($row = mysql_fetch_row($result3)) { $comment = $row[0]; } echo "\n"; } echo "

$set_name

($year $company)
\n"; } $query2 = "SELECT fantasy.type, sum(ownership.own), sum(ownership.trade), sum(ownership.want) FROM fantasy inner join ownership on fantasy.card_id = ownership.card_id WHERE fantasy.set_id='$set_id' and ownership.acc_id='$acc_id' GROUP by fantasy.type ORDER by fantasy.sort_by"; $result2 = mysql_query($query2) or die ("Query Failed 2.
$query2
" . mysql_error()); while ($row = mysql_fetch_row($result2)) { $sumtype = $row[0]; $sumown = $row[1]; $sumtrade = $row[2]; $sumwant = $row[3]; echo "\n"; } echo "

Quick Set summary

Card TypeI OwnTradableI Need
$sumtype$sumown $sumtrade$sumwant
$comment

\n"; if ($_SESSION['username'] == "") { $query10 = "select card_id, sort_by, card_no, title, type, value, jpg from fantasy where set_id='$set_id' order by sort_by"; $result10 = mysql_query($query10) or die ("Query 10 Failed.
$query10
" . mysql_error()); echo "
\n"; echo ""; $i=0; while ($row = mysql_fetch_row($result10)) { $card_id = $row[0]; $sort_by = $row[1]; $card_no = $row[2]; $title = $row[3]; $type = $row[4]; $value = $row[5]; $jpg = $row[6]; if ($sort_by%2) { echo "\n"; } else { echo "\n"; } } echo "\n"; echo "
Card #TitleType Book Value
$card_no$title $type\$$value
$card_no$title $type\$$value
\n"; } else { $query1 ="select * from ownership where set_id='$set_id' and acc_id='$acc_id'"; $result1 = mysql_query($query1) or die ("Query Failed.
$query1
" . mysql_error()); $num_rows=mysql_num_rows($result1); if ($num_rows=="0") { echo "\n"; echo "
"; echo "
\n"; } else { $query1 = "select card_id, sort_by, card_no, title, type, value from fantasy where set_id='$set_id' order by sort_by"; $result1 = mysql_query($query1) or die ("Query Failed.
$query1
" . mysql_error()); echo "\n"; echo ""; $i=0; while ($row = mysql_fetch_row($result1)) { $card_id = $row[0]; $sort_by = $row[1]; $card_no = $row[2]; $title = $row[3]; $type = $row[4]; $value = $row[5]; echo "\n"; // if ($sort_by%2) // { // $class = "odd2"; // } // else // { // $class = ""; // } echo "\n \n"; echo "\n"; $query2 = "select own, trade, want, my_value, card_comment from ownership where set_id='$set_id' and card_id='$card_id' and acc_id='$acc_id'"; $result2 = mysql_query($query2) or die ("Query Failed.
$query2
" . mysql_error()); while ($row = mysql_fetch_row($result2)) { $own_old = $row[0]; $trade_old = $row[1]; $want_old = $row[2]; $my_price = $row[3]; $comment = $row[4]; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } // end of query2 while $i++; } // end of query1 while //$i++; $x++; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
Card #TitleType Book
Value		Own TradeNeedMy Price
$card_no$title$type\$$value
"; if ($comment == "" ) { echo "

Add Comment to share with prospective buyers

\n"; } echo "$comment
"; echo " Return to top of page\n"; echo "\n"; echo "\n"; echo "
\n"; echo "
\n"; } //end else started on 101 } echo ""; echo ""; ?>