Jump to content

jwer78

Members
  • Posts

    20
  • Joined

  • Last visited

    Never

Contact Methods

  • Website URL
    http://bhfl.maddenfootballleagues.com
  • Yahoo
    nwflcommish

Profile Information

  • Gender
    Not Telling

jwer78's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Yes it works in sqlyog, it actually works with or without the slash I gave sprintf a try and it still did not work.
  2. Ok so ereg_replace active on both. With stripslashes = SELECT * FROM madcat_players where name=' D'Wayne Matthews' and pos='LT' Without = SELECT * FROM madcat_players where name=' D\'Wayne Matthews' and pos='LT' Thanks again
  3. Ok I have this script that is used to bid on players for a football league I run. Some players names have punctuation in them. If I echo the query it is correct and I am able to run it via sqlyog but it does not work in the script. Any help would be greatly appreciated. Here is the part I am having problems with. $bthousand=$_POST["bthousand"]; $bmillion=$_POST["bmillion"]; $thousand=$_POST["thousand"]; $million=$_POST["million"]; $years=$_POST["years"]; $teamname=$_POST["teamname"]; $pass=$_POST["password"]; $player=$_POST["player"]; $position=$_POST["position"]; $ip=$_SERVER['REMOTE_ADDR']; $today = date("F j, Y, g:i a"); $id=0; //$player=ereg_replace("'","\'",$player); // CONNECT TO DATABASE $db = @mysql_connect($host,$user,$password) or die("<html><head><body bgcolor=$bgcolor alink=$bglinkcolor vlink=$bglinkcolor link=$bglinkcolor>User Error!</body></html>"); @mysql_select_db($database,$db) or die("<html><head><body bgcolor=$bgcolor alink=$bglinkcolor vlink=$bglinkcolor link=$bglinkcolor>Database Error!</body></html>"); //$player=stripslashes($player); $sql_query = "SELECT * FROM madcat_players where name='$player' and pos='$position'"; $result= mysql_query($sql_query); //echo $sql_query . "<br>\n"; $array= mysql_fetch_array($result); $id = $array["id"]; if ($id > '0'){ $sql_query= "Select * from madcat_yearly_player_info where id='$id' order by year desc limit 1"; $result=mysql_query($sql_query); //echo $sql_query . "<br>\n"; $array=mysql_fetch_array($result); $overall=$array["ovr"]; } else{ die("No such player found. Try again. Player is $player and position is $position"); } You will see I have tried to replace the punctuation and stripslashes but nothing has made this work. It does work fine for any player name that has no punctuation in it. Thanks again.
  4. I need to run a check to see if an array is null. Here is the section I am having problems with. Any help would be greatly appreciated. $bowl_query=mysql_query($bowl_sql); while($bowl_array=mysql_fetch_array($bowl_query)){ $amt=$bowl_array['subtrans_paid']; if($bowl_array='NULL'){ $bowl_award="DUE"; } if($amt > '3.00'){ $bowl_award="Yes"; }else{ $bowl_award="No"; }
  5. Hi all I need a little help with modifying this script. It reads from a txt file and dumbs the data into the database. Well the txt file has some new data displayed for the defense, in particular CTH Allow and Big Hit. I added these to the line but it still isnt reading them and dumping the data. Im sure I am missing something so any help would be appreciated. Thanks in advance. elseif( $line=="PASSING CMP ATT YDS PCT YPA SACK TD INT LONG RATING\n" || $line=="RUSHING ATT YDS AVG LONG TD FUM\n" || $line=="RECEIVING REC YDS AVG LONG TD DROP YAC\n" || $line=="KICKING FGM FGA PCT FGSBLOCKED XPA XPM PCT XPSBLOCKED KICKOFFS TOUCHBACKS\n" || $line=="PUNTING ATT YDS AVG LONG BLOCKS IN20 TOUCHBACKS\n" || $line=="DEFENSE TOT LOSS SACK FF FREC YDS TD INT RET AVG DEFLECTIONS SAFETIES CTH ALLOW BIG HITS\n" || $line=="BLOCKING PANCAKES SACKS ALLOWED\n" ){ $category = preg_split ("/[\s,]+/", strtolower($line)); $num_categories = count($category); $num_categories--; $table="game_" . $category[0]; $variable_array[0]=$category[0] . "_player"; for($count=1; $count<$num_categories; $count++) $variable_array[$count]= $category[0] . "_" .$category[$count]; $line = @fgets ($fp, 1024); while (substr($line,0,1)!="\n"){ $line = ereg_replace ("\'","",$line); $data = preg_split ("/[\s,]+/", trim(substr($line, 30, 1000))); $$variable_array[0] = trim(substr($line, 0, 29)); for($count=1; $count<$num_categories; $count++) $$variable_array[$count] = $data[$count-1]; $query_name = "game_" . $category[0]; $$query_name = "INSERT into $table values('','$game_id','$active_team'"; for($count=0; $count<$num_categories; $count++) $$query_name = $$query_name . ",'" . trim($$variable_array[$count]) . "'"; $$query_name = $$query_name . ")"; echo $$query_name . "<BR>"; $res=mysql_query($$query_name,$db); $line = @fgets ($fp, 1024); } }
  6. Im not sure why Im getting this error but it says unexpected t encapsed and whitespace expecting ']' line 58. This script works fine on another site I used it on so Im kinda baffled. Any ideas what it could be? Bold is the line 58 Thanks in advance for($count=0;$count<$teams_division[$div];$count++){ if($count%2==0) $back = 'cccccc'; else $back = 'FFFFFF'; echo "<tr>"; [b]echo "<td width=100 align=left>' . $team_name[$old_count+$count] . '</td>";[/b] echo "<td width=15 align=center>' . $wins[$old_count + $count] . '</td>"; echo "<td width=15 align=center>' . $loses[$old_count + $count] . '</td>"; echo "<td width=15 align=center>' . $ties[$old_count + $count] . '</td>"; } $old_count += $teams_division[$div];
  7. I am trying to add some new information to an existing web page. I added the loop but it breaks after the first result. Any help would be appreciated. [code]include("header.php"); require_once("mainfile.php"); $index=1; echo "<table align=center>"; $id = Array(); $team = Array(); $name = Array(); $position = Array(); $type = Array(); $length = Array(); //Get max season $season_sql = "Select max(season) from team_schedule where league_id='1'"; $season =  mysql_query($season_sql); $season_num = mysql_fetch_array($season); $max_season = $season_num['max(season)']; //$db = @mysql_connect($dbhost,$dbuname,$dbpass); //@mysql_select_db($dbname,$db); $injury_query = "SELECT * FROM madcat_yearly_player_info WHERE injured='yes' and year='$max_season'"; $i = 0; $injury_results = mysql_query($injury_query) or die(mysql_error()); while($result = mysql_fetch_array($injury_results)) { $i++; $current_player_id = $result['id']; $current_team = $result['team']; $player_query = "SELECT * FROM madcat_players WHERE id='$current_player_id'"; $player_results = mysql_query($player_query) or die(mysql_error()); while($result2=mysql_fetch_array($player_results)){ $player_name = $result2['name']; $player_pos = $result2['pos']; $id[$i] = $current_player_id; $team[$i] = strtolower($current_team); $name[$i] = $player_name; $position[$i] = $player_pos; $injury_query = "SELECT * FROM weekly_injuries WHERE player_name='$name[$i]'"; $injury_results = mysql_query($injury_query) or die (mysql_error()); while($result1=mysql_fetch_array($injury_results)){ $injury_type = $result1['injury_type']; $injury_length = $result1['injury_length']; $type[$i] = $injury_type; $length[$i] = $injury_length; echo "<tr><td align=center class=injuryreport><img src=../../images/smalllogos/{$team[$i]}.gif></td><td align=center class=injuryreport>{$position[$i]}</td><td align-center class=injuryreport>{$name[$i]}</td><td align=center class=injuryreport>{$type[$i]}</td><td align=center class=injuryreport>{$length[$i]}</td></tr>"; } } } echo "</table>"; include("footer.php");[/code] Here is exactly what I added to the above script when it broke. [code]$injury_query = "SELECT * FROM weekly_injuries WHERE player_name='$name[$i]'"; $injury_results = mysql_query($injury_query) or die (mysql_error()); while($result1=mysql_fetch_array($injury_results)){ $injury_type = $result1['injury_type']; $injury_length = $result1['injury_length']; $type[$i] = $injury_type; $length[$i] = $injury_length; echo "<tr><td align=center class=injuryreport><img src=../../images/smalllogos/{$team[$i]}.gif></td><td align=center class=injuryreport>{$position[$i]}</td><td align-center class=injuryreport>{$name[$i]}</td><td align=center class=injuryreport>{$type[$i]}</td><td align=center class=injuryreport>{$length[$i]}</td></tr>"; } [/code] In the echo I just added the variables. Again any help would be greatly appreciated.
  8. OK I am trying to update this page to add more depth to it. In order to do that I needed to change certain tables and fields it looks for. I finished that and suddenly the tooltips stop working. Any ideas would be greatly appreciated. [code]<?php     include("/home/jwer78/public_html/bhfl/domain.php");     include("/home/jwer78/public_html/bhfl/dbConfig.php");     if($team=="freeagents"){         $view_page="season";         $used=6;         $open=0;         $link[0]=$DOMAIN . "/history/standings.php?league_id=1&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;sid=$sid";         $text[0]="Standings";         $link[1]=$DOMAIN . "/season/powerrankings.php?sid=$sid";         $text[1]="Power Rankings";         $link[2]=$DOMAIN . "/stats/index.php?league_id=1&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;sid=$sid";         $text[2]="Individual Stats";         $link[3]=$DOMAIN . "/stats/index.php?league_id=1&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;category=passing&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;order=passing_yds&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;group=team&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;sid=$sid";         $text[3]="Team Stats";         $link[4]=$DOMAIN . "/rosters/index.php?team=fa&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;sid=$sid";         $text[4]="Free Agents";         $link[5]=$DOMAIN . "/season/injuries.php?sid=$sid";         $text[5]="Injuries";     }     else{         $view_page="gm";         $used=4;         $open=2;         $link[0]=$DOMAIN . "/gm/gms.php";         $text[0]="General Managers";         $link[1]=$DOMAIN . "/gm/rosters.php";         $text[1]="Rosters";         $link[2]=$DOMAIN . "/gm/salarycap.php";         $text[2]="Salary Cap";         $link[3]=$DOMAIN . "/gm/draftpicks.php";         $text[3]="Draft Picks";     }     echo "<link href=\"roster.css\" rel=\"stylesheet\" type=\"text/css\" />";     echo "<div id=\"overDiv\" style=\"position:absolute; visibility:hide;z-index:1;\"></div>";     echo "<script language=\"JavaScript\" src=\"overlib.js\"></script>"; echo "<font color=black face=verdana>";     // CONNECT TO DATABASE     $db = @mysql_connect(localhost,$username,$password) or die("<html><head><body bgcolor=$bgcolor alink=$bglinkcolor vlink=$bglinkcolor link=$bglinkcolor><br><br><br><center><font color=FFFFFF face=vernada size=6>Database Error</font></center></body></html>");     @mysql_select_db($database,$db) or die("<html><head><body bgcolor=$bgcolor alink=$bglinkcolor vlink=$bglinkcolor link=$bglinkcolor><br><br><br><center><font color=FFFFFF face=vernada size=6>Database Error</font></center></body></html>");     if($team!="freeagents" && $team!="all"){         $mysql_query = "SELECT * FROM team WHERE league_id=1 and nick_name='$team'";         $res=mysql_query($mysql_query,$db);         $tgid=mysql_result($res,0,"tgid");         $longteam=mysql_result($res,0,"city_name") . " " . mysql_result($res,0,"nick_name");     }     if($team=="all"){ $mysql_query = "SELECT tgid FROM players_madden ORDER BY povr DESC, page, pawr DESC";     $res=mysql_query($mysql_query,$db);     $num_rows = mysql_num_rows($res);       }     if($team=="freeagents"){ $mysql_query = "SELECT tgid FROM players_madden WHERE tgid='1009' ORDER BY povr DESC, pawr";     $res=mysql_query($mysql_query,$db);     $num_rows = mysql_num_rows($res); }     if ($team!="all" && $team!="freeagents") {$mysql_query = "SELECT tgid FROM players_madden WHERE tgid='$tgid' ORDER BY povr DESC, pawr";     $res=mysql_query($mysql_query,$db);     $num_rows = mysql_num_rows($res); } echo  "<table align=center><tr><td align=center><img src=../themes/images/logo.jpg></td></tr></table><br>";     if($team=="all") echo "<center><font size=6 face=vernada color=ffffff><b>All Players</b><br><font size=2 color=ffffff>TOTAL PLAYERS: $num_rows <center><BR>";     if($team=="freeagents") echo "<center><font size=6 face=vernada color=ffffff><b>Free Agents</b><br><font size=2 color=ffffff>TOTAL PLAYERS: $num_rows <center><BR>";     if ($team!="all" && $team!="freeagents"){ echo "<center><font size=6 face=vernada color=ffffff><img src=../../images/team_logo/$team.gif><br><font size=2 color=ffffff>TOTAL PLAYERS: $num_rows <center><BR>";  } echo "<table align=center cellspacing=0 cellpadding=0><tr>";         $mysql_query = "SELECT * FROM team WHERE league_id=1 and tgid<33 ORDER BY nick_name ASC";         $res=mysql_query($mysql_query,$db);         $num_rows = mysql_num_rows($res);         for($count=0;$count<$num_rows;$count++){         $team_nick[$count] = mysql_result($res,$count,"nick_name");       }         /*$team_query = "SELECT * FROM team WHERE league_id=1 ORDER BY nick_name ASC";         $team_resesult = mysql_query($team_query);         while($team_array=mysql_fetch_array($team_result)){         $team_nick=$team_array['nick_name']; */ for($count=0;$count<$num_rows;$count++){ echo  "<td><a href=\"http://bhfl.maddenfootballleagues.com/new_rosters/index.php?team=$team_nick[$count]\"><img src=../images/new_il_icons/$team_nick[$count].gif target=blank></a></td>"; } echo "</tr></table>"; $positions=array('LT','LG','C','RG','RT','WR','TE','TE','WR','HB','QB','FB','LE','DT','DT','RE','LOLB','MLB','ROLB','CB','SS','FS','CB','K','P');     $tablerows=array('5','5','5','5','5','4','4','4','4','3','3','3','4','4','4','4','3','3','3','4','4','4','4','2','2');     $total_pos=count($positions);     $table=0;     $last_tablerows=0;     echo "<center><font size=6 face=vernada color=ffffff><b>OFFENSE</b><font size=4><br><br>";     for($pos_num=0;$pos_num<$total_pos;$pos_num++){         $width=100/$tablerows[$table] . "%";         $pos_tmp=$positions[$pos_num];         if($tablerows[$pos_num]!=$last_tablerows){             if($pos_tmp=="LE"){                 echo "\n                </tr>\n            </table>\n        </td>\n    </tr>\n</table>";                 echo "<br><center><font size=6 face=vernada color=ffffff><b>DEFENSE</b><font size=4><br><br>";                 echo "<table width=800 bgcolor=000000 cellpadding=1 cellspacing=0>\n    <tr>\n        <td valign=top width=100% height=100%>\n            <table bgcolor=white width=100% height=100%>\n                <tr>\n                    <td valign=top width=$width height=100%>";             }             elseif($pos_tmp=="K"){                 echo "\n                </tr>\n            </table>\n        </td>\n    </tr>\n</table>";                 echo "<br><center><font size=6 face=vernada><b>SPECIAL TEAMS</b><font size=4><br><br>";                 echo "<table width=800 bgcolor=000000 cellpadding=1 cellspacing=0>\n    <tr>\n        <td valign=top width=100% height=100%>\n            <table bgcolor=white width=100% height=100%>\n                <tr>\n                    <td valign=top width=$width height=100%>";             }             else{                 if($pos_num!=0) echo "\n                </tr>\n            </table>\n        </td>\n    </tr>\n</table>";                 echo "<table width=800 bgcolor=000000 cellpadding=1 cellspacing=0>\n    <tr>\n        <td valign=top width=100% height=100%>\n            <table bgcolor=white width=100% height=100%>\n                <tr>\n                    <td valign=top width=$width height=100%>";             }         }         else echo "\n                    <td valign=top width=$width height=100%>";         echo "\n                        <table width=100% bgcolor=000000 cellpaadding=1 cellspacing=0 width=100% height=100%>\n                            <tr>\n                                <td valign=top width=100% height=100% bgcolor=white>";         echo "\n                                    <table bgcolor=black width=100% height=100% cellpadding=0 cellspacing=1>";         echo "\n                                        <tr>\n                                            <td valign=top align=center width=100% bgcolor=white><font color=black face=verdana>";         echo "<b>$pos_tmp</b><br><br>"; //        echo "\n                                            </td>\n                                        </tr>"; if ($pos_tmp=="QB"){ $ppos_tmp=0; } if ($pos_tmp=="HB"){ $ppos_tmp=1; } if ($pos_tmp=="FB"){ $ppos_tmp=2; } if ($pos_tmp=="TE"){ $ppos_tmp=4; } if ($pos_tmp=="WR"){ $ppos_tmp=3; } if ($pos_tmp=="LT"){ $ppos_tmp=5; } if ($pos_tmp=="LG"){ $ppos_tmp=6; } if ($pos_tmp=="C"){ $ppos_tmp=7; } if ($pos_tmp=="RG"){ $ppos_tmp=8; } if ($pos_tmp=="RT"){ $ppos_tmp=9; } if ($pos_tmp=="LE"){ $ppos_tmp=10; } if ($pos_tmp=="RE"){ $ppos_tmp=11; } if ($pos_tmp=="DT"){ $ppos_tmp=12; } if ($pos_tmp=="LOLB"){ $ppos_tmp=13; } if ($pos_tmp=="MLB"){ $ppos_tmp=14; } if ($pos_tmp=="ROLB"){ $ppos_tmp=15; } if ($pos_tmp=="CB"){ $ppos_tmp=16; } if ($pos_tmp=="SS"){ $ppos_tmp=18; } if ($pos_tmp=="FS"){ $ppos_tmp=17; } if ($pos_tmp=="K"){ $ppos_tmp=19; } if ($pos_tmp=="P"){ $ppos_tmp=20; }         if($team=="all") $mysql_query = "SELECT * FROM players_madden WHERE and ppos='$ppos_tmp' ORDER BY povr DESC, page, pawr DESC";         else $mysql_query = "SELECT * FROM players_madden WHERE tgid='$tgid' and ppos='$ppos_tmp' ORDER BY povr DESC, pawr DESC";         $res=mysql_query($mysql_query,$db);         $num_rows = mysql_num_rows($res);         ${$positions[$pos_num]}++;         if($positions[$pos_num]=="WR" || $positions[$pos_num]=="TE" || $positions[$pos_num]=="DT" || $positions[$pos_num]=="CB") $val=2;         else $val=1;         if(${$positions[$pos_num]}==2) $start=1;         else $start=0;         for($count=$start;$count<$num_rows;$count+=$val){             $pos=mysql_result($res,$count,"ppos");             $FNAME=mysql_result($res,$count,"pfna");             $LNAME=mysql_result($res,$count,"plna");             $bon=mysql_result($res,$count,"psbo");             $tot=mysql_result($res,$count,"ptsa");             $ovr=mysql_result($res,$count,"povr");             //$team_query=strtoupper(mysql_result($res,$count,"team"));             $sal= mysql_result($res,$count,"psa0");             $age=mysql_result($res,$count,"page");             $wgt=mysql_result($res,$count,"pwgt") . "lbs";             $hgt=mysql_result($res,$count,"phgt");             $spd=mysql_result($res,$count,"pspd");             $str=mysql_result($res,$count,"pstr");             $acc=mysql_result($res,$count,"pacc");             $agi=mysql_result($res,$count,"pagi");             $tha=mysql_result($res,$count,"ptha");             $thp=mysql_result($res,$count,"pthp");             $btk=mysql_result($res,$count,"pbtk");             $car=mysql_result($res,$count,"pcar");             $kac=mysql_result($res,$count,"pkac");             $kpw=mysql_result($res,$count,"pkpr");             $pbk=mysql_result($res,$count,"ppbk");             $rbk=mysql_result($res,$count,"prbk");             $sta=mysql_result($res,$count,"psta");             $awr=mysql_result($res,$count,"pawr");             $tgh=mysql_result($res,$count,"ptgh");             $jmp=mysql_result($res,$count,"pjmp");             $inj=mysql_result($res,$count,"pinj");             $yrl=mysql_result($res,$count,"pcon");             $cth=mysql_result($res,$count,"pcth");             $tak=mysql_result($res,$count,"ptak");             $kr=mysql_result($res,$count,"pkrt");            // $cur_inj=mysql_result($res,$count,"cur_inj");             $number=mysql_result($res,$count,"pjen");          /*    if($number==0) $number="";             else $number="<font size=2 face=verdana>#$number</font>";             if($cur_inj==0) $cur_inj="";             else $cur_inj="<img src=injured.gif>";             $season_sql = "Select max(season) from team_schedule where league_id='1'"; $season =  mysql_query($season_sql); $season_num = mysql_fetch_array($season); $max_season_num = $season_num['max(season)'];  */        /* $mysql_query = "SELECT * FROM madcat_players WHERE name='$FNAME $LNAME'";         $player=mysql_query($mysql_query);         $player_res = mysql_fetch_array($player);         $player_first_season = $player_res['first_year'];         if($player_first_season==$max_season_num){          $rookie="1";          }else{         $rookie="0";          }        */           echo "<a href=\"javascript:void(0);\" onMouseOver=\"overlib('";            if($pos=="LT" || $pos=="LG" || $pos=="C" || $pos=="RG" || $pos=="RT")                 echo "<table><tr><td align=left colspan=6><font size=2><b>$FNAME $LNAME<sup>$number</sup><br>Salary: $sal/$yrl yrs.<br>Bonus:$bon<br>Total=$tot</b></font></td><td colspan=7><font size=2><b>OVR $ovr<br>AGE: $age<br>Height: $hgt<br>Weight: $wgt</b></font></td></tr><tr><td align=center><font size=2>SPD<td align=center><font size=2><B>STR</b><td align=center><font size=2>ACC<td align=center><font size=2>AGI<td align=center><font size=2>THA<td align=center><font size=2>THP<td align=center><font size=2>BTK<td align=center><font size=2>CAR<td align=center><font size=2>CTH<td align=center><font size=2>KR</tr><tr><td align=center><font size=2>$spd<td align=center><font size=2><B>$str</b><td align=center><font size=2>$acc<td align=center><font size=2>$agi<td align=center><font size=2>$tha<td align=center><font size=2>$thp<td align=center><font size=2>$btk<td align=center><font size=2>$car<td align=center><font size=2>$cth<td align=center><font size=2>$kr</tr><tr><td align=center><font size=2>KAC<td align=center><font size=2>KPW<td align=center><font size=2><B>PBK</b><td align=center><font size=2><B>RBK</b><td align=center><font size=2>STA<td align=center><font size=2>TAK<td align=center><font size=2><B>AWR</b><td align=center><font size=2>TGH<td align=center><font size=2>JMP<td align=center><font size=2>INJ</tr><tr><td align=center><font size=2>$kac<td align=center><font size=2>$kpw<td align=center><font size=2><b>$pbk</b><td align=center><font size=2><B>$rbk</b><td align=center><font size=2>$sta<td align=center><font size=2>$tak<td align=center><font size=2><B>$awr</b><td align=center><font size=2>$tgh<td align=center><font size=2>$jmp<td align=center><font size=2>$inj</tr></table>";             elseif($pos=="WR")                 echo "<table><tr><td align=left colspan=6><font size=2>$cur_inj<b>$FNAME $LNAME<sup>$number</sup><br>Salary: $sal/$yrl yrs.<br>Bonus:$bon<br>Total=$tot</b></font></td><td colspan=7><font size=2><b>OVR $ovr<br>AGE: $age<br>Height: $hgt<br>Weight: $wgt</b></font></td></tr><tr><td align=center><font size=2><B>SPD</b><td align=center><font size=2>STR<td align=center><font size=2><B>ACC</b><td align=center><font size=2>AGI<td align=center><font size=2>THA<td align=center><font size=2>THP<td align=center><font size=2>BTK<td align=center><font size=2>CAR<td align=center><font size=2><B>CTH</b><td align=center><font size=2>KR</tr><tr><td align=center><font size=2><B>$spd</b><td align=center><font size=2>$str<td align=center><font size=2><B>$acc</b><td align=center><font size=2>$agi<td align=center><font size=2>$tha<td align=center><font size=2>$thp<td align=center><font size=2>$btk<td align=center><font size=2>$car<td align=center><font size=2><B>$cth</b><td align=center><font size=2>$kr</tr><tr><td align=center><font size=2>KAC<td align=center><font size=2>KPW<td align=center><font size=2>PBK<td align=center><font size=2>RBK<td align=center><font size=2>STA<td align=center><font size=2>TAK<td align=center><font size=2><B>AWR</b><td align=center><font size=2>TGH<td align=center><font size=2>JMP<td align=center><font size=2>INJ</tr><tr><td align=center><font size=2>$kac<td align=center><font size=2>$kpw<td align=center><font size=2>$pbk<td align=center><font size=2>$rbk<td align=center><font size=2>$sta<td align=center><font size=2>$tak<td align=center><font size=2><B>$awr</b><td align=center><font size=2>$tgh<td align=center><font size=2>$jmp<td align=center><font size=2>$inj</tr></table>";             elseif($pos=="TE")                 echo "<table><tr><td align=left colspan=6><font size=2>$cur_inj<b>$FNAME $LNAME<sup>$number</sup><br>Salary: $sal/$yrl yrs.<br>Bonus:$bon<br>Total=$tot</b></font></td><td colspan=7><font size=2><b>OVR $ovr<br>AGE: $age<br>Height: $hgt<br>Weight: $wgt</b></font></td></tr><tr><td align=center><font size=2>SPD<td align=center><font size=2>STR<td align=center><font size=2>ACC<td align=center><font size=2>AGI<td align=center><font size=2>THA<td align=center><font size=2>THP<td align=center><font size=2>BTK<td align=center><font size=2>CAR<td align=center><font size=2><B>CTH</b><td align=center><font size=2>KR</tr><tr><td align=center><font size=2>$spd<td align=center><font size=2>$str<td align=center><font size=2>$acc<td align=center><font size=2>$agi<td align=center><font size=2>$tha<td align=center><font size=2>$thp<td align=center><font size=2>$btk<td align=center><font size=2>$car<td align=center><font size=2><B>$cth</b><td align=center><font size=2>$kr</tr><tr><td align=center><font size=2>KAC<td align=center><font size=2>KPW<td align=center><font size=2><B>PBK</b><td align=center><font size=2><B>RBK</b><td align=center><font size=2>STA<td align=center><font size=2>TAK<td align=center><font size=2><B>AWR</b><td align=center><font size=2>TGH<td align=center><font size=2>JMP<td align=center><font size=2>INJ</tr><tr><td align=center><font size=2>$kac<td align=center><font size=2>$kpw<td align=center><font size=2><B>$pbk</b><td align=center><font size=2><B>$rbk</b><td align=center><font size=2>$sta<td align=center><font size=2>$tak<td align=center><font size=2><B>$awr</b><td align=center><font size=2>$tgh<td align=center><font size=2>$jmp<td align=center><font size=2>$inj</tr></table>";             elseif($pos=="HB")                 echo "<table><tr><td align=left colspan=6><font size=2>$cur_inj<b>$FNAME $LNAME<sup>$number</sup><br>Salary: $sal/$yrl yrs.<br>Bonus:$bon<br>Total=$tot</b></font></td><td colspan=7><font size=2><b>OVR $ovr<br>AGE: $age<br>Height: $hgt<br>Weight: $wgt</b></font></td></tr><tr><td align=center><font size=2><B>SPD</b><td align=center><font size=2>STR<td align=center><font size=2>ACC<td align=center><font size=2>AGI<td align=center><font size=2>THA<td align=center><font size=2>THP<td align=center><font size=2><B>BTK</b><td align=center><font size=2><B>CAR</b><td align=center><font size=2>CTH<td align=center><font size=2>KR</tr><tr><td align=center><font size=2><B>$spd</b><td align=center><font size=2>$str<td align=center><font size=2>$acc<td align=center><font size=2>$agi<td align=center><font size=2>$tha<td align=center><font size=2>$thp<td align=center><font size=2><B>$btk</b><td align=center><font size=2><B>$car</b><td align=center><font size=2>$cth<td align=center><font size=2>$kr</tr><tr><td align=center><font size=2>KAC<td align=center><font size=2>KPW<td align=center><font size=2>PBK<td align=center><font size=2>RBK<td align=center><font size=2>STA<td align=center><font size=2>TAK<td align=center><font size=2><B>AWR</b><td align=center><font size=2>TGH<td align=center><font size=2>JMP<td align=center><font size=2>INJ</tr><tr><td align=center><font size=2>$kac<td align=center><font size=2>$kpw<td align=center><font size=2>$pbk<td align=center><font size=2>$rbk<td align=center><font size=2>$sta<td align=center><font size=2>$tak<td align=center><font size=2><B>$awr</b><td align=center><font size=2>$tgh<td align=center><font size=2>$jmp<td align=center><font size=2>$inj</tr></table>";             elseif($pos=="QB")                 echo "<table><tr><td align=left colspan=6><font size=2>$cur_inj<b>$FNAME $LNAME<sup>$number</sup><br>Salary: $sal/$yrl yrs.<br>Bonus:$bon<br>Total=$tot</b></font></td><td colspan=7><font size=2><b>OVR $ovr<br>AGE: $age<br>Height: $hgt<br>Weight: $wgt</b></font></td></tr><tr><td align=center><font size=2><B>SPD</b><td align=center><font size=2>STR<td align=center><font size=2>ACC<td align=center><font size=2>AGI<td align=center><font size=2><B>THA</b><td align=center><font size=2><B>THP</b><td align=center><font size=2>BTK<td align=center><font size=2>CAR<td align=center><font size=2>CTH<td align=center><font size=2>KR</tr><tr><td align=center><font size=2><B>$spd</b><td align=center><font size=2>$str<td align=center><font size=2>$acc<td align=center><font size=2>$agi<td align=center><font size=2><B>$tha</b><td align=center><font size=2><B>$thp</b><td align=center><font size=2>$btk<td align=center><font size=2>$car<td align=center><font size=2>$cth<td align=center><font size=2>$kr</tr><tr><td align=center><font size=2>KAC<td align=center><font size=2>KPW<td align=center><font size=2>PBK<td align=center><font size=2>RBK<td align=center><font size=2>STA<td align=center><font size=2>TAK<td align=center><font size=2><B>AWR</b><td align=center><font size=2>TGH<td align=center><font size=2>JMP<td align=center><font size=2>INJ</tr><tr><td align=center><font size=2>$kac<td align=center><font size=2>$kpw<td align=center><font size=2>$pbk<td align=center><font size=2>$rbk<td align=center><font size=2>$sta<td align=center><font size=2>$tak<td align=center><font size=2><B>$awr</b><td align=center><font size=2>$tgh<td align=center><font size=2>$jmp<td align=center><font size=2>$inj</tr></table>";             elseif($pos=="FB")                 echo "<table><tr><td align=left colspan=6><font size=2>$cur_inj<b>$FNAME $LNAME<sup>$number</sup><br>Salary: $sal/$yrl yrs.<br>Bonus:$bon<br>Total=$tot</b></font></td><td colspan=7><font size=2><b>OVR $ovr<br>AGE: $age<br>Height: $hgt<br>Weight: $wgt</b></font></td></tr><tr><td align=center><font size=2>SPD<td align=center><font size=2>STR<td align=center><font size=2>ACC<td align=center><font size=2>AGI<td align=center><font size=2>THA<td align=center><font size=2>THP<td align=center><font size=2><B>BTK</b><td align=center><font size=2><B>CAR</b><td align=center><font size=2>CTH<td align=center><font size=2>KR</tr><tr><td align=center><font size=2>$spd<td align=center><font size=2>$str<td align=center><font size=2>$acc<td align=center><font size=2>$agi<td align=center><font size=2>$tha<td align=center><font size=2>$thp<td align=center><font size=2><B>$btk</b><td align=center><font size=2><B>$car</b><td align=center><font size=2>$cth<td align=center><font size=2>$kr</tr><tr><td align=center><font size=2>KAC<td align=center><font size=2>KPW<td align=center><font size=2>PBK<td align=center><font size=2><B>RBK</b><td align=center><font size=2>STA<td align=center><font size=2>TAK<td align=center><font size=2><B>AWR</b><td align=center><font size=2>TGH<td align=center><font size=2>JMP<td align=center><font size=2>INJ</tr><tr><td align=center><font size=2>$kac<td align=center><font size=2>$kpw<td align=center><font size=2>$pbk<td align=center><font size=2><B>$rbk</b><td align=center><font size=2>$sta<td align=center><font size=2>$tak<td align=center><font size=2><B>$awr</b><td align=center><font size=2>$tgh<td align=center><font size=2>$jmp<td align=center><font size=2>$inj</tr></table>";             elseif($pos=="LE" || $pos=="DT" || $pos=="RE")                 echo "<table><tr><td align=left colspan=6><font size=2>$cur_inj<b>$FNAME $LNAME<sup>$number</sup><br>Salary: $sal/$yrl yrs.<br>Bonus:$bon<br>Total=$tot</b></font></td><td colspan=7><font size=2><b>OVR $ovr<br>AGE: $age<br>Height: $hgt<br>Weight: $wgt</b></font></td></tr><tr><td align=center><font size=2><B>SPD</b><td align=center><font size=2><B>STR</b><td align=center><font size=2>ACC<td align=center><font size=2>AGI<td align=center><font size=2>THA<td align=center><font size=2>THP<td align=center><font size=2>BTK<td align=center><font size=2>CAR<td align=center><font size=2>CTH<td align=center><font size=2>KR</tr><tr><td align=center><font size=2><B>$spd</b><td align=center><font size=2><B>$str</b><td align=center><font size=2>$acc<td align=center><font size=2>$agi<td align=center><font size=2>$tha<td align=center><font size=2>$thp<td align=center><font size=2>$btk<td align=center><font size=2>$car<td align=center><font size=2>$cth<td align=center><font size=2>$kr</tr><tr><td align=center><font size=2>KAC<td align=center><font size=2>KPW<td align=center><font size=2>PBK<td align=center><font size=2>RBK<td align=center><font size=2>STA<td align=center><font size=2><B>TAK</b><td align=center><font size=2><B>AWR</b><td align=center><font size=2>TGH<td align=center><font size=2>JMP<td align=center><font size=2>INJ</tr><tr><td align=center><font size=2>$kac<td align=center><font size=2>$kpw<td align=center><font size=2>$pbk<td align=center><font size=2>$rbk<td align=center><font size=2>$sta<td align=center><font size=2><B>$tak</b><td align=center><font size=2><B>$awr</b><td align=center><font size=2>$tgh<td align=center><font size=2>$jmp<td align=center><font size=2>$inj</tr></table>";             elseif($pos=="LOLB" || $pos=="MLB" || $pos=="ROLB")                 echo "<table><tr><td align=left colspan=6><font size=2>$cur_inj<b>$FNAME $LNAME<sup>$number</sup><br>Salary: $sal/$yrl yrs.<br>Bonus:$bon<br>Total=$tot</b></font></td><td colspan=7><font size=2><b>OVR $ovr<br>AGE: $age<br>Height: $hgt<br>Weight: $wgt</b></font></td></tr><tr><td align=center><font size=2><B>SPD</b><td align=center><font size=2><B>STR</b><td align=center><font size=2>ACC<td align=center><font size=2>AGI<td align=center><font size=2>THA<td align=center><font size=2>THP<td align=center><font size=2>BTK<td align=center><font size=2>CAR<td align=center><font size=2>CTH<td align=center><font size=2>KR</tr><tr><td align=center><font size=2><B>$spd</b><td align=center><font size=2><B>$str</b><td align=center><font size=2>$acc<td align=center><font size=2>$agi<td align=center><font size=2>$tha<td align=center><font size=2>$thp<td align=center><font size=2>$btk<td align=center><font size=2>$car<td align=center><font size=2>$cth<td align=center><font size=2>$kr</tr><tr><td align=center><font size=2>KAC<td align=center><font size=2>KPW<td align=center><font size=2>PBK<td align=center><font size=2>RBK<td align=center><font size=2>STA<td align=center><font size=2><B>TAK</b><td align=center><font size=2><B>AWR</b><td align=center><font size=2>TGH<td align=center><font size=2>JMP<td align=center><font size=2>INJ</tr><tr><td align=center><font size=2>$kac<td align=center><font size=2>$kpw<td align=center><font size=2>$pbk<td align=center><font size=2>$rbk<td align=center><font size=2>$sta<td align=center><font size=2><B>$tak</b><td align=center><font size=2><B>$awr</b><td align=center><font size=2>$tgh<td align=center><font size=2>$jmp<td align=center><font size=2>$inj</tr></table>";             elseif($pos=="CB")                 echo "<table><tr><td align=left colspan=6><font size=2>$cur_inj<b>$FNAME $LNAME<sup>$number</sup><br>Salary: $sal/$yrl yrs.<br>Bonus:$bon<br>Total=$tot</b></font></td><td colspan=7><font size=2><b>OVR $ovr<br>AGE: $age<br>Height: $hgt<br>Weight: $wgt</b></font></td></tr><tr><td align=center><font size=2><B>SPD</b><td align=center><font size=2>STR<td align=center><font size=2><B>ACC</b><td align=center><font size=2>AGI<td align=center><font size=2>THA<td align=center><font size=2>THP<td align=center><font size=2>BTK<td align=center><font size=2>CAR<td align=center><font size=2><B>CTH</b><td align=center><font size=2>KR</tr><tr><td align=center><font size=2><B>$spd</b><td align=center><font size=2>$str<td align=center><font size=2><B>$acc</b><td align=center><font size=2>$agi<td align=center><font size=2>$tha<td align=center><font size=2>$thp<td align=center><font size=2>$btk<td align=center><font size=2>$car<td align=center><font size=2><B>$cth</b><td align=center><font size=2>$kr</tr><tr><td align=center><font size=2>KAC<td align=center><font size=2>KPW<td align=center><font size=2>PBK<td align=center><font size=2>RBK<td align=center><font size=2>STA<td align=center><font size=2>TAK<td align=center><font size=2><B>AWR</b><td align=center><font size=2>TGH<td align=center><font size=2>JMP<td align=center><font size=2>INJ</tr><tr><td align=center><font size=2>$kac<td align=center><font size=2>$kpw<td align=center><font size=2>$pbk<td align=center><font size=2>$rbk<td align=center><font size=2>$sta<td align=center><font size=2>$tak<td align=center><font size=2><B>$awr</b><td align=center><font size=2>$tgh<td align=center><font size=2>$jmp<td align=center><font size=2>$inj</tr></table>";             elseif($pos=="SS" || $pos=="FS")                 echo "<table><tr><td align=left colspan=6><font size=2>$cur_inj<b>$FNAME $LNAME<sup>$number</sup><br>Salary: $sal/$yrl yrs.<br>Bonus:$bon<br>Total=$tot</b></font></td><td colspan=7><font size=2><b>OVR $ovr<br>AGE: $age<br>Height: $hgt<br>Weight: $wgt</b></font></td></tr></tr><tr><td align=center><font size=2><B>SPD</b><td align=center><font size=2>STR<td align=center><font size=2>ACC<td align=center><font size=2>AGI<td align=center><font size=2>THA<td align=center><font size=2>THP<td align=center><font size=2>BTK<td align=center><font size=2>CAR<td align=center><font size=2><B>CTH</b><td align=center><font size=2>KR</tr><tr><td align=center><font size=2><B>$spd</b><td align=center><font size=2>$str<td align=center><font size=2>$acc<td align=center><font size=2>$agi<td align=center><font size=2>$tha<td align=center><font size=2>$thp<td align=center><font size=2>$btk<td align=center><font size=2>$car<td align=center><font size=2><B>$cth</b><td align=center><font size=2>$kr</tr><tr><td align=center><font size=2>KAC<td align=center><font size=2>KPW<td align=center><font size=2>PBK<td align=center><font size=2>RBK<td align=center><font size=2>STA<td align=center><font size=2><B>TAK</b><td align=center><font size=2><B>AWR</b><td align=center><font size=2>TGH<td align=center><font size=2>JMP<td align=center><font size=2>INJ</tr><tr><td align=center><font size=2>$kac<td align=center><font size=2>$kpw<td align=center><font size=2>$pbk<td align=center><font size=2>$rbk<td align=center><font size=2>$sta<td align=center><font size=2><B>$tak</b><td align=center><font size=2><B>$awr</b><td align=center><font size=2>$tgh<td align=center><font size=2>$jmp<td align=center><font size=2>$inj</tr></table>";             elseif($pos=="K" || $pos=="P")                 echo "<table><tr><td align=left colspan=6><font size=2>$cur_inj<b>$FNAME $LNAME<sup>$number</sup><br>Salary: $sal/$yrl yrs.<br>Bonus:$bon<br>Total=$tot</b></font></td><td colspan=7><font size=2><b>OVR $ovr<br>AGE: $age<br>Height: $hgt<br>Weight: $wgt</b></font></td></tr><tr><td align=center><font size=2>SPD<td align=center><font size=2>STR<td align=center><font size=2>ACC<td align=center><font size=2>AGI<td align=center><font size=2>THA<td align=center><font size=2>THP<td align=center><font size=2>BTK<td align=center><font size=2>CAR<td align=center><font size=2>CTH<td align=center><font size=2>KR</tr><tr><td align=center><font size=2>$spd<td align=center><font size=2>$str<td align=center><font size=2>$acc<td align=center><font size=2>$agi<td align=center><font size=2>$tha<td align=center><font size=2>$thp<td align=center><font size=2>$btk<td align=center><font size=2>$car<td align=center><font size=2>$cth<td align=center><font size=2>$kr</tr><tr><td align=center><font size=2><B>KAC</b><td align=center><font size=2><B>KPW</b><td align=center><font size=2>PBK<td align=center><font size=2>RBK<td align=center><font size=2>STA<td align=center><font size=2><B>TAK</b><td align=center><font size=2><B>AWR</b><td align=center><font size=2>TGH<td align=center><font size=2>JMP<td align=center><font size=2>INJ</tr><tr><td align=center><font size=2><B>$kac</b><td align=center><font size=2><B>$kpw</b><td align=center><font size=2>$pbk<td align=center><font size=2>$rbk<td align=center><font size=2>$sta<td align=center><font size=2><B>$tak</b><td align=center><font size=2><B>$awr</b><td align=center><font size=2>$tgh<td align=center><font size=2>$jmp<td align=center><font size=2>$inj</tr></table>";             echo "', CENTER)\" onMouseOut=\"nd()\" STYLE=\"text-decoration: none\">";             if($hold=="Yes") echo "<font color=green face=verdana size=2>";             elseif($yrl==0 && $team!="Free Agents") echo "<font color=orange face=verdana size=2>";             if($cur_inj=="<img src=injured.gif>") echo "<font co
  9. Hmm. Maybe its something with the versions of php or something. $Player will echo but if I echo the team, position, or bid nothing will show. May have to go back to square one I guess. Thanks for taking the time to help though, very much appreciate it.
  10. This will be a bit long but here you go. Hopefully it helps. [code]Array (     [id] => 1     [Team] => Cowboys     [Player] => Chris Redman     [Position] => QB     [Years] => 2     [Thousand] => 0     [Million] => 1.2     [Bthousand] => .100     [Bmillion] => 0     [Fbid] => 0.7     [ip] => xx.xx.xx.xx     [user_name] => thecommish ) Array (     [id] => 2     [Team] => Lions     [Player] => Chris Redman     [Position] => QB     [Years] => 2     [Thousand] => 0     [Million] => 2.0     [Bthousand] => .500     [Bmillion] => 0     [Fbid] => 1.5     [ip] => xx.xx.xx.xx     [user_name] => thecommish ) [/code] There others on another player for test purposes but I believe this will give you what you need.
  11. Ok I echoed the $player here is the results [code]Resource id #291 Chris Redman Chris Redman Chris Redman Jonathan Goodwin Jonathan Goodwin [/code] Shows there is data there...
  12. Meaning is there actually data present? Yes there is, I was finally getting the data how I originally coded it but it wasnt looping to get the next player, it was only returning the first player.
  13. Nope, still nothing and still no error.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.