Thanks Dave
Still the same, I shifted the code around as per yours to see what changes were required and could not get it to work. I then copied a your code completely and still no go. Here is the current code for the page. The page comes up with no errors, entries can be changed, when you click the submit button it does not redirect to the ladders page but simply reverts to the original entries? You suggest there may be a "bug" how do I fix that? Thankyou for your assistance
<?php require_once('../Connections/connvbsa.php'); ?>
<?php require_once("../WA_DataAssist/WA_AppBuilder_PHP.php"); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_connvbsa, $connvbsa);
$query_Team_Score_Edit = "SELECT team_id, team_name, team_grade, Result_pos, Result_score, HB FROM Team_entries WHERE Team_entries.team_grade='APB'";
$Team_Score_Edit = mysql_query($query_Team_Score_Edit, $connvbsa) or die(mysql_error());
$row_Team_Score_Edit = mysql_fetch_assoc($Team_Score_Edit);
$totalRows_Team_Score_Edit = mysql_num_rows($Team_Score_Edit);?>
<?php
// WA DataAssist Multiple Updates
if (isset($_POST["button_<?php echo $RepeatSelectionCounter_1; ?>"])) // Trigger
{
if (!session_id()) session_start();
$WA_loopedIDField = array("WADA_RepeatID_team_id");
$WA_connection = $connvbsa;
$WA_table = "Team_entries";
$WA_redirectURL = "Ladders.php";
$WA_keepQueryString = false;
$WA_indexField = "team_id";
$WA_fieldNamesStr = "Result_pos|Result_score|HB";
$WA_columnTypesStr = "none,none,NULL|none,none,NULL|',none,''";
$WA_fieldNames = explode("|", $WA_fieldNamesStr);
$WA_columns = explode("|", $WA_columnTypesStr);
$WA_connectionDB = $database_connvbsa;
$WA_multipleUpdateCounter = 0;
mysql_select_db($WA_connectionDB, $WA_connection);
while (WA_AB_checkLoopedFieldsNotBlank($WA_loopedIDField, $WA_multipleUpdateCounter)) {
$WA_fieldValuesStr = "".$row_Team_Score_Edit['Result_pos'] ."" . "|" . "".$row_Team_Score_Edit['Result_score'] ."" . "|" . "".$row_Team_Score_Edit['HB'] ."";
$WA_fieldValues = explode("|", $WA_fieldValuesStr);
$WA_where_fieldValuesStr = WA_AB_getLoopedFieldValue($WA_loopedIDField[0], $WA_multipleUpdateCounter);
$WA_where_columnTypesStr = "none,none,NULL";
$WA_where_comparisonStr = "=";
$WA_where_fieldNames = explode("|", $WA_indexField);
$WA_where_fieldValues = explode("|", $WA_where_fieldValuesStr);
$WA_where_columns = explode("|", $WA_where_columnTypesStr);
$WA_where_comparisons = explode("|", $WA_where_comparisonStr);
$updateParamsObj = WA_AB_generateInsertParams($WA_fieldNames, $WA_columns, $WA_fieldValues, -1);
$WhereObj = WA_AB_generateWhereClause($WA_where_fieldNames, $WA_where_columns, $WA_where_fieldValues, $WA_where_comparisons );
$WA_Sql = "UPDATE `" . $WA_table . "` SET " . $updateParamsObj->WA_setValues . " WHERE " . $WhereObj->sqlWhereClause . "";
$MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error());
$WA_multipleUpdateCounter++;
}
if ($WA_redirectURL != "") {
if ($WA_keepQueryString && $WA_redirectURL != "" && isset($_SERVER["QUERY_STRING"]) && $_SERVER["QUERY_STRING"] !== "" && sizeof($_POST) > 0) {
$WA_redirectURL .= ((strpos($WA_redirectURL, '?') === false)?"?":"&").$_SERVER["QUERY_STRING"];
}
header("Location: ".$WA_redirectURL);
}
}
?><?php
// RepeatSelectionCounter_1 Initialization
$RepeatSelectionCounter_1 = 0;
$RepeatSelectionCounterBasedLooping_1 = false;
$RepeatSelectionCounter_1_Iterations = "1";
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<!-- DW6 -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>VBSA Administrative area</title>
<script src="../Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
<link href="../CSS/vbsa_DB.css" rel="stylesheet" type="text/css" />
</head>
<body>
<center>
<form id="form1" name="form1" method="post" action="">
<table border="0">
<?php do { ?>
<?php
// RepeatSelectionCounter_1 Begin Loop
$RepeatSelectionCounter_1_IterationsRemaining = $RepeatSelectionCounter_1_Iterations;
while($RepeatSelectionCounter_1_IterationsRemaining--){
if($RepeatSelectionCounterBasedLooping_1 || $row_Team_Score_Edit){
?>
<tr>
<td>Team</td>
<td><input type="hidden" name="WADA_RepeatID_team_id_<?php echo $RepeatSelectionCounter_1; ?>" id="WADA_RepeatID_team_id_<?php echo $RepeatSelectionCounter_1; ?>" value="<?php echo $row_Team_Score_Edit["team_id"]; ?>" />
<input type="text" name="Result_pos_<?php echo $RepeatSelectionCounter_1; ?>" value="<?php echo htmlentities($row_Team_Score_Edit['Result_pos'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
<td><input type="text" name="Result_score_<?php echo $RepeatSelectionCounter_1; ?>" value="<?php echo htmlentities($row_Team_Score_Edit['Result_score'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
<td><input type="text" name="HB_<?php echo $RepeatSelectionCounter_1; ?>" value="<?php echo htmlentities($row_Team_Score_Edit['HB'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</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_Team_Score_Edit && $RepeatSelectionCounter_1_Iterations == -1){$RepeatSelectionCounter_1_IterationsRemaining = 0;}
$row_Team_Score_Edit = mysql_fetch_assoc($Team_Score_Edit);
}
$RepeatSelectionCounter_1++;
} // RepeatSelectionCounter_1 End Loop
?>
<?php } while ($row_Team_Score_Edit = mysql_fetch_assoc($Team_Score_Edit)); ?>
<tr>
<td> </td>
<td><input type="submit" name="button_<?php echo $RepeatSelectionCounter_1; ?>" id="button_<?php echo $RepeatSelectionCounter_1; ?>" value="Submit" /></td>
<td> </td>
<td> </td>
</tr>
</table>
</form>
</center>
</body>
</html>
<?php
mysql_free_result($Team_Score_Edit);
?>