i trying run script website , getting white screen no errors, have tried running script
error_reporting(e_all); ini_set('display_errors',true); but still no errors, not have access php.ini using godaddy.
//get itid 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 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 internationalteam.internationalteam=$iitid order 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 missing players.weight, .players.dob, countries.nation, nhlteams.team, internationalteam.internationalteam, internationalleagues.internationleague, cnghlteams.cnghlrights
as wont let me indent show script. have tried looking issue cannot seem find me in situation. wonderful thanks.
i think beginning of sql
select .players.firstname, players.lastname, players.position that messing up. corrected sql should like
select players.firstname, players.lastname, players.position and, attempting print results on page, preferably use echo print. and, print should print , not print. php case sensitive.
also, per php manual, mysql_ commands deprecated. preferable use mysqli_ commands or pdo.
