View Single Post
Old April 18th, 2005, 01:02 AM   #9 (permalink)
Khashyar
Member
Verified Customer
 
Join Date: Apr 2003
Posts: 172
Perhaps someone might be able to help with understanding which variables are not being executed right in the .php code. I would appreciate any help or feedback on this.

The code for this error:

Quote:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/xxxxxxx/public_html/reviews/forums/vb2.php on line 259
refers to this line in the vb2.php file:

Quote:
// groups less than 1 have no posting privledges..
if ( $usergroup < 1 ) {
$User['nopost'] = 1;
}

$query = "SELECT cpaccess,modaccess,uploads,reviews,editpho,editposts FROM {$Globals['rp_db_prefix']}usergroups WHERE groupid=$usergroup LIMIT 1";

$resulta = ppmysql_query($query,$link);
list( $User['adminedit'],$User['moderator'],$useruploads,$userreview,$ueditpho,$ueditposts ) = mysql_fetch_row($resulta);
ppmysql_free_result($resulta);

$CatPerms = array();
$listofcats = set_group_perms( $usergroup );
$Globals['offset'] = $offset;

$catarray = explode( ",", $listofcats );
foreach ($catarray as $thecat) {
if ($CatPerms['ugview'][$thecat] == 1) {
$exclude_cat .= " AND cat != $thecat";
}
}

if ( $gologin == 1 ) {
$User['username'] = $Globals['pp_lang']['unreg'];
$User['userid'] = 0;
$Globals['offset'] = $Globals['gmtoffset'];
}




And this error:

Quote:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/xxxxxxx/public_html/reviews/showcat.php on line 300
refers to this line:

Quote:
$queryv = ppmysql_query($query,$link);
$rowcnt = mysql_num_rows($queryv);


This last error:

Quote:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/xxxxxxx/public_html/reviews/showcat.php on line 325
refers to this line in the showcat.php script:

Quote:
while ( $row = mysql_fetch_row($queryv) ) {
if ( $cat == "fav" )
list( $favid, $id, $tuser, $tuserid, $pcat, $date, $title, $desc, $keywords, $bigimage, $views, $approved, $imgrating, $manuf, $comcount ) = $row;
else
list( $id, $tuser, $tuserid, $pcat, $date, $title, $desc, $keywords, $bigimage, $views, $approved, $imgrating, $manuf, $comcount ) = $row;

Thanks again for any thoughts...

Khashyar
Khashyar is offline   Reply With Quote