<? foreach($_POST['option'] as $ng) { $zapytanie=\"SELECT * FROM sms_ng WHERE ng='$ng'\"; { 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>'; $telefony = Array('Nokia', 'Siemens', 'Sony Ericsson', 'Samsung', 'Alcatel', 'Ericsson', 'Motorola', 'Sagem', 'Sendo', 'Mitsubishi', 'Panasonic'); foreach($telefony as $telefon){ if($telefon == $pole['model']){ }else{ } } 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 '<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 1
Struktura 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!