December 11th, 2012, 09:14 AM
|
|
Registered User
|
|
Join Date: Dec 2012
Posts: 2
Time spent in forums: 47 m 29 sec
Reputation Power: 0
|
|
noob - Internal Server Error
Hi there. I hope I'm posting this in the right area. I need a little help with some PHP Coding. I'm currently setting up a TCG site using MyTCG, a php script that handles card decks, member lists and other stuff so I don't have to do it all manually. All of the pages seem to be working just fine, except for one.
The problem I'm having, is when I go to view the card decks that have already been uploaded. Here's the viewcards.php code that's not giving me the error.
Code:
<?php include("mytcg/settings.php");include("$header"); $deck = $_GET['deck']; $query="SELECT * FROM `$table_cards` WHERE filename='$deck'"; $result=mysql_query($query); while($row=mysql_fetch_assoc($result)) { ?> <h1>Cards > <?php echo $row[deckname]; ?></h1> <table width="100%"> <tr><td valign="top" width="85px"><?php echo "<img src=\"$tcgcardurl$deck"; echo "00.$ext\" />"; ?> </td><td valign="top"><b>Deck Name:</b> <?php echo "$row[deckname"; ?> (<?php echo "$row[filename]"; ?>)<br /> <b>Card Count:</b> <?php if($row[filename]=="member") { $select2 = mysql_query("SELECT * FROM `$table_members` WHERE `membercard`='Yes'"); $memnum = mysql_num_rows($select2); echo "$memnum"; } else { echo "$row[count]"; } ?><br /> <b>Card Worth:</b> <?php echo "$row[worth]"; ?><br /> <b>Masterable?</b> <?php echo "$row[masterable]"; ?><br /> <b>Masters:</b> <?php echo "$row[masters]"; ?> </td></tr> </table><br /> <center> <?php if($deck=="member") { $query2 = "SELECT * FROM $table_members WHERE `membercard`='Yes' ORDER BY `name`"; $result2=mysql_query($query2); while($row2=mysql_fetch_assoc($result2)) { echo "<img src=\"/decks/mc-$row2[name].$ext\" />\n"; } } if($row[puzzle]=="yes") { echo "<img src=\"$tcgcardurl$row[filename]01.$ext\" /><img src=\"$tcgcardurl$row[filename]02.$ext\" /><img src=\"$tcgcardurl$row[filename]03.$ext\" /><br><img src=\"$tcgcardurl$row[filename]04.$ext\" /><img src=\"$tcgcardurl$row[filename]05.$ext\" /><img src=\"$tcgcardurl$row[filename]06.$ext\" /><br><img src=\"$tcgcardurl$row[filename]07.$ext\" /><img src=\"$tcgcardurl$row[filename]08.$ext\" /><img src=\"$tcgcardurl$row[filename]09.$ext\" /><br><img src=\"$tcgcardurl$row[filename]10.$ext\" /><img src=\"$tcgcardurl$row[filename]11.$ext\" /><img src=\"$tcgcardurl$row[filename]12.$ext\" /><br><img src=\"$tcgcardurl$row[filename]13.$ext\" /><img src=\"$tcgcardurl$row[filename]14.$ext\" /><img src=\"$tcgcardurl$row[filename]15.$ext\" /><br>"; } else { for($x=1;$x<=$row[count];$x++) { if($x<10) { echo "<img src=\"$tcgcardurl$row[filename]"; echo "0"; echo "$x.$ext\" />\n"; } else { echo "<img src=\"$tcgcardurl$row[filename]$x.$ext\" />\n"; } } } echo "<br /><br /></div><h1>Master Badge</h1>"; echo "<center>"; echo "<img src=\"$tcgcardurl"."$deck";echo "-master.$ext\" />"; echo "</center>"; echo "<br /><br />"; } include("$footer"); ?>
Now, I'm not sure why it's not working and I keep getting the error, but if I use a different code (which is pretty much a hack for the script), the page comes up fine. But I don't want to use that code as it's not what I want for my site. Here's the code that seems to work:
Code:
<?php include("mytcg/settings.php"); include("$header"); $deck = $_GET['deck']; $query="SELECT *, COUNT(filename) FROM `$table_cards` WHERE filename='$deck' GROUP BY `deckname`"; $result=mysql_query($query); while($row=mysql_fetch_assoc($result)) { ?> <h1><a href="cards.php">Cards</a> > <?php echo "$row[deckname]"; ?></h1> <table width="100%"> <tr><td valign="middle" width="5px"><?php echo "<img src=\"$tcgcardurl$row[filename]00.$ext\" />";?> </td><td valign="middle"><b>Deck Name:</b> <?php echo "$row[deckname]"; ?> (<?php echo "$row[filename]"; ?>)<br /> <b>Card Count:</b> <?php if($row[filename]=="member") { $select2 = mysql_query("SELECT * FROM `$table_members` WHERE `membercard`='Yes'"); $memnum = mysql_num_rows($select2); echo "$memnum"; } else { echo "$row[count]"; } ?><br /> <b>Card Worth:</b> <?php echo "$row[worth]"; ?><br /> <b>Masterable?</b> <?php echo "$row[masterable]"; ?><br /> <b>Masters:</b> <?php echo "$row[masters]"; ?> </td></tr> </table><br /> <?php if($deck=="member") { echo "<center><div align=\"center\">"; $query2 = "SELECT * FROM $table_members WHERE `membercard`='Yes' ORDER BY `name`"; $result2=mysql_query($query2); while($row2=mysql_fetch_assoc($result2)) { echo "<img src=\"(URL address blocked: See forum rules)[name].$ext\" />\n"; } } else { echo "<center>"; for($x=1;$x<=$row[count];$x++) { if($x<10) { echo "<img src=\"$tcgcardurl$row[filename]"; echo "0"; echo "$x.$ext\" />"; } else { echo "<img src=\"$tcgcardurl$row[filename]$x.$ext\" />"; } } } echo "<br /><br /><h3>Master Badge</h3>"; echo "<img src=\"$tcgcardurl$deck";echo "-master.$ext\" />"; echo "</center>"; echo "<br /><br /></div></div></div>"; } include("$footer"); ?>
Any help I can get would be appreciated. Thanks so much!
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
