mysql_fetch_array(): in sql_layers.php

goldiedpimp

I'm getting this error and can't figure out why.

It's on http://www.greatplainspaintball.com

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/smocksam/public_html/includes/sql_layer.php on line 357

if anyone has any suggestions as to why it's doing this I'd LOVE to hear from you.

thanks in advance.

Blob

Why don't you post your code...

goldiedpimp

Here's some AROUND the trouble spot.

 * sql_fetch_array($res,$row)
 * given a result identifier, returns an associative array
 * with the resulting row using field names as keys.
 * Needs also a row number for compatibility with PostgreSQL.
 */

function sql_fetch_array(&$res, $nr=0)
{
global $dbtype;
switch ($dbtype)
    {
    case "MySQL":
        $row = array();
        $row = mysql_fetch_array($res);
        return $row;
    break;;

case "mSQL":
    $row = array();
    $row = msql_fetch_array($res);
    return $row;
break;;

case "PostgreSQL":
case "PostgreSQL_local":
if( $res->get_total_rows() > $res->get_fetched_rows() ) {
	$row = array();
	$row = pg_fetch_array($res->get_result(), $res->get_fetched_rows() );
	$res->increment_fetched_rows();
	return $row;
} else {
	return false;
}
break;;

Blob

Could you point out the line? And could you put php inside the php tags please, so it's easy to see. 😛 🙂

goldiedpimp

I'm not exactly WHERE the error is. I'm completely new to this and am basically retarded when it comes to this stuff.

I could post the whole file here for you to examine if that would help?

laserlight

hmm... is $res the result of a valid query, or is it some other object?

goldiedpimp

I've got no clue?