April 18th, 2005, 01:02 AM
|
#9 (permalink)
|
| 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
|
| |