White Screen error When running script

I am trying to run a script for my website and I am getting a white screen with no errors, I have tried running the script with

error_reporting(E_ALL);
ini_set('display_errors',TRUE);

But I still get no errors, I do not have access the php.ini as I am using a godaddy.

//Get ITID from URL
$iITID = $_GET["ITID"];

$oteaminfo = mysql_query("
SELECT .Players.FirstName, Players.LastName, Players.Position, Players.Height,                    Players.Weight, .Players.DOB, Countries.Nation, NHLTeams.Team,      ;  ; ; InternationalTeam.InternationalTeam, InternationalLeagues.InternationLeague,    CNGHLTeams.CNGHLRights
From Players
Inner Join InternationalTeam
On Players.ITID=InternationalTeam.ITID
Inner Join InternationalLeagues
On Players.ILID=InternationalLeagues.ILID
Inner Join Countries
On Players.NationID=Countries.NationID
Inner Join NHLTeams
On Players.TeamsID=NHLTeams.TeamID
Inner Join CNGHLTeams
On Players.CNGHLID=CNGHLTeams.CNGHLID
WHERE InternationalTeam.InternationalTeam=$iITID
ORDER BY Players.LastName;
") or die(mysql_error()); 

while($row = mysql_fetch_array($oteaminfo)) 
{ 
Print "Player Name: ".$row['FirstName']." ".$row['LastName']."<br>"; 
Print "Position: ".$row['Position']."<br>"; 
Print "Height: ".$row['Height']."<br>"; 
Print "Weight: ".$row['Weight']."<br>"; 
Print "Birthdate: ".$row['DOB']."<br>"; 
Print "Nationality: ".$row['NationID']."<br>";
Print "NHL Rights: ".$row['Team']."<br>";
Print "CNGHL Team: ".$row['CNGHLRights']."<br>"; 
} 


  ?>

The script is missing Players.Weight, .Players.DOB, Countries.Nation, NHLTeams.Team, InternationalTeam.InternationalTeam, InternationalLeagues.InternationLeague, CNGHLTeams.CNGHLRights

As it wont let me indent it to show up as script. I have tried looking up this issue but I cannot seem to find anything that will help me in my situation. Any Help would be wonderful thanks.

Answers


I think it is the beginning of your SQL

SELECT .Players.FirstName, Players.LastName, Players.Position

that is messing up. The corrected SQL should be like

SELECT Players.FirstName, Players.LastName, Players.Position

And, as you are attempting to print results on a page, preferably use echo than print. And, print should be print and not Print. PHP is case sensitive.

Also, as per PHP Manual, mysql_ commands are deprecated. It is preferable to use mysqli_ commands or PDO.


Try ini_set('display_errors', 'On'); Basically since the latest release of PHP you can define error visibility per each level, but this line should do it.

Let me know if it helps, if not I might rewrite your code using PDO and try - catch blocks, this way you will be able to raise an exception, and generally your code will be more secure.

http://php.net/manual/en/book.pdo.php


Need Your Help

Automate “Attach to Process” in VS2005/2008

visual-studio debugging

I was wondering if anyone knew of a macro or keyboard shortcut or anything really that would automate Attaching to a Process within visual studio?

strange behaviour on changing listview backgroundcolor

android listview colors background selection

Please help me with a listview .When i click on an item in listview ,I want to highlight the clicked item by changing the background color ,but on clicking the list item background color changes...

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.