[PHP] Blank Page

[Edrick Smith]

Hey I'm trying to help someone with a little game script they've coded. The issue is one of the pages loads a blank white page and doesn't display the status as it should.

http://cl1p.net/8am

There's the status.php code do you see any issues with the code?

[zeroday]

Are the first two queries being successfully executed? Add a

or die(mysql_error());

to the end of

mysql_query($sqlN)

.

Also, you're not escaping the $_POST and $_COOKIE vars before using them for a query. You should always use

mysql_real_escape_string($some_var);

[C++]

<?php
$username="******";
$password="puppypuppy";
$database="*******";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$last = $_COOKIE['ID_my_site']; 

$query = "SELECT*FROM wings, users where wings.Numero = users.Wing AND users.username = '" . $last ."';";

$query2 = "SELECT Wing From users where users.Wing = 0;";

$result = mysql_query($query);
$result2 = mysql_query($query2);

<?----soooooo lost----------->

$sql = "INSERT INTO wings (CC1, GB1, Radar1, Runway1, Factory1, NP1, Residence1, PP1, Oil1)
VALUES ($_POST[1], $_POST[2], $_POST[3], $_POST[4], $_POST[5], $_POST[6], $_POST[7], $_POST[8]);";  

$result = mysql_query($sql)or die ("Error. Could not do SQL query!");








<?---form starts here--->

<form action="<?php echo $PHP_SELF; ?>" method="post">



<?--------pray for a miracle--->

Your code has so many issues that I dread even trying to fix them all...

You didn't close your PHP tag, you're using PHP tags instead of comment tags, and you aren't escaping variables. NO **** it doesn't work, lol...

Try this.

<?php
$username="******";
$password="puppypuppy";
$database="*******";

mysql_connect('localhost',$username,$password);
mysql_select_db($database) or die( "Unable to select database");

$last = $_COOKIE['ID_my_site'];

$query = "SELECT * FROM users INNER JOIN wings ON users.Wing = wings.Numero WHERE users.username = '{$last}'";

$query2 = "SELECT Wing FROM users where users.Wing = '0'";

$result = mysql_query($query);
$result2 = mysql_query($query2);

/*soooooo lost*/

$sql = "INSERT INTO wings (CC1, GB1, Radar1, Runway1, Factory1, NP1, Residence1, PP1, Oil1)
VALUES ({$_POST[1]}, {$_POST[2]}, {$_POST[3]}, {$_POST[4]}, {$_POST[5]}, {$_POST[6]}, {$_POST[7]}, {$_POST[8]})"; 

$result = mysql_query($sql)or die ("Error. Could not do SQL query!");

?>
<!--form starts here-->

<form action="<?php echo $PHP_SELF; ?>" method="post">

<!--pray for a miracle-->

[TurboTuna]

Maybe im tired, but i fail to see what you're doing here.

$query2 = "SELECT Wing FROM users where users.Wing = '0'";

if you know the value is 0, why are you looking it up?

[C++]

Maybe im tired, but i fail to see what you're doing here.

$query2 = "SELECT Wing FROM users where users.Wing = '0'";

if you know the value is 0, why are you looking it up?

Frankly I was not sure why he's running either of the first two queries. But I didn't make it my job to question it, just to make his broken code work.

[Edrick Smith]

It's not my script I'm trying to help a friend get it working she's trying to learn programming.

[Kami-]

Wow... I started looking at it and when I got to the point where your using php tags for a comment, I just stopped and gave up.

[d3nuo]

Wow... I started looking at it and when I got to the point where your using php tags for a comment, I just stopped and gave up.

ditto. not to be mean though, it's just probably easier to rewrite rather than fix the current code, and as i'm not exactly sure what they want, it's difficult to accomplish that. good luck to OP though, hopefully you can get it figured out!!