PhpDig.net - View Single Post - Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

Charter · 11-23-2003, 11:29 AM

Hi. Here's a fix.

In spider.php find:

PHP Code:


			
$query = "SELECT count(*) as num FROM ".PHPDIG_DB_PREFIX."tempspider WHERE path like '".str_replace("'",'',$lien['path'])."' AND file like '".str_replace("'",'',$lien['file'])."' AND site_id='$site_id'";

and right before it add:

PHP Code:


			
if (!get_magic_quotes_runtime()) {

    $lien['path'] = addslashes($lien['path']);

    $lien['file'] = addslashes($lien['file']);

}

Again, in spider.php find:

PHP Code:


			
$query = "SELECT count(*) as num FROM ".PHPDIG_DB_PREFIX."tempspider WHERE path like '".str_replace("'",'',$lien['path'])."' AND file like '".str_replace("'",'',$lien['file'])."' AND site_id='$site_id'";

and replace with:

PHP Code:


			
$query = "SELECT count(*) as num FROM ".PHPDIG_DB_PREFIX."tempspider WHERE path like '".$lien['path']."' AND file like '".$lien['file']."' AND site_id='$site_id'";

Also, in spider.php find:

PHP Code:


			
$query = "SELECT count(*) as num FROM ".PHPDIG_DB_PREFIX."spider WHERE path like '".str_replace("'",'',$lien['path'])."' AND file like '".str_replace("'",'',$lien['file'])."' AND site_id='$site_id' $andmore";

and replace with:

PHP Code:


			
$query = "SELECT count(*) as num FROM ".PHPDIG_DB_PREFIX."spider WHERE path like '".$lien['path']."' AND file like '".$lien['file']."' AND site_id='$site_id' $andmore";

Remember to remove any "word" wrapping in the above code.

11-23-2003, 11:29 AM	#19
Charter Head Mole Join Date: May 2003 Posts: 2,539	Hi. Here's a fix. In spider.php find: PHP Code: `$query = "SELECT count() as num FROM ".PHPDIG_DB_PREFIX."tempspider WHERE path like '".str_replace("'",'',$lien['path'])."' AND file like '".str_replace("'",'',$lien['file'])."' AND site_id='$site_id'";` and right before it add: PHP Code: `if (!get_magic_quotes_runtime()) { $lien['path'] = addslashes($lien['path']); $lien['file'] = addslashes($lien['file']); }` Again, in spider.php find: PHP Code: `$query = "SELECT count() as num FROM ".PHPDIG_DB_PREFIX."tempspider WHERE path like '".str_replace("'",'',$lien['path'])."' AND file like '".str_replace("'",'',$lien['file'])."' AND site_id='$site_id'";` and replace with: PHP Code: `$query = "SELECT count() as num FROM ".PHPDIG_DB_PREFIX."tempspider WHERE path like '".$lien['path']."' AND file like '".$lien['file']."' AND site_id='$site_id'";` Also, in spider.php find: PHP Code: `$query = "SELECT count() as num FROM ".PHPDIG_DB_PREFIX."spider WHERE path like '".str_replace("'",'',$lien['path'])."' AND file like '".str_replace("'",'',$lien['file'])."' AND site_id='$site_id' $andmore";` and replace with: PHP Code: `$query = "SELECT count(*) as num FROM ".PHPDIG_DB_PREFIX."spider WHERE path like '".$lien['path']."' AND file like '".$lien['file']."' AND site_id='$site_id' $andmore";` Remember to remove any "word" wrapping in the above code. __________________ Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension.