flemingmike
-
Posts
472 -
Joined
-
Last visited
Posts posted by flemingmike
-
-
how do i mark as solved?
-
wicked.,.. thanks, it worked. i knew it would be something stupid...
-
my error:
Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/mash905/public_html/betting/theme/default/html.php
-
hi, im having a problem putting a picture with a link. i used:
<? //Facebook echo"<a href='http://www.facebook.com/pages/manage/promo_guidelines.php#/pages/VGBETTINGcom-Think-you-got-game/57307786049?ref=mf'><img src="images/facebook.gif"></a>"; //End Facebook ?>
what am i doing wrong?
-
thanks for the input, i will definatly work on these.. good sugestions.
-
Hi all, i just did a redesign on a clients website.
can i get some opinions?
thanks in advance
-
-
so i just created the table ladder_166, and no more error.
all seems to be working. any chance this will happen again??
-
awesome info... but way over my head.
i dont know... time to give up???
-
so how can i eliminate this error?
sorry... im new to this.
-
ok, i changed the code, and this is the new error:
SQL: SELECT COUNT(*) FROM ladder_166
MySQL Returned:Table 'mash905_betting.ladder_166' doesn't exist
i checked for a table ladder_166 and it doesnt exist.
-
so i tried to alter ladder_$id and it just killed the page...
any other suggestions?
-
so, i think im making some progress.... what i understand now is ladder_$id is representing the table (ie. ladder_345). what im trying to do is count the number of records inside that table.
is this helping to give you any more idea of what im trying to accomplish?
-
it appears the column might be called teamid?
teamid name rank lrank wins loss games percent streak points kills king level strike_1 strike_2 strike_3 lastmatch
6 MaddenMike 0 0 0 0 0 0 0 0 0 1 [bLOB - 0 B] [bLOB - 0 B] [bLOB - 0 B] 0000-00-00 00:00:00
-
ie says error on line 44. here are the lines surrounding line 44. (it was working before, and just stopped. no changes to the script, only changes to database was more entries added.
$totalteams=mysql_query("SELECT COUNT(*) FROM ladder_$id "); $totalteams=mysql_fetch_array($totalteams); $totalteams="$totalteams[0]";
here is my whole code:
<? include("./includes/incglobal.php"); global $config; $groups=mysql_query("SELECT id,name,logo,active,priority,created FROM groups WHERE active='1' ORDER BY priority"); while(list($gid,$gname,$glogo,$gactive,$gpriority,$gcreated)=mysql_fetch_row($groups)){ $totalla=mysql_query("SELECT COUNT(*) FROM ladders WHERE grid='$gid' ORDER BY id"); $totalla=mysql_fetch_array($totalla); $totalla="$totalla[0]"; if(!$glogo){ $headlogo=""; }else{ $headlogo="<img src='$glogo' border='0'><br />"; } $out[body].="<center><br />$headlogo <table width='96%' cellpadding='1' cellspacing='1' bgcolor='#000000' border='0'> <tr> <td width='37%' style='background: url($config[bg]) repeat-x;' colspan='7'><b>$gname</b></td> </tr> <tr> <td width='37%' style='background: url($config[bg2]) repeat-x;'> Ladder</td> <td width='30%' style='background: url($config[bg2]) repeat-x;'> Game</td> <td width='8%' style='background: url($config[bg2]) repeat-x;'>Join</td> <td width='8%' style='background: url($config[bg2]) repeat-x;'>Rules</td> <td width='10%' style='background: url($config[bg2]) repeat-x;'>Matches</td> <td width='12%' style='background: url($config[bg2]) repeat-x;'>Count</td> <td width='3%' style='background: url($config[bg2]) repeat-x;'></td> </tr>"; if($totalla == 0){ $out[body].=" <tr bgcolor='$config[altcolora]'><td width='100%' background='$config[cellbg]' colspan='7'> There are currently no ladders in this group</td></tr>"; } $ladders=mysql_query("SELECT id,name,game,gamelink,grid,isteam,active FROM ladders WHERE grid='$gid' ORDER BY id"); while(list($id,$name,$game,$gamelink,$grid,$isteam,$active)=mysql_fetch_row($ladders)){ $totalteams=mysql_query("SELECT COUNT(*) FROM ladder_$id "); $totalteams=mysql_fetch_array($totalteams); $totalteams="$totalteams[0]"; if ($active == 0) { $light = "<img src='./images/ineligible.png' border='0' alt='Ladder is inactive!'>"; $link = "$name"; }else{ $light = "<img src='./images/eligible.png' border='0' alt'Ladder is active!'>"; $link = "<a href='$config[scripturl]/standings.php?ladder[id]=$id' class='content'>$name</a>"; } if($gamelink){ $glink="<a href='$gamelink'>$game</a>"; }else{ $glink="$game"; } if($config[altcolorx]==$config[altcolora]){ $config[altcolorx]="$config[altcolorb]"; }else{ $config[altcolorx]="$config[altcolora]"; } if($config[cellbgx]==$config[cellbg]){$config[cellbgx]="$config[cellbg2]";}else{$config[cellbgx]="$config[cellbg]";} $out[body].=" <tr bgcolor='$config[altcolorx]'> <td width='30%' background='$config[cellbgx]'> $link </td> <td width='30%' background='$config[cellbgx]'> $glink</td> <td width='8%' background='$config[cellbgx]'><a href='./join.php?ladder=$id'>Join!</a></td> <td width='8%' background='$config[cellbgx]'><a href='./rules.php?rules[ladderid]=$id'>Rules</a></td> <td width='10%' background='$config[cellbgx]'><a href='./matchdb.php?ladder=$id'>All Match</a></td> <td width='12%' background='$config[cellbgx]'>$totalteams</td> <td width='3%' background='$config[cellbgx]'>$light</td> </tr>"; } $out[body].="</table></center>"; } $out[body].="<br /><br />"; include("$config[html]"); ?>
here is the error im recieving:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mash905/public_html/betting/ladders.php on line 44
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mash905/public_html/betting/ladders.php on line 44
-
sorry... im an idiot... here is the error im recieving:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mash905/public_html/betting/ladders.php on line 44
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mash905/public_html/betting/ladders.php on line 44
-
ie says error on line 44. here are the lines surrounding line 44. (it was working before, and just stopped. no changes to the script, only changes to database was more entries added.
$totalteams=mysql_query("SELECT COUNT(*) FROM ladder_$id "); $totalteams=mysql_fetch_array($totalteams); $totalteams="$totalteams[0]";
here is my whole code:
<? include("./includes/incglobal.php"); global $config; $groups=mysql_query("SELECT id,name,logo,active,priority,created FROM groups WHERE active='1' ORDER BY priority"); while(list($gid,$gname,$glogo,$gactive,$gpriority,$gcreated)=mysql_fetch_row($groups)){ $totalla=mysql_query("SELECT COUNT(*) FROM ladders WHERE grid='$gid' ORDER BY id"); $totalla=mysql_fetch_array($totalla); $totalla="$totalla[0]"; if(!$glogo){ $headlogo=""; }else{ $headlogo="<img src='$glogo' border='0'><br />"; } $out[body].="<center><br />$headlogo <table width='96%' cellpadding='1' cellspacing='1' bgcolor='#000000' border='0'> <tr> <td width='37%' style='background: url($config[bg]) repeat-x;' colspan='7'><b>$gname</b></td> </tr> <tr> <td width='37%' style='background: url($config[bg2]) repeat-x;'> Ladder</td> <td width='30%' style='background: url($config[bg2]) repeat-x;'> Game</td> <td width='8%' style='background: url($config[bg2]) repeat-x;'>Join</td> <td width='8%' style='background: url($config[bg2]) repeat-x;'>Rules</td> <td width='10%' style='background: url($config[bg2]) repeat-x;'>Matches</td> <td width='12%' style='background: url($config[bg2]) repeat-x;'>Count</td> <td width='3%' style='background: url($config[bg2]) repeat-x;'></td> </tr>"; if($totalla == 0){ $out[body].=" <tr bgcolor='$config[altcolora]'><td width='100%' background='$config[cellbg]' colspan='7'> There are currently no ladders in this group</td></tr>"; } $ladders=mysql_query("SELECT id,name,game,gamelink,grid,isteam,active FROM ladders WHERE grid='$gid' ORDER BY id"); while(list($id,$name,$game,$gamelink,$grid,$isteam,$active)=mysql_fetch_row($ladders)){ $totalteams=mysql_query("SELECT COUNT(*) FROM ladder_$id "); $totalteams=mysql_fetch_array($totalteams); $totalteams="$totalteams[0]"; if ($active == 0) { $light = "<img src='./images/ineligible.png' border='0' alt='Ladder is inactive!'>"; $link = "$name"; }else{ $light = "<img src='./images/eligible.png' border='0' alt'Ladder is active!'>"; $link = "<a href='$config[scripturl]/standings.php?ladder[id]=$id' class='content'>$name</a>"; } if($gamelink){ $glink="<a href='$gamelink'>$game</a>"; }else{ $glink="$game"; } if($config[altcolorx]==$config[altcolora]){ $config[altcolorx]="$config[altcolorb]"; }else{ $config[altcolorx]="$config[altcolora]"; } if($config[cellbgx]==$config[cellbg]){$config[cellbgx]="$config[cellbg2]";}else{$config[cellbgx]="$config[cellbg]";} $out[body].=" <tr bgcolor='$config[altcolorx]'> <td width='30%' background='$config[cellbgx]'> $link </td> <td width='30%' background='$config[cellbgx]'> $glink</td> <td width='8%' background='$config[cellbgx]'><a href='./join.php?ladder=$id'>Join!</a></td> <td width='8%' background='$config[cellbgx]'><a href='./rules.php?rules[ladderid]=$id'>Rules</a></td> <td width='10%' background='$config[cellbgx]'><a href='./matchdb.php?ladder=$id'>All Match</a></td> <td width='12%' background='$config[cellbgx]'>$totalteams</td> <td width='3%' background='$config[cellbgx]'>$light</td> </tr>"; } $out[body].="</table></center>"; } $out[body].="<br /><br />"; include("$config[html]"); ?>
how to center picture?
in HTML Help
Posted
brain cramp... how would i center this?