jwer78

Small problem with a script

jwer78 replied to jwer78's topic in PHP Coding Help

Yes it works in sqlyog, it actually works with or without the slash I gave sprintf a try and it still did not work.

December 5, 2007
9 replies

Small problem with a script

jwer78 replied to jwer78's topic in PHP Coding Help

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

December 5, 2007
9 replies

Small problem with a script

jwer78 posted a topic in PHP Coding Help

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 . " \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 . " \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.

December 5, 2007
9 replies

Check if an Array is Null

jwer78 posted a topic in PHP Coding Help

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"; }

November 13, 2007
2 replies

[SOLVED] Need a little help with modifying this script

jwer78 replied to jwer78's topic in PHP Coding Help

NM guys I got it. Thanks

August 20, 2007
1 reply

[SOLVED] Need a little help with modifying this script

jwer78 posted a topic in PHP Coding Help

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 . " "; $res=mysql_query($$query_name,$db); $line = @fgets ($fp, 1024); } }

August 20, 2007
1 reply

Unexpect T encapsed and whitespace

jwer78 posted a topic in PHP Coding Help

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];

August 12, 2007
9 replies

Loop Breaks when I add some new code....

jwer78 posted a topic in PHP Coding Help

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.

July 6, 2006

overlib.js breaks when I change queries?

jwer78 posted a topic in PHP Coding Help

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;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;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;category=passing&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;group=team&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;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 ""; // CONNECT TO DATABASE $db = @mysql_connect(localhost,$username,$password) or die("<html><head><body bgcolor=$bgcolor alink=$bglinkcolor vlink=$bglinkcolor link=$bglinkcolor> <center>Database Error</center></body></html>"); @mysql_select_db($database,$db) or die("<html><head><body bgcolor=$bgcolor alink=$bglinkcolor vlink=$bglinkcolor link=$bglinkcolor> <center>Database Error</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> "; if($team=="all") echo "<center>All Players TOTAL PLAYERS: $num_rows <center> "; if($team=="freeagents") echo "<center>Free Agents TOTAL PLAYERS: $num_rows <center> "; if ($team!="all" && $team!="freeagents"){ echo "<center><img src=../../images/team_logo/$team.gif> TOTAL PLAYERS: $num_rows <center> "; } 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>OFFENSE "; 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 " <center>DEFENSE "; 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 " <center>SPECIAL TEAMS "; 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>"; echo "$pos_tmp "; // 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="#$number"; 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>$FNAME $LNAME$number Salary: $sal/$yrl yrs. Bonus:$bon Total=$tot</td><td colspan=7>OVR $ovr AGE: $age Height: $hgt Weight: $wgt</td></tr><tr><td align=center>SPD<td align=center>STR<td align=center>ACC<td align=center>AGI<td align=center>THA<td align=center>THP<td align=center>BTK<td align=center>CAR<td align=center>CTH<td align=center>KR</tr><tr><td align=center>$spd<td align=center>$str<td align=center>$acc<td align=center>$agi<td align=center>$tha<td align=center>$thp<td align=center>$btk<td align=center>$car<td align=center>$cth<td align=center>$kr</tr><tr><td align=center>KAC<td align=center>KPW<td align=center>PBK<td align=center>RBK<td align=center>STA<td align=center>TAK<td align=center>AWR<td align=center>TGH<td align=center>JMP<td align=center>INJ</tr><tr><td align=center>$kac<td align=center>$kpw<td align=center>$pbk<td align=center>$rbk<td align=center>$sta<td align=center>$tak<td align=center>$awr<td align=center>$tgh<td align=center>$jmp<td align=center>$inj</tr></table>"; elseif($pos=="WR") echo "<table><tr><td align=left colspan=6>$cur_inj$FNAME $LNAME$number Salary: $sal/$yrl yrs. Bonus:$bon Total=$tot</td><td colspan=7>OVR $ovr AGE: $age Height: $hgt Weight: $wgt</td></tr><tr><td align=center>SPD<td align=center>STR<td align=center>ACC<td align=center>AGI<td align=center>THA<td align=center>THP<td align=center>BTK<td align=center>CAR<td align=center>CTH<td align=center>KR</tr><tr><td align=center>$spd<td align=center>$str<td align=center>$acc<td align=center>$agi<td align=center>$tha<td align=center>$thp<td align=center>$btk<td align=center>$car<td align=center>$cth<td align=center>$kr</tr><tr><td align=center>KAC<td align=center>KPW<td align=center>PBK<td align=center>RBK<td align=center>STA<td align=center>TAK<td align=center>AWR<td align=center>TGH<td align=center>JMP<td align=center>INJ</tr><tr><td align=center>$kac<td align=center>$kpw<td align=center>$pbk<td align=center>$rbk<td align=center>$sta<td align=center>$tak<td align=center>$awr<td align=center>$tgh<td align=center>$jmp<td align=center>$inj</tr></table>"; elseif($pos=="TE") echo "<table><tr><td align=left colspan=6>$cur_inj$FNAME $LNAME$number Salary: $sal/$yrl yrs. Bonus:$bon Total=$tot</td><td colspan=7>OVR $ovr AGE: $age Height: $hgt Weight: $wgt</td></tr><tr><td align=center>SPD<td align=center>STR<td align=center>ACC<td align=center>AGI<td align=center>THA<td align=center>THP<td align=center>BTK<td align=center>CAR<td align=center>CTH<td align=center>KR</tr><tr><td align=center>$spd<td align=center>$str<td align=center>$acc<td align=center>$agi<td align=center>$tha<td align=center>$thp<td align=center>$btk<td align=center>$car<td align=center>$cth<td align=center>$kr</tr><tr><td align=center>KAC<td align=center>KPW<td align=center>PBK<td align=center>RBK<td align=center>STA<td align=center>TAK<td align=center>AWR<td align=center>TGH<td align=center>JMP<td align=center>INJ</tr><tr><td align=center>$kac<td align=center>$kpw<td align=center>$pbk<td align=center>$rbk<td align=center>$sta<td align=center>$tak<td align=center>$awr<td align=center>$tgh<td align=center>$jmp<td align=center>$inj</tr></table>"; elseif($pos=="HB") echo "<table><tr><td align=left colspan=6>$cur_inj$FNAME $LNAME$number Salary: $sal/$yrl yrs. Bonus:$bon Total=$tot</td><td colspan=7>OVR $ovr AGE: $age Height: $hgt Weight: $wgt</td></tr><tr><td align=center>SPD<td align=center>STR<td align=center>ACC<td align=center>AGI<td align=center>THA<td align=center>THP<td align=center>BTK<td align=center>CAR<td align=center>CTH<td align=center>KR</tr><tr><td align=center>$spd<td align=center>$str<td align=center>$acc<td align=center>$agi<td align=center>$tha<td align=center>$thp<td align=center>$btk<td align=center>$car<td align=center>$cth<td align=center>$kr</tr><tr><td align=center>KAC<td align=center>KPW<td align=center>PBK<td align=center>RBK<td align=center>STA<td align=center>TAK<td align=center>AWR<td align=center>TGH<td align=center>JMP<td align=center>INJ</tr><tr><td align=center>$kac<td align=center>$kpw<td align=center>$pbk<td align=center>$rbk<td align=center>$sta<td align=center>$tak<td align=center>$awr<td align=center>$tgh<td align=center>$jmp<td align=center>$inj</tr></table>"; elseif($pos=="QB") echo "<table><tr><td align=left colspan=6>$cur_inj$FNAME $LNAME$number Salary: $sal/$yrl yrs. Bonus:$bon Total=$tot</td><td colspan=7>OVR $ovr AGE: $age Height: $hgt Weight: $wgt</td></tr><tr><td align=center>SPD<td align=center>STR<td align=center>ACC<td align=center>AGI<td align=center>THA<td align=center>THP<td align=center>BTK<td align=center>CAR<td align=center>CTH<td align=center>KR</tr><tr><td align=center>$spd<td align=center>$str<td align=center>$acc<td align=center>$agi<td align=center>$tha<td align=center>$thp<td align=center>$btk<td align=center>$car<td align=center>$cth<td align=center>$kr</tr><tr><td align=center>KAC<td align=center>KPW<td align=center>PBK<td align=center>RBK<td align=center>STA<td align=center>TAK<td align=center>AWR<td align=center>TGH<td align=center>JMP<td align=center>INJ</tr><tr><td align=center>$kac<td align=center>$kpw<td align=center>$pbk<td align=center>$rbk<td align=center>$sta<td align=center>$tak<td align=center>$awr<td align=center>$tgh<td align=center>$jmp<td align=center>$inj</tr></table>"; elseif($pos=="FB") echo "<table><tr><td align=left colspan=6>$cur_inj$FNAME $LNAME$number Salary: $sal/$yrl yrs. Bonus:$bon Total=$tot</td><td colspan=7>OVR $ovr AGE: $age Height: $hgt Weight: $wgt</td></tr><tr><td align=center>SPD<td align=center>STR<td align=center>ACC<td align=center>AGI<td align=center>THA<td align=center>THP<td align=center>BTK<td align=center>CAR<td align=center>CTH<td align=center>KR</tr><tr><td align=center>$spd<td align=center>$str<td align=center>$acc<td align=center>$agi<td align=center>$tha<td align=center>$thp<td align=center>$btk<td align=center>$car<td align=center>$cth<td align=center>$kr</tr><tr><td align=center>KAC<td align=center>KPW<td align=center>PBK<td align=center>RBK<td align=center>STA<td align=center>TAK<td align=center>AWR<td align=center>TGH<td align=center>JMP<td align=center>INJ</tr><tr><td align=center>$kac<td align=center>$kpw<td align=center>$pbk<td align=center>$rbk<td align=center>$sta<td align=center>$tak<td align=center>$awr<td align=center>$tgh<td align=center>$jmp<td align=center>$inj</tr></table>"; elseif($pos=="LE" || $pos=="DT" || $pos=="RE") echo "<table><tr><td align=left colspan=6>$cur_inj$FNAME $LNAME$number Salary: $sal/$yrl yrs. Bonus:$bon Total=$tot</td><td colspan=7>OVR $ovr AGE: $age Height: $hgt Weight: $wgt</td></tr><tr><td align=center>SPD<td align=center>STR<td align=center>ACC<td align=center>AGI<td align=center>THA<td align=center>THP<td align=center>BTK<td align=center>CAR<td align=center>CTH<td align=center>KR</tr><tr><td align=center>$spd<td align=center>$str<td align=center>$acc<td align=center>$agi<td align=center>$tha<td align=center>$thp<td align=center>$btk<td align=center>$car<td align=center>$cth<td align=center>$kr</tr><tr><td align=center>KAC<td align=center>KPW<td align=center>PBK<td align=center>RBK<td align=center>STA<td align=center>TAK<td align=center>AWR<td align=center>TGH<td align=center>JMP<td align=center>INJ</tr><tr><td align=center>$kac<td align=center>$kpw<td align=center>$pbk<td align=center>$rbk<td align=center>$sta<td align=center>$tak<td align=center>$awr<td align=center>$tgh<td align=center>$jmp<td align=center>$inj</tr></table>"; elseif($pos=="LOLB" || $pos=="MLB" || $pos=="ROLB") echo "<table><tr><td align=left colspan=6>$cur_inj$FNAME $LNAME$number Salary: $sal/$yrl yrs. Bonus:$bon Total=$tot</td><td colspan=7>OVR $ovr AGE: $age Height: $hgt Weight: $wgt</td></tr><tr><td align=center>SPD<td align=center>STR<td align=center>ACC<td align=center>AGI<td align=center>THA<td align=center>THP<td align=center>BTK<td align=center>CAR<td align=center>CTH<td align=center>KR</tr><tr><td align=center>$spd<td align=center>$str<td align=center>$acc<td align=center>$agi<td align=center>$tha<td align=center>$thp<td align=center>$btk<td align=center>$car<td align=center>$cth<td align=center>$kr</tr><tr><td align=center>KAC<td align=center>KPW<td align=center>PBK<td align=center>RBK<td align=center>STA<td align=center>TAK<td align=center>AWR<td align=center>TGH<td align=center>JMP<td align=center>INJ</tr><tr><td align=center>$kac<td align=center>$kpw<td align=center>$pbk<td align=center>$rbk<td align=center>$sta<td align=center>$tak<td align=center>$awr<td align=center>$tgh<td align=center>$jmp<td align=center>$inj</tr></table>"; elseif($pos=="CB") echo "<table><tr><td align=left colspan=6>$cur_inj$FNAME $LNAME$number Salary: $sal/$yrl yrs. Bonus:$bon Total=$tot</td><td colspan=7>OVR $ovr AGE: $age Height: $hgt Weight: $wgt</td></tr><tr><td align=center>SPD<td align=center>STR<td align=center>ACC<td align=center>AGI<td align=center>THA<td align=center>THP<td align=center>BTK<td align=center>CAR<td align=center>CTH<td align=center>KR</tr><tr><td align=center>$spd<td align=center>$str<td align=center>$acc<td align=center>$agi<td align=center>$tha<td align=center>$thp<td align=center>$btk<td align=center>$car<td align=center>$cth<td align=center>$kr</tr><tr><td align=center>KAC<td align=center>KPW<td align=center>PBK<td align=center>RBK<td align=center>STA<td align=center>TAK<td align=center>AWR<td align=center>TGH<td align=center>JMP<td align=center>INJ</tr><tr><td align=center>$kac<td align=center>$kpw<td align=center>$pbk<td align=center>$rbk<td align=center>$sta<td align=center>$tak<td align=center>$awr<td align=center>$tgh<td align=center>$jmp<td align=center>$inj</tr></table>"; elseif($pos=="SS" || $pos=="FS") echo "<table><tr><td align=left colspan=6>$cur_inj$FNAME $LNAME$number Salary: $sal/$yrl yrs. Bonus:$bon Total=$tot</td><td colspan=7>OVR $ovr AGE: $age Height: $hgt Weight: $wgt</td></tr></tr><tr><td align=center>SPD<td align=center>STR<td align=center>ACC<td align=center>AGI<td align=center>THA<td align=center>THP<td align=center>BTK<td align=center>CAR<td align=center>CTH<td align=center>KR</tr><tr><td align=center>$spd<td align=center>$str<td align=center>$acc<td align=center>$agi<td align=center>$tha<td align=center>$thp<td align=center>$btk<td align=center>$car<td align=center>$cth<td align=center>$kr</tr><tr><td align=center>KAC<td align=center>KPW<td align=center>PBK<td align=center>RBK<td align=center>STA<td align=center>TAK<td align=center>AWR<td align=center>TGH<td align=center>JMP<td align=center>INJ</tr><tr><td align=center>$kac<td align=center>$kpw<td align=center>$pbk<td align=center>$rbk<td align=center>$sta<td align=center>$tak<td align=center>$awr<td align=center>$tgh<td align=center>$jmp<td align=center>$inj</tr></table>"; elseif($pos=="K" || $pos=="P") echo "<table><tr><td align=left colspan=6>$cur_inj$FNAME $LNAME$number Salary: $sal/$yrl yrs. Bonus:$bon Total=$tot</td><td colspan=7>OVR $ovr AGE: $age Height: $hgt Weight: $wgt</td></tr><tr><td align=center>SPD<td align=center>STR<td align=center>ACC<td align=center>AGI<td align=center>THA<td align=center>THP<td align=center>BTK<td align=center>CAR<td align=center>CTH<td align=center>KR</tr><tr><td align=center>$spd<td align=center>$str<td align=center>$acc<td align=center>$agi<td align=center>$tha<td align=center>$thp<td align=center>$btk<td align=center>$car<td align=center>$cth<td align=center>$kr</tr><tr><td align=center>KAC<td align=center>KPW<td align=center>PBK<td align=center>RBK<td align=center>STA<td align=center>TAK<td align=center>AWR<td align=center>TGH<td align=center>JMP<td align=center>INJ</tr><tr><td align=center>$kac<td align=center>$kpw<td align=center>$pbk<td align=center>$rbk<td align=center>$sta<td align=center>$tak<td align=center>$awr<td align=center>$tgh<td align=center>$jmp<td align=center>$inj</tr></table>"; echo "', CENTER)\" onMouseOut=\"nd()\" STYLE=\"text-decoration: none\">"; if($hold=="Yes") echo ""; elseif($yrl==0 && $team!="Free Agents") echo ""; if($cur_inj=="<img src=injured.gif>") echo "<font co

June 8, 2006

Loops not working?

jwer78 replied to jwer78's topic in PHP Coding Help

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.

February 28, 2006
18 replies

Loops not working?

jwer78 replied to jwer78's topic in PHP Coding Help

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.

February 28, 2006
18 replies

Loops not working?

jwer78 replied to jwer78's topic in PHP Coding Help

Done. No errors reported.

February 28, 2006
18 replies

Loops not working?

jwer78 replied to jwer78's topic in PHP Coding Help

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...

February 28, 2006
18 replies

Loops not working?

jwer78 replied to jwer78's topic in PHP Coding Help

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.

February 28, 2006
18 replies

Loops not working?

jwer78 replied to jwer78's topic in PHP Coding Help

Nope, still nothing and still no error.

February 28, 2006
18 replies

Sign In

Posts

Joined

Last visited

Contact Methods

Profile Information

jwer78's Achievements

Newbie (1/5)

Reputation

Small problem with a script

Small problem with a script

Small problem with a script

Check if an Array is Null

[SOLVED] Need a little help with modifying this script

[SOLVED] Need a little help with modifying this script

Unexpect T encapsed and whitespace

Loop Breaks when I add some new code....

overlib.js breaks when I change queries?

Loops not working?

Loops not working?

Loops not working?

Loops not working?

Loops not working?

Loops not working?

Browse

Activity

Important Information