[SOLVED] Any idea why this wouldn't be working?

[2DaysAway]

I want a message bar to appear if a player has been attacked or sent a message. When I load the script, the page is blank. I think it's my echo's but I've tried several ways and all same result.

 

Look at it and let me know if you see any code problems or know a better way to write it.

 

 <?$get = mysql_query("SELECT round FROM $tab[set] WHERE starts<$time and ends>$time ORDER BY starts ASC;");
while ($game = mysql_fetch_array($get)){
if(fetch("SELECT pimp FROM $tab[pimp] WHERE id='$id' AND rid='$game[round]';")){
$jo3 = "SELECT * from pimps where id='$id' AND rid='$game[round]'";
$jo4 = mysql_query($jo3);
$jo5 = mysql_fetch_array($jo4) or die ("Cannot Recieve Message");
if($jo5["messages"] >= 1) {
echo = "<table border='0' align='center' cellpadding='0' cellspacing='0'><tr><td>";
echo = "<div class='msg'><div align='center'>";
echo = "<a href='inbox.php?rid=$game[round]'>You Have Mail!</a>";
echo = "</div></div>";
echo = "</td></tr></table>";
}
if($jo5["attacks"] >= 1) {
echo = "<table border='0' align='center' cellpadding='0' cellspacing='0'><tr><td>";
echo = "<div class='attacked'><div align='center'>";
echo ="<a href='inbox.php?inbox=1&rid=$game[round]'>You've Been Attacked!</a>";
echo = "</div></div>";
echo = "</td></tr></table>";
  }
}?>

[pocobueno1388]

We can't help you if you don't tell us what it is, and what isn't working about it.

[revraz]

http://www.phpfreaks.com/forums/index.php/topic,6264.0.html

 

Also, use <?php instead of <?

[2DaysAway]

I want a bar to pop up when a player either has a message or been attacked. It maybe the way I'm requesting it. As long as you guys think that it's written correctly. I'll know what direction to look at.

[2DaysAway]

yea I tried it with the <?php but same result

[trq]

I'm not sure exactly what your doing here....

 

echo = "<table border='0' align='center' cellpadding='0' cellspacing='0'><tr><td>";

 

but echo is a language construct, you don't assign values to it, you parse it an argument. eg;

 

echo "<table border='0' align='center' cellpadding='0' cellspacing='0'><tr><td>";

[2DaysAway]

ok, so I changed the echos and added a query warning. Still just getting a blank screen. So because of the blank screen, would my error lie in the echos? Or still somewhere in the query?

 

<?php
  $query = "SELECT round FROM `{$tab[set]}` WHERE `round`='$rid'";
$get = mysql_query($query);
if (!$get) {
$message  = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $query;
die($message);
}
while ($game = mysql_fetch_array($get)){
if(fetch("SELECT pimp FROM `{$tab[pimp]}` WHERE `id`='$id' AND `rid`='$game[round]';")){
$jo3 = "SELECT * FROM pimps WHERE `id`='$id' AND `rid`='$game[round]'";
$jo4 = mysql_query($jo3);
$jo5 = mysql_fetch_array($jo4) or die ("Cannot Recieve Message");
if($jo5["messages"] >= 1) {
echo  "<table border='0' align='center' cellpadding='0' cellspacing='0'><tr><td>";
echo  "<div class=\"msg\"><div align=\"center\">";
echo  "<a href='inbox.php?rid=$game[round]'>You Have Mail!</a>";
echo  "</div></div>";
echo  "</td></tr></table>";
}
if($jo5["attacks"] >= 1) {
echo  "<table border='0' align='center' cellpadding='0' cellspacing='0'><tr><td>";
echo  "<div class=\"attacked\"><div align=\"center\">";
echo "<a href='inbox.php?inbox=1&rid=$game[round]'>You've Been Attacked!</a>";
echo  "</div></div>";
echo  "</td></tr></table>";
}
  }?>

[Fyorl]

If you're getting a blank screen it's because your if statement isn't evaluating to true and therefore none of your echos are being run.

 

I would check what values you're getting out of the database with an echo above your if statements.

[revraz]

Blank screen could also mean an error in the code.

 

*revised to make more sense

[Fyorl]

@revraz: Not necessarily. That's only the case if his error_reporting is set to report no errors.

[revraz]

Just pointing out that there are more reasons that just their IF statment that can cause a blank screen.

[Fyorl]

True, sorry about that.

[2DaysAway]

I ran the script in myphpadmin and I'm getting a sql syntax error in line one, so I'm looking this up now.

[Fyorl]

If you have an error in your SQL syntax then why isn't your error catching block giving a warning? I'm pretty sure mysql_query returns false on failure. Perhaps revraz is right and you've got a parse error or something somewhere which isn't being displayed.

 

If you have access to your php.ini file then try setting error_reporting to E_ALL.

[redarrow]

 

// } <<< added

<?php
  $query = "SELECT round FROM `{$tab[set]}` WHERE `round`='$rid'";
$get = mysql_query($query);
if (!$get) {
$message  = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $query;
die($message);
}
while ($game = mysql_fetch_array($get)){
if(fetch("SELECT pimp FROM `{$tab[pimp]}` WHERE `id`='$id' AND `rid`='$game[round]';")){
$jo3 = "SELECT * FROM pimps WHERE `id`='$id' AND `rid`='$game[round]'";
$jo4 = mysql_query($jo3);
$jo5 = mysql_fetch_array($jo4) or die ("Cannot Recieve Message");
if($jo5["messages"] >= 1) {
echo  "<table border='0' align='center' cellpadding='0' cellspacing='0'><tr><td>";
echo  "<div class=\"msg\"><div align=\"center\">";
echo  "<a href='inbox.php?rid=$game[round]'>You Have Mail!</a>";
echo  "</div></div>";
echo  "</td></tr></table>";
}
if($jo5["attacks"] >= 1) {
echo  "<table border='0' align='center' cellpadding='0' cellspacing='0'><tr><td>";
echo  "<div class=\"attacked\"><div align=\"center\">";
echo "<a href='inbox.php?inbox=1&rid=$game[round]'>You've Been Attacked!</a>";
echo  "</div></div>";
echo  "</td></tr></table>";
}
  }
}
  ?>