Frustrating situation of this is working before but not now moments!
I have a form: (only gonna show part of this as its huge)
<?php
include("include/session.php");
$username = $_SESSION['username'];
$_SESSION['formdata1'] = '';
include("connect.php");
// query
$sql = "SELECT * FROM qualityuser WHERE username = '".$username."'";
$result = mysql_query($sql);
// if we have rows, fetch them
if(mysql_num_rows($result) > 0) {
$row = mysql_fetch_array($result);
} else {
$row = array('time'=>'','demand'=>'','external_support'=>'','training'=>'','complexity'=>'','depth'=>'','partuse'=>''
,'cost'=>'' ,'orgwhole'=>'','external_validated'=>'','advocacy'=>'','advice'=>'','animal'=>'','art'=>'','aware'=>'','childcare'=>'','commdev'=>'','commrep'=>'','commsafe'=>'','conservation'=>'','counselling'=>'','crisis'=>'','credit'=>'','daycentre'=>'','cultural'=>'','daycare'=>'','debt'=>'');
}
?>
///////dreamweaver template output/////
<select name="external_validated" id="external_validated">
<?php
$values = array('Essential', 'Desirable','Preferably not','Neither important nor unimportant');
foreach($values as $val)
{
printf("<option%s>$val</option>\n", ($val == $row['external_validated']) ? " selected" : "");
}
?>
</select>
echo '<input type="checkbox" name="advocacy" value="1"';
if ($row['advocacy'] == 1) {echo 'checked';} echo '>'
?><input name="advocacy" type="hidden" value="0"></td>
<td width="132" height="29"> Advice & Guidance </td>
<td width="29"><?php
echo '<input type="checkbox" name="advice" value="1"';
if ($row['advice'] == 1) {echo 'checked';} echo '>'
?>
<input name="advice" type="hidden" id="advice" value="0">
</td>
<td width="104">Animal welfare </td>
<td width="17"><?php
echo '<input type="checkbox" name="animal" value="1"';
if ($row['animal'] == 1) {echo 'checked';} echo '>'
?><input name="animal" type="hidden" value="0">
and my formhandler...
if (isset($_POST['submit'])) {
$answer = array();
$answer[1] = $_POST['time'];
$answer[2] = $_POST['demand'];
$answer[3] = $_POST['external_support'];
$answer[4] = $_POST['training'];
$answer[5] = $_POST['complexity'];
$answer[6] = $_POST['depth'];
$answer[7] = $_POST['partuse'];
$answer[8] = $_POST['cost'];
$answer[9] = $_POST['orgwhole'];
$answer[10] = $_POST['external_validated'];
$answers[11] = $_POST['advocacy'];
$answers[12] = $_POST['advice'];
$answers[13] = $_POST['animal'];
$answers[14] = $_POST['art'];
$answers[15] = $_POST['aware'];
$answers[16] = $_POST['childcare'];
$answers[17] = $_POST['commdev'];
$answers[18] = $_POST['commrep'];
$answers[19] = $_POST['commsafe'];
$answers[20] = $_POST['conservation'];
$answers[21] = $_POST['counselling'];
$answers[22] = $_POST['crisis'];
$answers[23] = $_POST['credit'];
$answers[24] = $_POST['cultural'];
$answers[25] = $_POST['daycare'];
$answers[26] = $_POST['daycentre'];
$answers[27] = $_POST['debt'];
$answers[28] = $_POST['domiciliary'];
$answers[29] = $_POST['education'];
//etc//
$sql = "UPDATE qualityuser SET time = '$answer[1]',
demand = '$answer[2]',
external_support = '$answer[3]',
training = '$answer[4]',
complexity = '$answer[5]',
depth = '$answer[6]',
partuse = '$answer[7]',
cost = '$answer[8]',
orgwhole = '$answer[9]',
external_validated = '$answer[10]'
advocacy = '$answer[11]',
advice = '$answer[12]',
animal = '$answer[13]',
art = '$answer[14]',
aware = '$answer[15]',
childcare = '$answer[16]',
commdev = '$answer[17]',
commrep = '$answer[18]',
commsafe = '$answer[19]',
conservation = '$answer[20]',
counselling = '$answer[21]',
crisis = '$answer[22]',
credit = '$answer[23]',
cultural = '$answer[24]',
daycare = '$answer[25]',
daycentre = '$answer[26]',
debt = '$answer[27]',
domiciliary = '$answer[28]',
education = '$answer[29]',
equipment = '$answer[30]',
financial = '$answer[31]',
health = '$answer[32]',
///etc
WHERE username = '$username'";
mysql_query($sql) or exit(mysql_error());
}
but for some reason I get an undefined index error when the hidden fields should cure this
Notice: Undefined index: 11 in /var/www/vhosts/mindseyemidlands.co.uk/httpdocs/notts_quality/info_resource/selfassess_part2_intermediary.php on line 81
Notice: Undefined index: 12 in /var/www/vhosts/mindseyemidlands.co.uk/httpdocs/notts_quality/info_resource/selfassess_part2_intermediary.php on line 82
Notice: Undefined index: 13 in /var/www/vhosts/mindseyemidlands.co.uk/httpdocs/notts_quality/info_resource/selfassess_part2_intermediary.php on line 83
