Xdega Posted November 11, 2010 Share Posted November 11, 2010 I have been playing around with this. Thought I had it nailed, and then found that It was fubar when I started to add more entries to the database. I basically want to display 2 tables from my database on the page. One is called "players" the other is called "editlog". The output with my current script came out as this: and here is the dreaded code: <html> <body> <u><h3>Performance Point Monitor (PPM): Knights of Shadow WoW Officers.</h3></u> <?php include('/home/a3269923/public_html/ppm/admin/config.php'); include('/home/a3269923/public_html/ppm/admin/dbopen.php'); $query="SELECT * FROM players"; $result=mysql_query($query); $num=mysql_numrows($result); ?> <table border="1" style="position:absolute;width:500;height:10;left:0;top:70"> <tr> <th><font face="Arial, Helvetica, sans-serif">PLAYER</font></th> <th><font face="Arial, Helvetica, sans-serif">POINTS</font></th> <th><font face="Arial, Helvetica, sans-serif">DATE</font></th> </tr> <?php $i=0; while ($i < $num) { $f2=mysql_result($result,$i,"PLAYER_NAME"); $f3=mysql_result($result,$i,"ND_POINTS"); $f4=mysql_result($result,$i,"DATE ADDED"); ?> <tr> <td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $f4; ?></font></td> </tr> </table> <?php $i++; } ?> <?php include('/home/a3269923/public_html/ppm/admin/config.php'); include('/home/a3269923/public_html/ppm/admin/dbopen.php'); //USER LOG $query="SELECT * FROM editlog"; $result=mysql_query($query); $num=mysql_numrows($result); ?> <table border="1" style="position:absolute;width:600;height:10;left:510;top:70"> <tr> <th><font face="Arial, Helvetica, sans-serif">USER</font></th> <th><font face="Arial, Helvetica, sans-serif">TYPE</font></th> <th><font face="Arial, Helvetica, sans-serif">POINTS</font></th> <th><font face="Arial, Helvetica, sans-serif">NOTES</font></th> <th><font face="Arial, Helvetica, sans-serif">DATE</font></th> </tr> <?php $i=0; while ($i < $num) { $f1=mysql_result($result,$i,"USER"); $f2=mysql_result($result,$i,"TYPE"); $f3=mysql_result($result,$i,"POINTS"); $f4=mysql_result($result,$i,"NOTE"); $f5=mysql_result($result,$i,"TIMESTAMP"); ?> <tr> <td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $f4; ?></font></td> <td><font face="Arial, Helvetica, sans-serif"><?php echo $f5; ?></font></td> </tr> </table> <?php $i++; } ?> What am I doing wrong? Halp! Quote Link to comment https://forums.phpfreaks.com/topic/218445-trying-to-get-data-from-2-different-tables-to-display-on-one-page/ Share on other sites More sharing options...
Xdega Posted November 12, 2010 Author Share Posted November 12, 2010 anyone? Quote Link to comment https://forums.phpfreaks.com/topic/218445-trying-to-get-data-from-2-different-tables-to-display-on-one-page/#findComment-1133403 Share on other sites More sharing options...
revraz Posted November 12, 2010 Share Posted November 12, 2010 You have your tables starting at the same place. Quote Link to comment https://forums.phpfreaks.com/topic/218445-trying-to-get-data-from-2-different-tables-to-display-on-one-page/#findComment-1133404 Share on other sites More sharing options...
revraz Posted November 12, 2010 Share Posted November 12, 2010 Move your 2nd ending table </table> out of your loop. And your first one. Quote Link to comment https://forums.phpfreaks.com/topic/218445-trying-to-get-data-from-2-different-tables-to-display-on-one-page/#findComment-1133405 Share on other sites More sharing options...
Xdega Posted November 12, 2010 Author Share Posted November 12, 2010 thank you much. Here I was worried that it was something huge messing it up. Quote Link to comment https://forums.phpfreaks.com/topic/218445-trying-to-get-data-from-2-different-tables-to-display-on-one-page/#findComment-1133602 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.