Post Checked Values To Mysql Jquery Serialize()

[smithdp1]

I have a search results page that gives me a list of clients. If I check off the client they get added to a campaign. That is what I am trying to end up with.

[codefossa]

It depends on if it's always the same, if you set the id, if it increments, etc. It's up to you and how you do it.

[smithdp1]

so is this close?

<?php
foreach($_POST['clientId'] as $key => $value)
{
   $clientId = mysql_real_escape_string($value);
   $campaignId = mysql_real_escape_string($_POST['campaignId'][$key]);
   $data[] = "('$clientId','$campaignId')";
}
$sql  = "INSERT INTO `campaign_to_client` (clientId,campaignId) VALUES ";
$sql .= implode(",",$data);
?>