now the error is
Code: Select all
Unknown column '$_POST[id]' in 'field list'Moderator: General Moderators
Code: Select all
Unknown column '$_POST[id]' in 'field list'please include all your code here, maybe I can help you ^^wolfwood16 wrote:yeah, the $DB exist...
now the error is
Code: Select all
Unknown column '$_POST[id]' in 'field list'
really strange..........
Code: Select all
$nameid = $_POST['name'];
$middlenameid = $_POST['middlename'];
$surnameid = $_POST['surname'];
// Read documentation about foreach!
foreach($nameid as $key => $value)
{
$insertNow = 'INSERT INTO '.$DB.' (id, namefields, middlenamefields, surnamefields) VALUES ('.$_POST['id'].', '.$nameid[$key].', '.$middlenameid[$key].', '.$surnameid[$key].')';
mysql_query($insertNow, $connString) or die($insertNow.' <br> '.mysql_error());
// $nameid is an array. And you cannot print variable due print() echo() or some else
}
Code: Select all
INSERT INTO theActualCode(id,subj_code,subj_desc,lec_hrs,lab_hrs,subj_units) VALUES( `$_POST[id]`,`$subjCode[$v]`,`$subjDesc[$v]`,`$subjLecHrs[$v]`,`$subjLabHrs[$v]`,`$subjUnits[$v]` )
Unknown column '$_POST[id]' in 'field list'
Code: Select all
$subjID = $_POST[id];
//and put on the value to be stored is
....subj_units) VALUES( `$subjID[$v]`,`$subjCode[$v]`.....
Code: Select all
Unknown column '$subjID[$v]' in 'field list'Ziq wrote:Are you sure?
PHP code:Code: Select all
$nameid = $_POST['name']; $middlenameid = $_POST['middlename']; $surnameid = $_POST['surname']; // Read documentation about foreach! foreach($nameid as $key => $value) { $insertNow = 'INSERT INTO '.$DB.' (id, namefields, middlenamefields, surnamefields) VALUES ('.$_POST['id'].', '.$nameid[$key].', '.$middlenameid[$key].', '.$surnameid[$key].')'; mysql_query($insertNow, $connString) or die($insertNow.' <br> '.mysql_error()); // $nameid is an array. And you cannot print variable due print() echo() or some else }
Code: Select all
$nameid = $_POST['name'];
$middlenameid = $_POST['middlename'];
$surnameid = $_POST['surname'];
$id = $_POST['id'];
// Read documentation about foreach!
foreach($nameid as $key => $value)
{
$insertNow = 'INSERT INTO '.$DB.' (id, namefields, middlenamefields, surnamefields) VALUES ('$id', '.$nameid[$key].', '.$middlenameid[$key].', '.$surnameid[$key].')';
mysql_query($insertNow, $connString) or die($insertNow.' <br> '.mysql_error());
// $nameid is an array. And you cannot print variable due print() echo() or some else
}
Ziq wrote:Are you sure?
PHP code:Code: Select all
$nameid = $_POST['name']; $middlenameid = $_POST['middlename']; $surnameid = $_POST['surname']; // Read documentation about foreach! foreach($nameid as $key => $value) { $insertNow = 'INSERT INTO '.$DB.' (id, namefields, middlenamefields, surnamefields) VALUES ('.$_POST['id'].', '.$nameid[$key].', '.$middlenameid[$key].', '.$surnameid[$key].')'; mysql_query($insertNow, $connString) or die($insertNow.' <br> '.mysql_error()); // $nameid is an array. And you cannot print variable due print() echo() or some else }
Code: Select all
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near
'`.$subjLecHrs[$v].`,`.$subjLabHrs[$v].`,`.$subjUnits[$v].` )' at line 3
Code: Select all
<td> <input name="subjcode[]" type="text" size="8"> </td>
<td> <input name="subjdesc[]" type="text" size="50"> </td>
<td> <input name="subjlechrs[]" type="text" size="8" maxlength="1"> </td>
<td> <input name="subjlabhrs[]" type="text" size="8" maxlength="1"> </td>
<td> <input name="subjunits[]" type="text" size="8" maxlength="1"> </td>
</tr>
<tr>
<td> <input name="subjcode[]" type="text" size="8"> </td>
<td> <input name="subjdesc[]" type="text" size="50"> </td>
<td> <input name="subjlechrs[]" type="text" size="8" maxlength="1"> </td>
<td> <input name="subjlabhrs[]" type="text" size="8" maxlength="1"> </td>
<td> <input name="subjunits[]" type="text" size="8" maxlength="1"> </td>
</tr>
<tr>
<td> <input name="subjcode[]" type="text" size="8"> </td>
<td> <input name="subjdesc[]" type="text" size="50"> </td>
<td> <input name="subjlechrs[]" type="text" size="8" maxlength="1"> </td>
<td> <input name="subjlabhrs[]" type="text" size="8" maxlength="1"> </td>
<td> <input name="subjunits[]" type="text" size="8" maxlength="1"> </td>
</tr>
Code: Select all
$subjCode = $_POST[subjcode];
$subjID = $_POST[id];
$subjDesc = $_POST[subjdesc];
$subjLecHrs = $_POST[subjlechrs];
$subjLabHrs = $_POST[subjlabhrs];
$subjUnits = $_POST[subjunits];
foreach ($subjCode as $v => $a){
print_r($subjCode);
$addSubjCode = 'INSERT INTO '.$sessionNewCurrName.'(id,subj_code,subj_desc,lec_hrs,lab_hrs,subj_units)
VALUES(
`$subjID`,`$subjCode[$v]`,`$subjDesc[$v]`,`$subjLecHrs[$v]`,`$subjLabHrs[$v]`,`$subjUnits[$v]`
)';
mysql_query($addSubjCode, $conn) or die($addSubjCode." <br> ".mysql_error());
}
Code: Select all
Array ( [0] => a [1] => b [2] => c [3] => d [4] => e [5] => f [6] => g [7] => h [8] => i [9] => j ) INSERT INTO newtableCurriculum(id,subj_code,subj_desc,lec_hrs,lab_hrs,subj_units) VALUES( `$subjID`,`$subjCode[$v]`,`$subjDesc[$v]`,`$subjLecHrs[$v]`,`$subjLabHrs[$v]`,`$subjUnits[$v]` )
Unknown column '$subjID' in 'field list'bungkusan wrote:# Unknown column '$subjID' in 'field list'
on the form page did you send your id via POST method?
Code: Select all
Array ( [0] => first [1] => second [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => ) INSERT INTO newtableCurriculum(id, subj_code, subj_desc, lec_hrs, lab_hrs, subj_units) VALUES( , first, desc1, 3, 2, 3 )
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' first, desc1, 3, 2, 3 )' at line 3
Code: Select all
$addSubjCode = "INSERT INTO '.$sessionNewCurrName.'(id,subj_code,subj_desc,lec_hrs,lab_hrs,subj_units) VALUES( '$subjID', '$subjCode[$v]', '$subjDesc[$v]', '$subjLecHrs[$v]', '$subjLabHrs[$v]', '$subjUnits[$v]')";bungkusan wrote:Please use this code :
replace the existing your sql commandCode: Select all
$addSubjCode = "INSERT INTO '.$sessionNewCurrName.'(id,subj_code,subj_desc,lec_hrs,lab_hrs,subj_units) VALUES( '$subjID', '$subjCode[$v]', '$subjDesc[$v]', '$subjLecHrs[$v]', '$subjLabHrs[$v]', '$subjUnits[$v]')";
Code: Select all
foreach ($subjCode as $v => $a){
print_r($subjCode);
$addSubjCode = "INSERT INTO $sessionNewCurrName(id, subj_code, subj_desc, lec_hrs, lab_hrs, subj_units)
VALUES(
'$subjID', '$subjCode[$v]', '$subjDesc[$v]', '$subjLecHrs[$v]', '$subjLabHrs[$v]', '$subjUnits[$v]'
)";
mysql_query($addSubjCode, $conn) or die($addSubjCode." <br> ".mysql_error());
}