Some Help please

[Gandhi]

Hey, well the servers where my arcade site is hosted was down for a week, I have no idea why. Then now that its back up, when I click a category like shooting, action I get an error http://flashfungames.org/index.php?action=category&id=1&page=0&order2=game_name&sby=ASC

anyone know what that error is, or how I can fix it thanks.


THen I know the site looks messed up, but thats because the site was down, my coder, hasnt gotten a chance to fix the bugs.

Thanks in advance.

 

[Dan]

Can you post the line that the error comes from [and some more lines around it; above and below]?

 

[Gandhi]

Thanks, THis is line 127

$result4 = @mysql_query("SELECT count(*) as count FROM games WHERE gInCategory = $i"0"; }

and those are some lines below and above it

if (isset($page)) { 

$result4 = @mysql_query("SELECT count(*) as count FROM games WHERE gInCategory = $i"0"; }
if (!isset($page)) { 
if($seo_support == "1"){ echo "<a href=./cat-$id-p1.html>Next Page --></a>";} else { echo "<a href=./index.php?action=category&id=$id&page=1&order2=game_name&sby=ASC>Next Page --></a>"; }
}

if (isset($page)) {

 

[Dan]

It looks like some of the code in that line was cut off.
The query doesn't have a ) and I don't know how that scripts categories work.
Try changing line 127 to:

$result4 = @mysql_query("SELECT count(*) as count FROM games WHERE gInCategory = $i"); }

If that doesn't work, try:

$result4 = @mysql_query("SELECT count(*) as count FROM games WHERE gInCategory = $i0"); }

 

[Gandhi]

The first one worked, thanks a lot Dan, really appreciate it