Mam taki formularz:
<?
if(isset($_POST['edycja'])){ echo '<form action=viewa.php method=post>'; echo '<input type=hidden name=id value=10>'; echo '<input type=hidden name=upraw value=4>'; echo '<input type=hidden name=mod value=8>'; foreach($_POST['option'] as $ng)
{
$zapytanie=\"SELECT * FROM sms_ng WHERE ng='$ng'\";
{
echo '<table border=0 align=center cellspacing=0 cellpadinng=0>'; echo '<tr><td>NG: </td><td><input type=text name=\"ng_n[]\" maxlength=3 size=3 value=\"'.$pole['ng'].'\"><input type=hidden name=\"ng[]\" value=\"'.$pole['ng'].'\"></td></tr>'; echo '<tr><td>Model:</td><td><select name=\"model[]\">'; $telefony = Array('Nokia', 'Siemens', 'Sony Ericsson', 'Samsung', 'Alcatel', 'Ericsson', 'Motorola', 'Sagem', 'Sendo', 'Mitsubishi', 'Panasonic'); foreach($telefony as $telefon){
if($telefon == $pole['model']){
print(\"<option value=\"$telefon\" selected>$telefon</option>\"); }else{
print(\"<option value=\"$telefon\">$telefon</option>\"); }
}
echo '</select></td></tr>'; echo '<tr><td>Nazwa:</td><td><input type=text name=\"nazwa[]\" value=\"'; echo '<tr><td>X <small>(wszystkich)</small>:</td><td><input type=text maxlength=2 size=3 name=\"x[]\" value=\"'; echo '<tr><td>K <small>(kolumn)</small>:</td><td><input type=text maxlength=2 size=3 name=\"k[]\" value=\"'; echo '<tr><td>WIDTH <small>(szerokość)</small>:</td><td><input type=text maxlength=3 size=3 name=\"width[]\" value=\"'; echo '<tr><td>HEIGHT <small>(długość)</small>:</td><td><input type=text maxlength=3 size=3 name=\"height[]\" value=\"'; echo '<tr><td colspan=2 align=center><hr></td></tr></table><br>'; }
}
echo '<div align=center><input type=submit value=Zapisz> <input type=\"button\" onclick=\"history.back()\" value=\"Wstecz\"></form></div>'; ?>
I akcja:
<?
foreach($_POST['ng'] as $klucz=>$ng)
{
$zapytanie=\"UPDATE sms_ng SET
ng='\".$_POST['ng_n'][$klucz].\"', model='\".$_POST['model'][$klucz].\"', nazwa='\".$_POST['nazwa'][$klucz].\"',
x='\".$_POST['x'][$klucz].\"',
k='\".$_POST['k'][$klucz].\"'
width='\".$_POST['width'][$klucz].\"',
height='\".$_POST['height'][$klucz].\"',
WHERE ng='\".$ng.\"'\";
}
?>
i niestety nie wiem dalczego pojawia sie taki bład:
Nie można dodać! 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 'width='0', height='0' WHERE ng='3'' at line 1Struktura tabeli:
ng int(3)
model text
nazwa text
x int(2)
k int(2)
width int(4)
height int(4) Prosze poórzcie to jest bardzo wazne!