The mysql error gives me 'Table 'browngai_cms.titles' doesn't exist', however, it does exist.
The form method is post, and I just checked by reverifying each variable using $_POST, but the same issues keep occuring.
It only doesn't do those bad arguments implode error when I at least check one thing from each section (table selected in the form), otherwise it gives me error for any section's records completely unchecked.
Code: Select all
<?php
if ($command == "publishcontent"){
$titleID = "" . implode(", ", $titleID);
$newsID = "" . implode(", ", $newsID);
$reviewID = "" . implode(", ", $reviewID);
$articleID = "" . implode(", ", $articleID);
$screenshotID = "" . implode(", ", $screenshotID);
$titledate = date("Y-m-d H:i:s");
$newsdate = date("Y-m-d H:i:s");
$reviewdate = date("Y-m-d H:i:s");
$articledate = date("Y-m-d H:i:s");
$screenshotsdate = date("Y-m-d H:i:s");
$query = "UPDATE titles SET titledate='$titledate',activate='1' WHERE ID IN ($titleID)";
$result = mysql_query($query) or die(mysql_error());
$query = "UPDATE news SET newsdate='$newsdate',activate='1' WHERE ID IN ($newsID)";
$result = mysql_query($query) or die(mysql_error());
$query = "UPDATE reviews SET reviewdate='$reviewdate',activate='1' WHERE ID IN ($reviewID)";
$result = mysql_query($query) or die(mysql_error());
$query = "UPDATE articles SET articledate='$articledate',activate='1' WHERE ID IN ($articleID)";
$result = mysql_query($query) or die(mysql_error());
$query = "UPDATE screenshots SET screenshotsdate='$screenshotsdate',activate='1' WHERE ID IN ($screenshotID)";
$result = mysql_query($query) or die(mysql_error());
echo 'All selected content has been published.<br>';
}
?>