I have a simple block of code that when working correctly should change an enabled value in a table to 0 but the query is not working. Here is the code:
Code: Select all
$find_pic_cat = sprintf("UPDATE pics_categories SET enabled=0 WHERE id=%s",
SQLValue($_POST['catid'],"int"));
$query_pic_cat = mysql_query($find_pic_cat);Code: Select all
echo $find_pic_cat ."<br />".mysql_error($query_pic_cat)."<br />". mysql_info($query_pic_cat)."<br />".$_POST['catid'];Code: Select all
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/bfp/public_html/class2005/user.php on line 361
Warning: mysql_info() expects parameter 1 to be resource, boolean given in /home/bfp/public_html/class2005/user.php on line 361
UPDATE pics_categories SET enabled=0 WHERE id=85
85Hope you can help many thanks
Richard