echos

supanoob · April 18, 2006

well, my problem is not the echoing itself it is the calling of the queries within the echo.

[code]<?php
session_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 [email protected]
require_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></TD></TR>
<TR>
    <TD align=left width=5></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>
        <?php
require_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%></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">
           <?php
echo "<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></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.

poirot · 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.

supanoob · 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

ToonMariner · 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.

supanoob · April 18, 2006

yeah thanks, i got it sorted now :D

Sign In

echos

Recommended Posts

supanoob

Link to comment

Share on other sites

poirot

Link to comment

Share on other sites

supanoob

Link to comment

Share on other sites

ToonMariner

Link to comment

Share on other sites

supanoob

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information