[RESOLVED] OMG!! I MESSED IT UP!!

lightningrod66

Please take a look at the code below. This was working perfectly fine until I made changes to make the table headers sortable. That didn't work like I hoped, so I deleted all the changes I had made (so I thought) to get back to the original file. Now the headers are displayed, but there are no rows of player info like there used to be. Any ideas what I did wrong here? I have looked this over at least a dozen times and I can't find my mistake. Please help if you can, as I am now 2 games behind 🙁 Thanks in advance to any help!

<?php 
$username="XXX"; 
$password="XXX"; 
$database="XXX"; 
mysql_connect(localhost,$username,$password); 
@mysql_select_db($database) or die("Unable to select database"); 
$query="SELECT CONCAT(p.FirstName, ' ', p.LastName) AS 'Player', s.minutes, s.fgm, s.fga, round(s.fgm/s.fga, 3) AS 'FG%', s.thgm, s.thga, round(s.thgm/s.thga, 3) AS '3P%', s.ftm, s.fta, round(s.ftm/s.fta, 3) AS 'FT%', s.orb, s.drb, s.ast, s.stl, s.blk, s.tpoints FROM Players p, stats s WHERE s.player_id = p.player_id AND s.game_id = 1 ORDER BY p.player_id"; 
$result=mysql_query($query); 
$num=mysql_numrows($result); 
mysql_close(); 
?> 
</span></div> 
<table border="1" align="center" cellpadding="5" cellspacing="2" > 
<tr bgcolor="#0000AA"> 
<th><div align="center" class="style7 style1"><font face="Arial, Helvetica, sans-serif" size=2>Player</font></div></th> 
<th><div align="center" class="style7 style1"><font face="Arial, Helvetica, sans-serif" size=2>Minutes</font></div></th> 
<th><div align="center" class="style7 style1"><font face="Arial, Helvetica, sans-serif" size=2>FGM</font></div></th> 
<th><div align="center" class="style7 style1"><font face="Arial, Helvetica, sans-serif" size=2>FGA</font></div></th> 
<th><div align="center" class="style7 style1"><font face="Arial, Helvetica, sans-serif" size=2>FG%</font></div></th> 
<th><div align="center" class="style7 style1"><font face="Arial, Helvetica, sans-serif" size=2>3GM</font></div></th> 
<th><div align="center" class="style7 style1"><font face="Arial, Helvetica, sans-serif" size=2>3GA</font></div></th> 
<th><div align="center" class="style7 style1"><font face="Arial, Helvetica, sans-serif" size=2>3P%</font></div></th> 
<th><div align="center" class="style7 style1"><font face="Arial, Helvetica, sans-serif" size=2>FTM</font></div></th> 
<th><div align="center" class="style7 style1"><font face="Arial, Helvetica, sans-serif" size=2>FTA</font></div></th> 
<th><div align="center" class="style7 style1"><font face="Arial, Helvetica, sans-serif" size=2>FT%</font></div></th> 
<th><div align="center" class="style7 style1"><font face="Arial, Helvetica, sans-serif" size=2>ORB</font></div></th> 
<th><div align="center" class="style7 style1"><font face="Arial, Helvetica, sans-serif" size=2>DRB</font></div></th> 
<th><div align="center" class="style7 style1"><font face="Arial, Helvetica, sans-serif" size=2>AST</font></div></th> 
<th><div align="center" class="style7 style1"><font face="Arial, Helvetica, sans-serif" size=2>STL</font></div></th> 
<th><div align="center" class="style7 style1"><font face="Arial, Helvetica, sans-serif" size=2>BLK</font></div></th> 
<th><div align="center" class="style7 style1"><font face="Arial, Helvetica, sans-serif" size=2>Points</font></div></th> 
</tr> 
<?php 
$i=0; 
while ($i < $num) { 
$f1=mysql_result($result,$i,"Player"); 
$f2=mysql_result($result,$i,"minutes"); 
$f3=mysql_result($result,$i,"fgm"); 
$f4=mysql_result($result,$i,"fga"); 
$f5=mysql_result($result,$i,"FG%"); 
$f6=mysql_result($result,$i,"thgm"); 
$f7=mysql_result($result,$i,"thga"); 
$f8=mysql_result($result,$i,"3P%"); 
$f9=mysql_result($result,$i,"ftm"); 
$f10=mysql_result($result,$i,"fta"); 
$f11=mysql_result($result,$i,"FT%"); 
$f12=mysql_result($result,$i,"orb"); 
$f13=mysql_result($result,$i,"drb"); 
$f14=mysql_result($result,$i,"ast"); 
$f15=mysql_result($result,$i,"stl"); 
$f16=mysql_result($result,$i,"blk"); 
$f17=mysql_result($result,$i,"tpoints"); 
?> 
<tr> 
<td><div align="left"><font face="Arial, Helvetica, sans-serif" size=2 color=white><?php echo $f1; ?></font></div></td> 
<td><div align="center"><font face="Arial, Helvetica, sans-serif" size=2 color=white><?php echo $f2; ?></font></div></td> 
<td><div align="center"><font face="Arial, Helvetica, sans-serif" size=2 color=white><?php echo $f3; ?></font></div></td> 
<td><div align="center"><font face="Arial, Helvetica, sans-serif" size=2 color=white><?php echo $f4; ?></font></div></td> 
<td><div align="center"><font face="Arial, Helvetica, sans-serif" size=2 color=white><?php echo $f5; ?></font></div></td> 
<td><div align="center"><font face="Arial, Helvetica, sans-serif" size=2 color=white><?php echo $f6; ?></font></div></td> 
<td><div align="center"><font face="Arial, Helvetica, sans-serif" size=2 color=white><?php echo $f7; ?></font></div></td> 
<td><div align="center"><font face="Arial, Helvetica, sans-serif" size=2 color=white><?php echo $f8; ?></font></div></td> 
<td><div align="center"><font face="Arial, Helvetica, sans-serif" size=2 color=white><?php echo $f9; ?></font></div></td> 
<td><div align="center"><font face="Arial, Helvetica, sans-serif" size=2 color=white><?php echo $f10; ?></font></div></td> 
<td><div align="center"><font face="Arial, Helvetica, sans-serif" size=2 color=white><?php echo $f11; ?></font></div></td> 
<td><div align="center"><font face="Arial, Helvetica, sans-serif" size=2 color=white><?php echo $f12; ?></font></div></td> 
<td><div align="center"><font face="Arial, Helvetica, sans-serif" size=2 color=white><?php echo $f13; ?></font></div></td> 
<td><div align="center"><font face="Arial, Helvetica, sans-serif" size=2 color=white><?php echo $f14; ?></font></div></td> 
<td><div align="center"><font face="Arial, Helvetica, sans-serif" size=2 color=white><?php echo $f15; ?></font></div></td> 
<td><div align="center"><font face="Arial, Helvetica, sans-serif" size=2 color=white><?php echo $f16; ?></font></div></td> 
<td><div align="center"><font face="Arial, Helvetica, sans-serif" size=2 color=white><?php echo $f17; ?></font></div></td> 
</tr> 
<?php 
$i++; 
} 
?> 
<hr class="noscreen" /> 
</table>

lightningrod66

After playing around with this for another hour or so, I feel like an idiot, but I must share this info in case someone else runs into this same issue. In the SQL statement, I have

...WHERE s.player_id = p.player_id AND s.game_id = 1...

I had forgotten that there was no longer a game_id of "1" (I started over with game_id #4), so it wasn't pulling any records in because it was looking for the wrong game_id. I didn't think of looking here because I hadn't edited that part of the file earlier, but I DID make a change to the database. Sometimes its these little things that make or break a person 😃

Sxooter

OK, what this is really about is version control. Look up SVN and install it and use it. It'll save your bacon LOTS in the future and makes deploying a certain set of code while working on it a freaking dream.

Then look up branching in SVN. Not optional. Necessary for sanity.

Tagging is strictly optional, but often useful.

laserlight

I agree with Sxooter, but I disagree with the version control tool recommendation, although I will concede that Subversion's additional tool support is probably the best among open source version control tools at the moment (but I still prefer the distributed version control tool: Bazaar) :p

By the way, Sxooter, I think your signature is outdated.

Sxooter

Well, there's lots of choices for version control. As long as the OP picks one I'll be happy...

Off to update my sig...

Weedpacket

Does the poster need a distributed version control tool specifically for what sounds like a one-user environment?

Sxooter

Exactly. Even CVS would be fine here, but I think svn is a little more "idiot proof" in daily use, and is generally easier to drive when you need to revert changes and such.

laserlight

Weedpacket wrote:
Does the poster need a distributed version control tool specifically for what sounds like a one-user environment?

Need? Maybe not, but I switched from Subversion to Bazaar in a one-user environment myself because I wanted to be able to commit without network access, and to have repositories in multiple computers without a central server. Since a distributed version control tool can act as a centralised version control tool, there is no loss - except for the fact that Subversion is more mature than any of them and thus has better external tool support.

Weedpacket

laserlight wrote:
Subversion ... has better external tool support.

Aye; I was going to mention TortoiseSVN, but then realised that the OP wouldn't care about that.

Another reason for using Bazaar in a one-user environment would be of course if you also collaborated using it; it would make far more sense to be consistent about your VCS than have to mentally switch back and forth between two.

laserlight

Weedpacket wrote:
Another reason for using Bazaar in a one-user environment would be of course if you also collaborated using it; it would make far more sense to be consistent about your VCS than have to mentally switch back and forth between two.

Though if you contribute to different projects with different VCSes you will have to use more than one anyway 🙁 At least I can still use Bazaar to work with Subversion repositories and working copies, but there are limitations nonetheless.