supanoob Posted April 18, 2006 Share Posted April 18, 2006 well, my problem is not the echoing itself it is the calling of the queries within the echo.[code]<?phpsession_start();//this code is compyright to supanoob http://www.twottk.com// to use this code you must have his permission to gain// permission please mail him at webmaster@twottk.comrequire_once('header.php');if (!$_SESSION['valid_user']) { echo 'you are not logged in'; die();} $query="select playerid, user, email, fatigue, maxfat, power, speed, dex, intel, health, maxhealth, gender from players where user='$user'";$result=mysql_query($query);if (!$result){die (mysql_error());}$num_rows=mysql_num_rows($result);echo "$query";?><HTML><HEAD><style type="text/css" media="all"> @import "css.php"; </style> <TITLE>TWOTTK.COM</TITLE></HEAD><TABLE width=100% border=0 cellpadding=0 cellspacing=0><TR> <TD colspan=5> <p align="center"> <img src="http://www.twottk.com/game/banner.jpg" width="730" height="160"></p> <TABLE border=0 cellpadding=0 cellspacing=0> <TR><TD> </TD></TR> </TABLE> </TD></TR><TR height=20><TD colspan=5 align=left><!-- SPACER --></TD></TR><TR> <TD align=left width=5><!-- SPACER --></TD> <TD align=left WIDTH=20% valign=top> <TABLE border=0 cellpadding=0 cellspacing=0 height="85" width="164"> <TR> <TD colspan=2 width=164 height="17"><hr></TD> </TR> <TR> <?phprequire_once('cssloggedin.php');$row=mysql_fetch_array($result);$playerid=($row['playerid']);$user=($row['user']);$fatigue=($row['fatigue']);$maxfat=($row['maxfat']);$power=($row['power']);$speed=($row['speed']);$dex=($row['dex']);$intel=($row['intel']);$health=($row['health']);$maxhealth=($row['maxhealth']);$gender=($row['gender']);?> <TR> <TD colspan=2 width=164 height="30"> Game Stats:<br> ID: <?php echo "$playerid"; ?><br> Gender: <?php echo "$gender"; ?><br> Health: <?php echo "$health / $maxhealth"; ?><br> Fatigue: <?php echo "$fatigue / $maxfat"; ?><hr> <p><hr>Navigation:<br> <a href="home.php">Home</a><br><a href="town.php">Town</a><br>Account<br><a href="logout.php">Logout<br></a> <hr></p> <hr></TD> </TR> <TR height=20> <TD height="1" width="164"><!-SPACER-></TD> </TR> <TR> <TD colspan=2 width=164 height="1"> </TD> </TR> <TR> <TD width=164 bgcolor=#FFFFFF valign=top height="12"><samp>Logged In: <?php echo date ('jS F'); ?><p></samp></TD> <TD width=1 bgcolor=#FFFFFF height="12"></TD> </TR> <TR> <TD colspan=2 width=164 height="12"><hr> </TD> </TR> </TABLE> <BR> </TD> <TD align=left width=1%><!-- SPACER --></TD> <TD align=left WIDTH=78% valign=top> <TABLE width=744 border=0 cellpadding=0 cellspacing=0 height="12"> <TR> <TD valign=top align=left width=4 height="12"></TD> <TD valign=top align=center background=templates/default/images/menuback.gif width="736" height="12"><hr></TD> <TD valign=top align=right width=4 height="12"></TD> </TR> </TABLE><TABLE width=740 border=0 cellpadding=0 cellspacing=0> <TR> <TD width=1 bgcolor=#FFFFFF></TD> <TD bgcolor=#FFFFFF width="733" > <p align="center"> <img src="http://www.twottk.com/game/character.jpg" width="105" height="200"></p> <div id="gamestats"> <?phpecho "<b>Character Stats:</b><br /><br />Power: $power <br /> Speed: $speed <br /> Dexterity: $dex <br /> Inteligence: $intel"; ?></div> <p> </p> <p> </p> <p> </p> <p> </p> <p> </TD> </TR> </TABLE> <p> </p> <TABLE width=748 border=0 cellpadding=0 cellspacing=0 height="39"> <TR> <TD valign=top align=left width=4 height="39"> </TD> <TD align=center background=templates/default/images/menu_bottom.gif width="740" height="39"><hr></TD> <TD valign=top align=right width=4 height="39"> </TD> </TR> </TABLE> <br><CENTER> <p></p> </CENTER> </TD> <TD align=left width=10><!-- SPACER --></TD></TR></TABLE></BODY></HTML>[/code]thats the code. now the problem is the:[code] <TR> <TD colspan=2 width=164 height="30"> Game Stats:<br> ID: <?php echo "$playerid"; ?><br> Gender: <?php echo "$gender"; ?><br> Health: <?php echo "$health / $maxhealth"; ?><br> Fatigue: <?php echo "$fatigue / $maxfat"; ?><hr>[/code]this and all other parts like this do not show up the $health etc when the file is uploaded. now i have a login which takes me to the exact same page as this and that works fine now i cant understand why this isnt :S.go to www.twottk.com/game signup login and click home to see what i mean. Quote Link to comment https://forums.phpfreaks.com/topic/7657-echos/ Share on other sites More sharing options...
poirot Posted April 18, 2006 Share Posted April 18, 2006 Well, displaying the query was very helpful:select playerid, user, email, fatigue, maxfat, power, speed, dex, intel, health, maxhealth, gender from players where user=''As you see, user='', it's empty. Your script is not recording the user id. Quote Link to comment https://forums.phpfreaks.com/topic/7657-echos/#findComment-27948 Share on other sites More sharing options...
supanoob Posted April 18, 2006 Author Share Posted April 18, 2006 [!--quoteo(post=365787:date=Apr 17 2006, 07:46 PM:name=poirot)--][div class=\'quotetop\']QUOTE(poirot @ Apr 17 2006, 07:46 PM) [snapback]365787[/snapback][/div][div class=\'quotemain\'][!--quotec--]Well, displaying the query was very helpful:select playerid, user, email, fatigue, maxfat, power, speed, dex, intel, health, maxhealth, gender from players where user=''As you see, user='', it's empty. Your script is not recording the user id.[/quote]any idea on how to sort it? i do have something after that, as you can see from the code :S Quote Link to comment https://forums.phpfreaks.com/topic/7657-echos/#findComment-28092 Share on other sites More sharing options...
ToonMariner Posted April 18, 2006 Share Posted April 18, 2006 somewhere before your query define $user.Is this taken from a session variable? if so $user = $_SESSION['user']What ever is holding the value you need assign it to $user and it should be fine. Quote Link to comment https://forums.phpfreaks.com/topic/7657-echos/#findComment-28103 Share on other sites More sharing options...
supanoob Posted April 18, 2006 Author Share Posted April 18, 2006 yeah thanks, i got it sorted now :D Quote Link to comment https://forums.phpfreaks.com/topic/7657-echos/#findComment-28226 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.