Sorry guys I am so lost now.Jcart wrote:Code: Select all
<?php echo $x; ?>
How does echoing the value of $x pertain to the record[$x][FIELDNAME] in the code??
Moderator: General Moderators
Sorry guys I am so lost now.Jcart wrote:Code: Select all
<?php echo $x; ?>
Code: Select all
<?php
$x=0;
mysql_data_seek( $result1,0);
while ($row1 = mysql_fetch_assoc($result1)) { ?>
<tr><td><input type="text" value="<?php echo $row1['CName']; ?>" name="record[<?php echo ($x); ?>][CName]" size="15" /></td>
<td><input type="checkbox" name="record[<?php echo ($x); ?>][HOContact]" <?php if($row1["HOContact"]){echo " CHECKED";} ?> /></td>
<td><input type="checkbox" name="record[<?php echo ($x); ?>][HOAcctContact]" <?php if($row1["HOAcctContact"]){echo " CHECKED";} ?> /></td>
<td><input type="checkbox" name="record[<?php echo ($x); ?>][MUAreaMgr]" <?php if($row1["MUAreaMgr"]){echo " CHECKED";} ?> /></td>
<td><input type="checkbox" name="record[<?php echo ($x); ?>][StAreaMgr]" <?php if($row1["StAreaMgr"]){echo " CHECKED";} ?> /></td>
<td><input type="checkbox" name="record[<?php echo ($x); ?>][MFAreaMgr]" <?php if($row1["MFAreaMgr"]){echo " CHECKED";} ?> /></td>
<td><input type="checkbox" name="record[<?php echo ($x); ?>][SCContact]" <?php if($row1["SCContact"]){echo " CHECKED";} ?> /></td>
<td><input type="checkbox" name="record[<?php echo ($x); ?>][VMAttendee]" <?php if($row1["VMAttendee"]){echo " CHECKED";} ?> /></td>
<td><input type="checkbox" name="record[<?php echo ($x); ?>][ConMgr]" <?php if($row1["ConMgr"]){echo " CHECKED";} ?> /></td>
<td><input type="checkbox" name="record[<?php echo ($x); ?>][SiteSuper]" <?php if($row1["SiteSuper"]){echo " CHECKED";} ?> /></td>
<td><input type="checkbox" name="record[<?php echo ($x); ?>][SiteSuperAsst]" <?php if($row1["SiteSuperAsst"]){echo " CHECKED";} ?> /></td>
<td><input type="checkbox" name="record[<?php echo ($x); ?>][VIPOpenInvite]" <?php if($row1["VIPOpenInvite"]){echo " CHECKED";} ?> /></td>
<td><input type="checkbox" name="record[<?php echo ($x); ?>][CCCLunchInvite]" <?php if($row1["CCCLunchInvite"]){echo " CHECKED";} ?> /></td></tr>
<?php ++$x; ?>
<?php }?>Code: Select all
$rowData = $_POST["record"];
$n = count($rowData);
$i = 0;
echo("rowData count is: " . $n);
while ($i < $n)
{
$query2 = "UPDATE communities SET HOContact='" . $rowData[$i]["HOContact"] . "',HOAcctContact='" . $rowData[$i]["HOAcctContact"] .
"',MUAreaMgr='" . $rowData[$i]["MUAreaMgr"] . "',StAreaMgr='" . $rowData[$i]["StAreaMgr"] . "',MFAreaMgr='" . $rowData[$i]["MFAreaMgr"] .
"',SCContact='" . $rowData[$i]["SCContact"] . "',VMAttendee='" . $rowData[$i]["VMAtttendee"] . "',ConMgr='" . $rowData[$i]["ConMgr"] .
"',SiteSuper='" . $rowData[$i]["SiteSuper"] . "',SiteSuperAsst='" . $rowData[$i]["SiteSuperAsst"] .
"',VIPOpenInvite='" . $rowData[$i]["VIPOpenInvite"] . "',CCCLunchInvite='" . $rowData[$i]["CCCLunchInvite"] . "' WHERE CName=" . $rowData[$i]["CName"] . " AND ContactID=" . $id;
echo("Exisiting record SQL for Communities Table: " . $query2 . "<br><br>");
$i++;
}Code: Select all
rowData count is: 4
Notice: Undefined index: HOAcctContact in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\savemisc.php on line 51
Notice: Undefined index: StAreaMgr in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\savemisc.php on line 52
Notice: Undefined index: MFAreaMgr in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\savemisc.php on line 52
Notice: Undefined index: SCContact in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\savemisc.php on line 53
Notice: Undefined index: VMAtttendee in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\savemisc.php on line 53
Notice: Undefined index: ConMgr in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\savemisc.php on line 53
Notice: Undefined index: SiteSuper in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\savemisc.php on line 54
Notice: Undefined index: SiteSuperAsst in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\savemisc.php on line 54
Notice: Undefined index: VIPOpenInvite in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\savemisc.php on line 55
Notice: Undefined index: CCCLunchInvite in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\savemisc.php on line 55
Exisiting record SQL for Communities Table: UPDATE communities SET HOContact='on',HOAcctContact='',MUAreaMgr='on',StAreaMgr='',MFAreaMgr='',SCContact='',VMAttendee='',ConMgr='',SiteSuper='',SiteSuperAsst='',VIPOpenInvite='',CCCLunchInvite='' WHERE CName=Secord AND ContactID=280Code: Select all
foreach($rowData as $v)
{
$query2 = "UPDATE communities SET HOContact='" . $v["HOContact"] . "',HOAcctContact='" . $v["HOAcctContact"] .
"',MUAreaMgr='" . $v["MUAreaMgr"] . "',StAreaMgr='" . $v["StAreaMgr"] . "',MFAreaMgr='" . $v["MFAreaMgr"] .
"',SCContact='" . $v["SCContact"] . "',VMAttendee='" . $v["VMAttendee"] . "',ConMgr='" . $v["ConMgr"] .
"',SiteSuper='" . $v["SiteSuper"] . "',SiteSuperAsst='" . $v["SiteSuperAsst"] .
"',VIPOpenInvite='" . $v["VIPOpenInvite"] . "',CCCLunchInvite='" . $v["CCCLunchInvite"] . "' WHERE CName=" . $v["CName"] . " AND ContactID=" . $id;
echo("Exisiting record SQL for Communities Table: " . $query2 . "<br><br>");
}Code: Select all
if( isset($_POST['rowData']) and is_array($_POST['rowData']))
{
$blank = array(
'HOContact' => 0,
'HOAcctContact' => 0,
// etc
);
foreach($_POST['rowData'] as $record)
{
$h = $blank;
if(is_array($record))
{
foreach($record as $k => $v)
{
if(isset($blank[$k]))
{
$h[$k] = 1;
}
}
}
// do your query here.
}
}Code: Select all
foreach($rowData as $v)
{
if($v["HOContact"]) {$v["HOContact"] = 1;} else {$v["HOContact"] = 0;}
if($v["HOAcctContact"]) {$v["HOAcctContact"] = 1;} else {$v["HOAcctContact"] = 0;}
if($v["MUAreaMgr"]) {$v["MUAreaMgr"] = 1;} else {$v["MUAreaMgr"] = 0;}
if($v["StAreaMgr"]) {$v["StAreaMgr"] = 1;} else {$v["StAreaMgr"] = 0;}
if($v["MFAreaMgr"]) {$v["MFAreaMgr"] = 1;} else {$v["MFAreaMgr"] = 0;}
if($v["SCContact"]) {$v["SCContact"] = 1;} else {$v["SCContact"] = 0;}
if($v["VMAttendee"]) {$v["VMAttendee"] = 1;} else {$v["VMAttendee"] = 0;}
if($v["ConMgr"]) {$v["ConMgr"] = 1;} else {$v["ConMgr"] = 0;}
if($v["SiteSuper"]) {$v["SiteSuper"] = 1;} else {$v["SiteSuper"] = 0;}
if($v["SiteSuperAsst"]) {$v["SiteSuperAsst"] = 1;} else {$v["SiteSuperAsst"] = 0;}
if($v["VIPOpenInvite"]) {$v["VIPOpenInvite"] = 1;} else {$v["VIPOpenInvite"] = 0;}
if($v["CCCLunchInvite"]) {$v["CCCLunchInvite"] = 1;} else {$v["CCCLunchInvite"] = 0;}
$query2 = "UPDATE communities SET HOContact='" . $v["HOContact"] . "',HOAcctContact='" . $v["HOAcctContact"] .
"',MUAreaMgr='" . $v["MUAreaMgr"] . "',StAreaMgr='" . $v["StAreaMgr"] . "',MFAreaMgr='" . $v["MFAreaMgr"] .
"',SCContact='" . $v["SCContact"] . "',VMAttendee='" . $v["VMAttendee"] . "',ConMgr='" . $v["ConMgr"] .
"',SiteSuper='" . $v["SiteSuper"] . "',SiteSuperAsst='" . $v["SiteSuperAsst"] .
"',VIPOpenInvite='" . $v["VIPOpenInvite"] . "',CCCLunchInvite='" . $v["CCCLunchInvite"] . "' WHERE CName=" . $v["CName"] . " AND ContactID=" . $id;
echo("Exisiting record SQL for Communities Table: " . $query2 . "<br><br>");
}