Thread: Error Mysql
View Single Post
Old 10-26-2005, 11:40 PM   #2
Charter
Head Mole
 
Charter's Avatar
 
Join Date: May 2003
Posts: 2,539
Assuming you are using PhpDig 1.8.8 RC1, the relevant code is the following, but nothing in this code itself seems to indicate the problem.
Code:
          $key = addslashes($key);
          //if keyword exists, retrieve id, else insert it
          $requete = "SELECT key_id FROM ".PHPDIG_DB_PREFIX."keywords WHERE keyword = '".$key."'";
          $result_insert = mysql_query($requete,$id_connect);
          $num = mysql_num_rows($result_insert);
Try changing:
Code:
          $result_insert = mysql_query($requete,$id_connect);
To the following:
Code:
          $result_insert = mysql_query($requete,$id_connect) or die(mysql_error());
And see what prints onscreen.

If you upgraded from PhpDig 1.8.7 to PhpDig 1.8.8 RC1, there is an UPGRADE.txt instruction file that comes with the PhpDig 1.8.8 RC1 package.
__________________
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.
Charter is offline   Reply With Quote