Help with Update Multiple records
I haven't been able to get this working unfortunately. At the moment it looks like its doing odd things, for example if I try to uptick any boxes, another gets added to the ones that are ticked.
Details below...
I haven't been able to get this working unfortunately. At the moment it looks like its doing odd things, for example if I try to uptick any boxes, another gets added to the ones that are ticked.
Details below...
the repeat selection code is outside the recordset loop, it should be inside.
change lines 362 - 394:
<?php
// RepeatSelectionCounter_1 Begin Loop
$RepeatSelectionCounter_1_IterationsRemaining = $RepeatSelectionCounter_1_Iterations;
while($RepeatSelectionCounter_1_IterationsRemaining--){
if($RepeatSelectionCounterBasedLooping_1 || $row_WADAlodges){
?>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<?php do { ?>
<tr class="<?php echo $WARRT_AltClass1->getClass(true); ?>">
<td class="lodgelist"><?php echo($row_WADAlodges['NominationID']); ?> - <a href="../results/index.php?LodgeID=<?php echo(rawurlencode($row_WADAlodges['LodgeID'])); ?>" ><?php echo($row_WADAlodges['Lodge']); ?></a></td>
<td class="votes"><?php echo($row_WADAlodges['scoreCount']); ?></td>
<td class="average"><?php echo($row_WADAlodges['AverageScore']); ?></td>
<?php /*START_PHP_SIRFCIT*/ if ($row_SecurityAssisttradeusers['UserID']=="332"){ ?>
<td class="judgefinalist"><input type="hidden" name="WADA_RepeatID_NominationID_<?php echo $RepeatSelectionCounter_1; ?>" id="WADA_RepeatID_NominationID_<?php echo $RepeatSelectionCounter_1; ?>" value="<?php echo $row_WADAlodges["NominationID"]; ?>" />
<input <?php if (!(strcmp($row_WADAlodges['SW_finalist'],"Yes"))) {echo "checked=\"checked\"";} ?> type="checkbox" name="SW_finalist_<?php echo $RepeatSelectionCounter_1; ?>" value="Yes"/></td>
<td class="judgerank"><input type="text" class="rankfield" name="SW_rank_<?php echo $RepeatSelectionCounter_1; ?>" value="<?php echo($row_WADAlodges['SW_rank']); ?>" /></td>
<?php } /*END_PHP_SIRFCIT*/ ?>
</tr>
<?php } while ($row_WADAlodges = mysql_fetch_assoc($WADAlodges)); ?>
</table>
<?php
} // RepeatSelectionCounter_1 Begin Alternate Content
else{
?>
<td>No records match your request.</td>
<?php } // RepeatSelectionCounter_1 End Alternate Content
if(!$RepeatSelectionCounterBasedLooping_1 && $RepeatSelectionCounter_1_IterationsRemaining != 0){
if(!$row_WADAlodges && $RepeatSelectionCounter_1_Iterations == -1){$RepeatSelectionCounter_1_IterationsRemaining = 0;}
$row_WADAlodges = mysql_fetch_assoc($WADAlodges);
}
$RepeatSelectionCounter_1++;
} // RepeatSelectionCounter_1 End Loop
?>
to:
<?php do { ?>
<?php
// RepeatSelectionCounter_1 Begin Loop
$RepeatSelectionCounter_1_IterationsRemaining = $RepeatSelectionCounter_1_Iterations;
while($RepeatSelectionCounter_1_IterationsRemaining--){
if($RepeatSelectionCounterBasedLooping_1 || $row_WADAlodges){
?>
<tr class="<?php echo $WARRT_AltClass1->getClass(true); ?>">
<td class="lodgelist"><?php echo($row_WADAlodges['NominationID']); ?> - <a href="../results/index.php?LodgeID=<?php echo(rawurlencode($row_WADAlodges['LodgeID'])); ?>" ><?php echo($row_WADAlodges['Lodge']); ?></a></td>
<td class="votes"><?php echo($row_WADAlodges['scoreCount']); ?></td>
<td class="average"><?php echo($row_WADAlodges['AverageScore']); ?></td>
<?php /*START_PHP_SIRFCIT*/ if ($row_SecurityAssisttradeusers['UserID']=="332"){ ?>
<td class="judgefinalist"><input type="hidden" name="WADA_RepeatID_NominationID_<?php echo $RepeatSelectionCounter_1; ?>" id="WADA_RepeatID_NominationID_<?php echo $RepeatSelectionCounter_1; ?>" value="<?php echo $row_WADAlodges["NominationID"]; ?>" />
<input <?php if (!(strcmp($row_WADAlodges['SW_finalist'],"Yes"))) {echo "checked=\"checked\"";} ?> type="checkbox" name="SW_finalist_<?php echo $RepeatSelectionCounter_1; ?>" value="Yes"/></td>
<td class="judgerank"><input type="text" class="rankfield" name="SW_rank_<?php echo $RepeatSelectionCounter_1; ?>" value="<?php echo($row_WADAlodges['SW_rank']); ?>" /></td>
<?php } /*END_PHP_SIRFCIT*/ ?>
</tr>
<?php
} // RepeatSelectionCounter_1 Begin Alternate Content
else{
?>
<td>No records match your request.</td>
<?php } // RepeatSelectionCounter_1 End Alternate Content
if(!$RepeatSelectionCounterBasedLooping_1 && $RepeatSelectionCounter_1_IterationsRemaining != 0){
if(!$row_WADAlodges && $RepeatSelectionCounter_1_Iterations == -1){$RepeatSelectionCounter_1_IterationsRemaining = 0;}
$row_WADAlodges = mysql_fetch_assoc($WADAlodges);
}
$RepeatSelectionCounter_1++;
} // RepeatSelectionCounter_1 End Loop
?>
<?php } while ($row_WADAlodges = mysql_fetch_assoc($WADAlodges)); ?>
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.