Multiple selecting through Multiple Tables problem

Shinmeiryu

What's wrong with my code? I'm trying to multiple select through multiple tables to post a date and activate publishing, but I keep getting bad arguments for every line on implode and an error making the query.

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('error making query');
		$query = "UPDATE news SET newsdate='$newsdate',activate='1' WHERE ID IN ($newsID)";
		$result = mysql_query($query) or die('error making query'); 	
		$query = "UPDATE reviews SET reviewdate='$reviewdate',activate='1' WHERE ID IN ($reviewID)";
		$result = mysql_query($query) or die('error making query');	
		$query = "UPDATE articles SET articledate='$articledate',activate='1' WHERE ID IN ($articleID)";
		$result = mysql_query($query) or die('error making query');	
		$query = "UPDATE screenshots SET screenshotsdate='$screenshotsdate',activate='1' WHERE ID IN ($screenshotID)";
		$result = mysql_query($query) or die('error making query');	
		echo 'All selected content has been published.<br>';
	  }

ahundiak

Change your dies to
or die(mysql_error());
That should give you a hint. I'm, guessing that your $id arrays have not been set.. Did they come from $_POST? Do you have register_globals on?

Shinmeiryu

I believe register_globals are on.

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.

Weedpacket

Originally posted by Shinmeiryu
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.

Because when a section is completely unchecked the query would become

"UPDATE titles SET titledate='now',activate='1' WHERE ID IN ()"
and I guess that MySQL gets upset about empty sets like that. Why it gives the error message it does - I dunno, I never use the thing.

Try checking to make sure that $titleID, etc is not empty before using it in the query.