Cant get page to load

[msnhockey]

I have a .php page that i use to manage players (trade, retire, create, unregister, etc..)
well in php 5.3 and up I cant get the page to load. IN php 5.2 and below it loads.

My provider only allows 5.3 as its highest version at the moment but if someone can glance at this and maybe see why its not loading that would be great

<?
function player_list() {

 global $u,$sessionid;

 include("config.php");
 $open = mysql_connect($hostname, $user, $password);
 mysql_select_db("$db", $open);

  $html = "
        <p class=\"header\" align=center><!--%admin_title_mplayers%--></p>
        <p class=\"body_text\" align=\"center\"><a href=\"admin_register.php?st=0005&u=".$u."&sessid=".$sessionid."\"
        onClick=\"NewWindow(this.href,'name','600','500','yes');return false;\"><img src='images/newgame.gif'
        border=0> <b><font color=\"red\"><!--%admin_addplayer%--></font></b></a></p>";

  //REGISTERED PLAYERS
  $result_rpi = mysql_query("SELECT * FROM players WHERE registered = '1' ORDER BY lname");
  $total_rpi = mysql_num_rows($result_rpi);
  $s = 0;

  $rlist = "
	<b>$total_rpi <!--%admin_registered%-->:</b><br>
	Player Name (Division)(Team)(Position)<br>
	<select name=\"pid\" size=\"10\">";

  while($s < $total_rpi) {
        $pid = mysql_result($result_rpi,$s,"id");
        $pname = mysql_result($result_rpi,$s,"fname")." ".mysql_result($result_rpi,$s,"lname");
        $ppos = mysql_result($result_rpi,$s,"position");
        $pnum = mysql_result($result_rpi,$s,"number");
	$teamid = mysql_result($result_rpi,$s,"teamid");
	$result_pt = mysql_query("SELECT name FROM teams WHERE id = '".$teamid."'");
	$pteam = mysql_result($result_pt,o,"name");
	$result_pt2 = mysql_query("SELECT division FROM teams WHERE id = '".$teamid."'");
	$pdiv = mysql_result($result_pt2,o,"division");
	$result_pt2 = mysql_query("SELECT name FROM divisions WHERE id = '".$pdiv."'");
	$pdiv = mysql_result($result_pt2,o,"name");

    $rlist .= "
    <option value=\"".$pid."\">".$pname." (".$pdiv.")(".$pteam.")(".$ppos.")</option>";

    $s++;
  }

  $rlist .= "</select>";

  //UNREGISTERED PLAYERS
  $result_upi = mysql_query("SELECT * FROM players WHERE registered = '0' ORDER BY requested DESC, lname");
  $total_upi = mysql_num_rows($result_upi);
  $s = 0;

  $ulist = "
	<b>$total_upi <!--%admin_unregistered%-->:</b><br>
	Player Name (Position)<br>
        <select name=\"pid\" size=\"10\">";

  while($s < $total_upi) {
        $pid = mysql_result($result_upi,$s,"id");
	$requested = mysql_result($result_upi,$s,"requested");
        $pname = mysql_result($result_upi,$s,"fname")." ".mysql_result($result_upi,$s,"lname");
        $ppos = mysql_result($result_upi,$s,"position");
        $pnum = mysql_result($result_upi,$s,"number");
        $teamid = mysql_result($result_upi,$s,"teamid");
        $result_pt = mysql_query("SELECT name FROM teams WHERE id = '".$teamid."'");
        $pteam = mysql_result($result_pt,0,"name");

    $ulist .= "
        <option value=\"".$pid."\">".$pname." (".$ppos.")";

if($requested == 1) {
	$ulist .= "(Requested by ".$pteam.")";
}

$ulist .= "</option>";

    $s++;
  }

  $ulist .= "</select>";

  //RETIRED PLAYERS
  $result_repi = mysql_query("SELECT * FROM players WHERE registered = '2' ORDER BY requested DESC, lname");
  $total_repi = mysql_num_rows($result_repi);
  $s = 0;

  $relist = "
	<b>$total_repi Retired Players:</b><br>
	Player Name (Position)<br>
        <select name=\"pid\" size=\"10\">";

  while($s < $total_repi) {
        $pid = mysql_result($result_repi,$s,"id");
	$requested = mysql_result($result_repi,$s,"requested");
        $pname = mysql_result($result_repi,$s,"fname")." ".mysql_result($result_repi,$s,"lname");
        $ppos = mysql_result($result_repi,$s,"position");
        $pnum = mysql_result($result_repi,$s,"number");
        $teamid = mysql_result($result_repi,$s,"teamid");
        $result_pt = mysql_query("SELECT name FROM teams WHERE id = '".$teamid."'");


    $relist .= "
        <option value=\"".$pid."\">".$pname." (".$ppos.")";

$relist .= "</option>";

    $s++;
  }

  $relist .= "</select>";

  //TRADE PLAYERS
  $result_tpi1 = mysql_query("SELECT * FROM players WHERE registered = '1' ORDER BY lname");
  $total_tpi1 = mysql_num_rows($result_tpi1);
  $s = 0;

  $trlist = "
	<b>$total_tpi1 <!--%admin_registered%-->:</b><br>
	Player Name (Division)(Team)(Position)<br>
	<table><tr><td>
	<select name=\"pid1\" size=\"10\">";

  while($s < $total_tpi1) {
        $pid = mysql_result($result_tpi1,$s,"id");
        $pname = mysql_result($result_tpi1,$s,"fname")." ".mysql_result($result_tpi1,$s,"lname");
        $ppos = mysql_result($result_tpi1,$s,"position");
        $pnum = mysql_result($result_tpi1,$s,"number");
	$teamid = mysql_result($result_tpi1,$s,"teamid");
	$result_pt = mysql_query("SELECT name FROM teams WHERE id = '".$teamid."'");
	$pteam = mysql_result($result_pt,o,"name");
	$result_pt2 = mysql_query("SELECT division FROM teams WHERE id = '".$teamid."'");
	$pdiv = mysql_result($result_pt2,o,"division");
	$result_pt2 = mysql_query("SELECT name FROM divisions WHERE id = '".$pdiv."'");
	$pdiv = mysql_result($result_pt2,o,"name");

    $trlist .= "
    <option value=\"".$pid."\">".$pname." (".$pdiv.")(".$pteam.")(".$ppos.")</option>";

    $s++;
  }
  $s = 0;

  $trlist .= "</select></td><td>
	<select name=\"pid2\" size=\"10\">";

  while($s < $total_tpi1) {
        $pid = mysql_result($result_tpi1,$s,"id");
        $pname = mysql_result($result_tpi1,$s,"fname")." ".mysql_result($result_tpi1,$s,"lname");
        $ppos = mysql_result($result_tpi1,$s,"position");
        $pnum = mysql_result($result_tpi1,$s,"number");
	$teamid = mysql_result($result_tpi1,$s,"teamid");
	$result_pt = mysql_query("SELECT name FROM teams WHERE id = '".$teamid."'");
	$pteam = mysql_result($result_pt,o,"name");
	$result_pt2 = mysql_query("SELECT division FROM teams WHERE id = '".$teamid."'");
	$pdiv = mysql_result($result_pt2,o,"division");
	$result_pt2 = mysql_query("SELECT name FROM divisions WHERE id = '".$pdiv."'");
	$pdiv = mysql_result($result_pt2,o,"name");

    $trlist .= "
    <option value=\"".$pid."\">".$pname." (".$pdiv.")(".$pteam.")(".$ppos.")</option>";

    $s++;
  }
  $trlist .= "</select></td></tr></table>";

  $result_rapi2 = mysql_query("SELECT * FROM teams a WHERE division > ' ' ORDER BY name");
  $total_rapi2 = mysql_num_rows($result_rapi2);

  $s = 0;

  $ralist = "
	<b>$total_tpi1 <!--%admin_registered%-->:</b><br>
	Player Name (Division)(Team)(Position)<br>
	<table><tr><td>
	<select name=\"pid1\" size=\"10\">";

  while($s < $total_tpi1) {
        $pid = mysql_result($result_tpi1,$s,"id");
        $pname = mysql_result($result_tpi1,$s,"fname")." ".mysql_result($result_tpi1,$s,"lname");
        $ppos = mysql_result($result_tpi1,$s,"position");
        $pnum = mysql_result($result_tpi1,$s,"number");
	$teamid = mysql_result($result_tpi1,$s,"teamid");
	$result_pt = mysql_query("SELECT name FROM teams WHERE id = '".$teamid."'");
	$pteam = mysql_result($result_pt,o,"name");
	$result_pt2 = mysql_query("SELECT division FROM teams WHERE id = '".$teamid."'");
	$pdiv = mysql_result($result_pt2,o,"division");
	$result_pt2 = mysql_query("SELECT name FROM divisions WHERE id = '".$pdiv."'");
	$pdiv = mysql_result($result_pt2,o,"name");

    $ralist .= "
    <option value=\"".$pid."\">".$pname." (".$pdiv.")(".$pteam.")(".$ppos.")</option>";

    $s++;
  }
  $s = 0;

  $ralist .= "</select></td><td>
	<select name=\"pid2\" size=\"10\">";

  while($s < $total_rapi2) {
        $teamid = mysql_result($result_rapi2,$s,"id");
	$pteam = mysql_result($result_rapi2,$s,"name");
	$pdiv = mysql_result($result_rapi2,$s,"division");
	$result_pt2 = mysql_query("SELECT name FROM divisions WHERE id = '".$pdiv."'");
	$pdiv = mysql_result($result_pt2,o,"name");
        $ralist .= "
	    <option value=\"".$teamid."\"> (".$pdiv.")(".$pteam.")</option>";
        $s++;
  }
  $ralist .= "</select></td></tr></table>";

  $result_rapi4 = mysql_query("SELECT * FROM teams a WHERE division > ' ' ORDER BY name");
  $total_rapi4 = mysql_num_rows($result_rapi4);

  $s = 0;

  $rclist = "
	<b>$total_tpi1 <!--%admin_registered%-->:</b><br>
	Player Name (Division)(Team)(Position)<br>
	<table><tr><td>
	<select name=\"pid1\" size=\"10\">";

  while($s < $total_tpi1) {
        $pid = mysql_result($result_tpi1,$s,"id");
        $pname = mysql_result($result_tpi1,$s,"fname")." ".mysql_result($result_tpi1,$s,"lname");
        $ppos = mysql_result($result_tpi1,$s,"position");
        $pnum = mysql_result($result_tpi1,$s,"number");
	$teamid = mysql_result($result_tpi1,$s,"teamid");
	$result_pt = mysql_query("SELECT name FROM teams WHERE id = '".$teamid."'");
	$pteam = mysql_result($result_pt,o,"name");
	$result_pt2 = mysql_query("SELECT division FROM teams WHERE id = '".$teamid."'");
	$pdiv = mysql_result($result_pt2,o,"division");
	$result_pt2 = mysql_query("SELECT name FROM divisions WHERE id = '".$pdiv."'");
	$pdiv = mysql_result($result_pt2,o,"name");

    $rclist .= "
    <option value=\"".$pid."\">".$pname." (".$pdiv.")(".$pteam.")(".$ppos.")</option>";

    $s++;
  }
  $s = 0;

  $rclist .= "</select></td><td>
	<select name=\"pid2\" size=\"10\">";

[msnhockey]

 while($s < $total_rapi4) {
        $teamid = mysql_result($result_rapi4,$s,"id");
	$pteam = mysql_result($result_rapi4,$s,"name");
	$pdiv = mysql_result($result_rapi4,$s,"division");
	$result_pt4 = mysql_query("SELECT name FROM divisions WHERE id = '".$pdiv."'");
	$pdiv = mysql_result($result_pt4,o,"name");
        $rclist .= "
	    <option value=\"".$teamid."\"> ".$pteam." </option>";
        $s++;
  }
  $rclist .= "</select></td></tr></table>";

  $html .= "
	<table cellpadding=\"5\" cellspacing=\"0\" border=\"0\" align=\"center\" width=\"600\">
	<tr><td class=\"body_text\" valign=\"top\">
	<form method=\"post\" action=\"admin.php\">
	<input type=\"hidden\" name=\"u\" value=\"admin\">
	<input type=\"hidden\" name=\"opt\" value=\"unregister\">"
	.$rlist."
	<br /><br /><input class=\"button\" type=\"submit\" name=\"Submit\" value=\"<!--%admin_unregplayer%-->\">
	</form></td><td class=\"body_text\" valign=\"top\">
	<form method=\"post\" action=\"admin.php\">
        <input type=\"hidden\" name=\"u\" value=\"admin\">
        <input type=\"hidden\" name=\"opt\" value=\"register\">"
	.$ulist."
	<br /><br /><input class=\"button\" type=\"submit\" name=\"Submit\" value=\"<!--%admin_regplayer%-->\">
	<br /><input class=\"button\" type=\"submit\" name=\"retire\" value=\"Retire Player\">
	</form></td></tr>
	<tr><td class=\"body_text\" valign=\"top\" colspan=\"2\">
	<form method=\"post\" action=\"admin.php\">
        <input type=\"hidden\" name=\"u\" value=\"admin\">
        <input type=\"hidden\" name=\"opt\" value=\"unretire\">"
	.$relist."
	<br /><br /><input class=\"button\" type=\"submit\" name=\"Submit\" value=\"Unretire Player\">
	</form></td></tr>
	<tr><td class=\"body_text\" valign=\"top\" colspan=\"2\">
	<form method=\"post\" action=\"admin.php\">
        <input type=\"hidden\" name=\"u\" value=\"admin\">
        <input type=\"hidden\" name=\"opt\" value=\"trade\">"
	.$trlist."
	<br /><br /><input class=\"button\" type=\"submit\" name=\"Submit\" value=\"Trade Player\">
        </form></td></tr>
	<tr><td class=\"body_text\" valign=\"top\" colspan=\"2\">
	<form method=\"post\" action=\"admin.php\">
        <input type=\"hidden\" name=\"u\" value=\"admin\">
        <input type=\"hidden\" name=\"opt\" value=\"reassigned\">"
	.$ralist."
	<br /><br /><input class=\"button\" type=\"submit\" name=\"Submit\" value=\"Re-Assigned Player\">
	</form></td></tr> 
	<tr><td class=\"body_text\" valign=\"top\" colspan=\"2\">
	<form method=\"post\" action=\"admin.php\">
        <input type=\"hidden\" name=\"u\" value=\"admin\">
        <input type=\"hidden\" name=\"opt\" value=\"recalled\">"
	.$rclist."
	<br /><br /><input class=\"button\" type=\"submit\" name=\"Submit\" value=\"Re-Call Player\">
	</form></td></tr> 
	</table>";

  return $html;
}


//REGISTER A LISTED PLAYER
function register_form($pid) {

  global $u,$sessionid;

 include("config.php");

  $open = mysql_connect($hostname,$user,$password);
  mysql_select_db("$db",$open);

  $html = "
        <p class=\"header\" align=center><!--%admin_title_mplayers%--></p>";

  $tlist = "
        <select name=\"teamid\">";

	//GET TEAM NAME
	$result_tn = mysql_query("SELECT id,name,division FROM teams WHERE name != 'admin' ORDER BY name");
	$selectteam_name = mysql_result($result_tn,0,"name");

	$counter = 0;
	$total_rows = mysql_num_rows($result_tn);
	while($counter < $total_rows) {
	      $tname = mysql_result($result_tn,$counter,"name");
	      $tid = mysql_result($result_tn,$counter,"id");
	      $divn = mysql_result($result_tn,$counter,"division");
	      $result_td = mysql_query("SELECT name FROM divisions WHERE id = '".$divn."'");
	      $dname = mysql_result($result_td,0,"name");

	      if ($hname != "admin") {
			$tlist .= "
			<option value=\"".$tid."\">".$tname." - ".$dname."</option>";
	      }
	      $counter++;
	}

  $tlist .= "</select>";

  $result_pn = mysql_query("SELECT * FROM players WHERE id = '".$pid."'");
  $fpname = mysql_result($result_pn,0,"fname");
  $lpname = mysql_result($result_pn,0,"lname");
  $lpnum = mysql_result($result_pn,0,"number");
  $lppos = mysql_result($result_pn,0,"position");
  $requested = mysql_result($result_pn,0,"requested");

  $html .= "
	<form method=\"post\" action=\"admin.php\">
	<input type =\"hidden\" name=\"u\" value=\"admin\">
	<input type =\"hidden\" name=\"pid\" value=\"".$pid."\">
	<input type =\"hidden\" name=\"opt\" value=\"register01\">
	  <table width=\"300\" border=\"0\" cellspacing=\"0\" cellpadding=\"2\" align=\"center\">
	    <tr>
		<td class=\"body_text\">First Name:</td>
		<td class=\"body_text\"><input class='table_text' type=text value=\"".$fpname."\" name=\"fname1\"></td>
	    </tr>
	    <tr>
	    <td class=\"body_text\">Last Name:</td>
		<td class=\"body_text\"><input class='table_text' type=text value=\"".$lpname."\" name=\"lname1\"></td>
	    </tr>
	    <tr>
		<td class=\"body_text\">Position:</td>
		<td class=\"body_text\"><input class='table_text' type=text value=\"".$lppos."\" name=\"position1\"></td>
	    </tr>
	    <tr>
		<td class=\"body_text\">Jersey Number:</td>
		<td class=\"body_text\"><input class='table_text' type=text value=\"".$lpnum."\" name=\"number1\"></td>
	    </tr>
	    <tr>
	      <td class=\"body_text\"><!--%admin_pteam%-->:</td>";

  if($requested == 1) {
	$teamid = mysql_result($result_pn,0,"teamid");
	$result_tteam = mysql_query("SELECT name FROM teams WHERE id = '".$teamid."'");
        $html .= "
              <td class=\"body_text\">".mysql_result($result_tteam,0,"name")."
              <input type=\"hidden\" name=\"teamid\" value=\"".$teamid."\"></td>";
  } else {

$html .= "
      <td class=\"body_text\">".$tlist."
      </td>";
  }

  $html .= "
	    </tr>
	    <tr>
	      <td colspan=\"2\">
	        <input class=\"button\" type=\"submit\" name=\"Submit\" value=\"<!--%admin_regplayer%-->!\">
		<input class=\"button\" type=\"button\" value=\"<!--%admin_cancel%-->\" onClick=\"history.go(-1)\">
	      </td>
	    </tr>
	  </table>
	</form>";

  return $html;

}


//REGISTER A LISTED PLAYER
function register($pid,$teamid,$fname1,$lname1,$position1,$number1) {

  global $u,$sessionid;

 include("config.php");

  $open = mysql_connect($hostname,$user,$password);
  mysql_select_db("$db",$open);

  if(!$pid) {
            $sql =  "INSERT INTO players VALUES ";
  			$sql .= "('NULL','$lname1','$fname1','$teamid','$position1',";
  			$sql .= "'$number1','','','1','0')";
			$done = mysql_query($sql);
			if(!$done) { echo mysql_errno().": ".mysql_error()."<br>"; }

		mysql_query("INSERT INTO `register_log` VALUES('" . mysql_insert_id($open) . "', '" . $teamid . "', '1', '" . time() . "')");
  } else {

  $sql = "UPDATE players SET teamid = '".$teamid."', ";
  $sql .= "lname = '".$lname1."', fname = '".$fname1."', ";
  $sql .= "position = '".$position1."', number = '".$number1."', ";
  $sql .= "registered = '1', requested = '0' WHERE id = '$pid'";
  $done = mysql_query($sql);
  if(!$done) { echo mysql_errno().": ".mysql_error()."<br>"; }

  mysql_query("INSERT INTO `register_log` VALUES('" . $pid . "', '" . $teamid . "', '1', '" . time() . "')");
 }
}

//UNREGISTER A PLAYER
function unregister($pid) {

  global $u,$sessionid;

 include("config.php");

  $open = mysql_connect($hostname,$user,$password);
  mysql_select_db("$db",$open);

  $sql = "UPDATE players SET registered = '0' WHERE id = '$pid'";
  $done = mysql_query($sql);
  if(!$done) { echo mysql_errno().": ".mysql_error()."<br>"; }

  $player = mysql_query("SELECT `teamid` FROM `players` WHERE id = '" . $pid . "'");
  mysql_query("INSERT INTO `register_log` VALUES('" . $pid . "', '" . mysql_result($player, 0) . "', '0', '" . time() . "')");

}

function retire($pid) {

  global $u,$sessionid;

 include("config.php");

  $open = mysql_connect($hostname,$user,$password);
  mysql_select_db("$db",$open);

  $sql = "UPDATE players SET registered = '2' WHERE id = '$pid'";
  $done = mysql_query($sql);
  if(!$done) { echo mysql_errno().": ".mysql_error()."<br>"; }

mysql_query("INSERT INTO `register_log` VALUES('" . $pid . "', '" . $teamid . "', '2', '" . time() . "')");
}

function unretire($pid) {

  global $u,$sessionid;

 include("config.php");

  $open = mysql_connect($hostname,$user,$password);
  mysql_select_db("$db",$open);

  $sql = "UPDATE players SET registered = '0' WHERE id = '$pid'";
  $done = mysql_query($sql);
  if(!$done) { echo mysql_errno().": ".mysql_error()."<br>"; }

mysql_query("INSERT INTO `register_log` VALUES('" . $pid . "', '" . $teamid . "', '0', '" . time() . "')");
}



?>

[dalecosp]

Don't you have access to a logfile that would tell you what's up? Or adjust error_reporting ...

At any rate, it appears to line Just Fine(tm). Could it be this?

msnhockey wrote:

<?

At some point (off top of head, can't recall), short open tags were deprecated and are no longer turned on in more modern installations...

[msnhockey]

error reporting is turned on and my error logs are empty.

will try a couple things and see what happens and will start with the <? first