Can anyone help?

[Smitty2b2]

i am getting some errors on my site i can't figure out why?

1: Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/dyingtwi/public_html/functions/matchdb.php on line 61

2: Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/dyingtwi/public_html/functions/playerdb.php on line 69

3: Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/dyingtwi/public_html/functions/teamdb.php on line 71

those are the errors if anyone can help please write back thank you
here or at [e-mail]

[suntra]

Noone is going to be able to help you without a bit of code ! We need to see lines 61, 69 and 71, and of course, the lines before, between and after!

[Smitty2b2]

<?
function match_database($page,$order){
global $dir, $file, $url, $out, $misc, $site, $admn;
$result=mysql_query("select COUNT(*) from matchdb");
$result=mysql_fetch_array($result);
$totalusers="$result[0]";
$maxresults="25";
$stop="$maxresults";
if(!$page){
$start="1";
}else{

    $start="$page";
}

if($start > $totalusers){
    $start=0;
}

$page="$start";
$start=($start-1);
$altcolora="#000033";
$altcolorb="#000020";
if($order == "matchid_up"){
    $order = "matchid";
}else if ($order == "matchid_down"){

    $order = "matchid desc";
}else if ($order == "winneralias_down"){

    $order = "winneralias desc";
}else if ($order == "winneralias_up"){

    $order = "winneralias";
}else if ($order == "loseralias_down"){

    $order = "loseralias desc";
}else if ($order == "loseralias_up"){

    $order = "loseralias";
}else if ($order == "laddername_down"){

    $order = "laddername desc";
}else if ($order == "laddername_up"){

    $order = "laddername";
}else if ($order == "reportdate_up"){

    $order = "reportdate";
}else{

    $order = "reportdate desc";
}

$result=mysql_query("SELECT matchid,winnerid,loserid,winneralias,loseralias,ladderid,laddername,DATE_FORMAT(reportdate, '%M %d, %l:%i %p'),reporterip,confirmerip from matchdb ORDER BY $order LIMIT $start,$stop");
while(list($matchid,$winnerid,$loserid,$winneralias,$loseralias,$ladderid,$laddername,$reportdate,$reporterip,$confirmerip)=mysql_fetch_row($result)) {
    if($altladrow=="$altcolora"){
        $altladrow="$altcolorb";
    }else{

        $altladrow="$altcolora";
    }

    if($reporterip){
        $reporterip="<img src='$url[themes]/images/ip.gif' border='0' alt='$reporterip' style='cursor:hand;'>";
    }else{

        $reporterip="?";
    }

    if($confirmerip){
        $confirmerip="<img src='$url[themes]/images/ip.gif' border='0' alt='$confirmerip' style='cursor:hand;'>";
    }else{

        $confirmerip="?";
    }

    $playerlist=$playerlist."
    <tr bgcolor='$altladrow'>
    <td width='' valign='center' align='left'><a href='$url[base]/$file[teams]?teamid=$winnerid'>$winneralias</a></td>
    <td width='' valign='center' align='center'><a href='$url[base]/$file[teams]?teamid=$loserid'>$loseralias</a></td>
    <td width='' valign='center' align='center'>$reportdate</td>
    <td width='' valign='center' align='center'><a href='$url[base]/$file[match]?matchid=$matchid'><img src='$url[themes]/images/stats.gif' border='0'></a></td>
    <td width='' valign='center' align='center'><a href='$url[base]/$file[game]?ladderid=$ladderid'>$laddername</a></td>";
    if($admn[id]){
        $ipmatchcolor="";
        if($confirmerip==$reporterip){
            $ipmatchcolor="bgcolor='#336699'";
        }

        $playerlist=$playerlist."
        <td width='' valign='center' align='center' $ipmatchcolor>$confirmerip</td>
        <td width='' valign='center' align='center' $ipmatchcolor>$reporterip</td>";
    }

    $playerlist=$playerlist."</tr>";
    $counter++;
}

if($order == "winneralias desc"){
    $winner = "winneralias_up";
}else{

    $winner = "winneralias_down";
}

if($order == "loseralias desc"){
    $loser = "loseralias_up";
}else{

    $loser = "loseralias_down";
}

if($order == "reportdate desc"){
    $matchdate = "reportdate_up";
}else{

    $matchdate = "reportdate_down";
}

if($order == "laddername desc"){
    $ladder = "laddername_up";
}else{

    $ladder = "laddername_down";
}

$tablehead=table_head("show","100%","","left");
$tablefoot=table_foot("show");
$bannerhead=table_head("show","488","80","center");
$bannerfoot=table_foot("show");
$out[body]=$out[body]."
<center>
$bannerhead
$out[banner]
$bannerfoot
<br>
<center>
$tablehead
&nbsp; &nbsp;<strong><font class='catfont'>$site[shortname] Match Database</font></strong><br>
<hr class='catfont' size='1'>
<table width='100%' border='0' bordercolor='#000000' cellspacing='1' cellpadding='1'>
<tr class='altcolor'>
<td width='' valign='center' align='left'><strong><a href='$url[base]/$file[stats]?action=matchdb&order=$winner'>Winner</a></strong></td>
<td width='' valign='center' align='center'><strong><a href='$url[base]/$file[stats]?action=matchdb&order=$loser'>Loser</a></strong></td>
<td width='' valign='center' align='center'><strong><a href='$url[base]/$file[stats]?action=matchdb&order=$matchdate'>Match Date</a></strong></td>
<td width='' valign='center' align='center'><strong>Stats</strong></td>
<td width='' valign='center' align='center'><strong><a href='$url[base]/$file[stats]?action=matchdb&order=$ladder'>Ladder</a></strong></td>";
if($admn[id]){
    $out[body]=$out[body]."
    <td width='' valign='center' align='center'><strong>Wip</strong></td>
    <td width='' valign='center' align='center'><strong>Lip</strong></td>";
}

$out[body]=$out[body]."
</tr>
$playerlist
";
$pagenumb=1;
if ($totalusers > $maxresults) {
    $totalpages=($totalusers / $maxresults);
    while($pagenum < $totalpages){
        $pagenum++;
        if($pagenumb=="$page"){
            $pages=$pages."[<a href='$url[base]/$file[stats]?action=matchdb&page=$pagenumb'>$pagenum</a>] ";
        }else{

            $pages=$pages."<a href='$url[base]/$file[stats]?action=matchdb&page=$pagenumb'>$pagenum</a> ";
        }

        $pagenumb=($maxresults + $pagenumb);
    }

}

if($pages){
    $out[body]=$out[body]."
    <tr class='altcolor'>
    <td width='100%' valign='center' align='center' colspan='8'><strong>$pages</strong></td>
    </tr>";
}

$out[body]=$out[body]."
</table>
$tablefoot";
include("$dir[curtheme]");

}

function checkl(){
global $dir, $file, $url, $out, $misc, $site, $admn;
$tday=date("Y-m-d H:i:s");
$op='U29mdHdhcmUgYnkgaHR0cDovL3d3dy5teWdhbWluZ2xhZGRlci5jb208YnI+VGhpcyBpcyBsaWNlbnNlZCBzb2Z0d2FyZSBhbmQgaXRcJ3MgdXNlIHdpdGhvdXQgYSB2YWxpZCBsaWNlbnNlIGlzIG5vdCBwZXJtaXR0ZWQu';
$end = base64_decode("$op");
include("$dir[func]/error.php");
display_error("$tday<br><br>$end");
}

?>

[Smitty2b2]

there is the script

[suntra]

My guess is that you probably have errors in your queries... use mysql_error() with your queries, something like...

$resResultats = mysql_query("SELECT * FROM table") or print(mysql_error());

[Roger_Ramjet]

supplied argument is not a valid MySQL result resource

always means that it can not find your query results. This can be for two reasons:

the query failed and there are no results

you misspelled the name you gave them

[Smitty2b2]

thank you, i will try that and see what happens ill let you know if it helped

[Smitty2b2]

everything seems to be spelled the same? still didn't get it to work anymore sugestions??? here is the data base.

--------------------------------------------------------

#

Table structure for table matchdb

#

DROP TABLE IF EXISTS matchdb;
CREATE TABLE matchdb (
matchid varchar(50) NOT NULL default '',
winnerid int(10) NOT NULL default '0',
loserid int(10) NOT NULL default '0',
winneralias varchar(50) NOT NULL default '',
loseralias varchar(50) NOT NULL default '',
ladderid int(10) NOT NULL default '0',
laddername varchar(50) NOT NULL default '',
winrank int(10) NOT NULL default '0',
loserank int(10) NOT NULL default '0',
winscore int(10) NOT NULL default '0',
losescore int(10) NOT NULL default '0',
winmembers varchar(250) NOT NULL default '',
losemembers varchar(250) NOT NULL default '',
mapsplayed varchar(250) NOT NULL default '',
mapswon varchar(250) NOT NULL default '',
wincomment varchar(250) NOT NULL default '',
losecomment varchar(250) NOT NULL default '',
wonpoints int(10) NOT NULL default '0',
wonskill varchar(10) NOT NULL default '0',
reporterid int(10) NOT NULL default '0',
reportdate datetime NOT NULL default '0000-00-00 00:00:00',
reporterip varchar(16) NOT NULL default '',
confirmerid int(10) NOT NULL default '0',
confirmdate datetime NOT NULL default '0000-00-00 00:00:00',
confirmerip varchar(16) NOT NULL default '',
KEY matchid (matchid),
KEY winnerid (winnerid),
KEY loserid (loserid),
KEY ladderid (ladderid),
KEY reportdate (reportdate),
KEY confirmdate (confirmdate)
) TYPE=ISAM PACK_KEYS=1;

--------------------------------------------------------

#

Table structure for table matchdbval

#

DROP TABLE IF EXISTS matchdbval;
CREATE TABLE matchdbval (
matchid varchar(50) NOT NULL default '',
winnerid int(10) NOT NULL default '0',
loserid int(10) NOT NULL default '0',
loseralias varchar(50) NOT NULL default '',
ladderid int(10) NOT NULL default '0',
losersmembers varchar(250) NOT NULL default '',
maps varchar(250) NOT NULL default '',
lcomment varchar(250) NOT NULL default '',
wrank int(10) NOT NULL default '0',
lrank int(10) NOT NULL default '0',
points int(10) NOT NULL default '0',
skill int(10) NOT NULL default '0',
reportedby int(10) NOT NULL default '0',
reporteddate datetime NOT NULL default '0000-00-00 00:00:00',
reportedip varchar(16) NOT NULL default '',
PRIMARY KEY (matchid),
KEY winnerid (winnerid),
KEY loserid (loserid),
KEY ladderid (ladderid)
) TYPE=ISAM PACK_KEYS=1;

--------------------------------------------------------

#

Table structure for table teammembers

#

DROP TABLE IF EXISTS teammembers;
CREATE TABLE teammembers (
teamid int(10) NOT NULL default '0',
playerid int(10) NOT NULL default '0',
status tinyint(1) NOT NULL default '0',
joindate datetime NOT NULL default '0000-00-00 00:00:00',
KEY teamid (teamid),
KEY playerid (playerid)
) TYPE=ISAM PACK_KEYS=1;

--------------------------------------------------------

#

Table structure for table teammembersinv

#

DROP TABLE IF EXISTS teammembersinv;
CREATE TABLE teammembersinv (
teamid int(10) NOT NULL default '0',
playerid int(10) NOT NULL default '0',
inviterid int(10) NOT NULL default '0',
invitedate datetime NOT NULL default '0000-00-00 00:00:00',
KEY teamid (teamid),
KEY playerid (playerid),
KEY inviterid (inviterid)
) TYPE=ISAM PACK_KEYS=1;

--------------------------------------------------------

#

Table structure for table teams

#

DROP TABLE IF EXISTS teams;
CREATE TABLE teams (
id int(10) NOT NULL auto_increment,
teamname varchar(50) NOT NULL default '0',
teamemail varchar(100) NOT NULL default '',
tag varchar(25) NOT NULL default '0',
tagplace tinyint(1) NOT NULL default '0',
website varchar(100) NOT NULL default '0',
logo varchar(100) NOT NULL default '0',
contact varchar(100) NOT NULL default '',
joindate datetime NOT NULL default '0000-00-00 00:00:00',
idcreate int(10) NOT NULL default '0',
ipcreate varchar(16) NOT NULL default '0.0.0.0',
type tinyint(1) NOT NULL default '0',
PRIMARY KEY (id),
KEY teamname (teamname)
) TYPE=ISAM PACK_KEYS=1 AUTO_INCREMENT=11 ;

--------------------------------------------------------

#

Table structure for table users

#

DROP TABLE IF EXISTS users;
CREATE TABLE users (
id int(10) NOT NULL auto_increment,
alias varchar(50) NOT NULL default '0',
pass varchar(25) NOT NULL default '0',
email varchar(50) NOT NULL default '0',
icq varchar(10) NOT NULL default '0',
aim varchar(25) NOT NULL default '0',
yahoo varchar(35) NOT NULL default '0',
msn varchar(35) NOT NULL default '0',
website varchar(100) NOT NULL default '0',
logo varchar(100) NOT NULL default '0',
newsletter tinyint(1) NOT NULL default '0',
joindate datetime default '0000-00-00 00:00:00',
ipaddress varchar(16) NOT NULL default '0.0.0.0',
matcheswon int(10) NOT NULL default '0',
matcheslost int(10) NOT NULL default '0',
points int(10) NOT NULL default '0',
skill int(10) NOT NULL default '0',
money int(10) NOT NULL default '0',
lastlogin datetime NOT NULL default '0000-00-00 00:00:00',
theme varchar(30) NOT NULL default '',
country char(2) NOT NULL default '',
PRIMARY KEY (id),
KEY alias (alias)
) TYPE=ISAM PACK_KEYS=1 AUTO_INCREMENT=7 ;

--------------------------------------------------------

#

Table structure for table usersinfo

#

DROP TABLE IF EXISTS usersinfo;
CREATE TABLE usersinfo (
id int(10) NOT NULL default '0',
firstname varchar(50) NOT NULL default '0',
middlename varchar(50) NOT NULL default '0',
lastname varchar(50) NOT NULL default '0',
address varchar(50) NOT NULL default '0',
city varchar(50) NOT NULL default '0',
state char(2) NOT NULL default '0',
zipcode varchar(10) NOT NULL default '0',
phone bigint(10) NOT NULL default '0',
birthday date NOT NULL default '0000-00-00',
occupation char(2) NOT NULL default '0',
required tinyint(1) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=ISAM PACK_KEYS=1;

--------------------------------------------------------

maybe that will help??? that is just part of it but matchdb is there..

[suntra]

Have you tried to use mysql_error() ?