From: Aykut ARDIÇ (aykut@fuardunyasi.com)
Date: Tue 06 Apr 2004 - 15:09:08 EEST
insert ederken asagidaki ifadeyi kullanmissin ama var olan table üzerinde "vergidairesi ve notlar" diye bi field olmadigindan kayit gerçeklesmiyo sana önere bilecegim ya table a "vergidairesi ve notlar" field lerini aç yada asagida önerdigim sorguyu kullan
Çalismayan sorgu :
INSERT INTO $table (firstname, lastname, address, home, mobile, work, email, email2, vergidairesi, notlar) VALUES ('$firstname','$lastname','$address','$home','$mobile','$work','$email','$email2','$vergidairesi','$notlar')
Önerilen sorgu
INSERT INTO $table (firstname, lastname, address, home, mobile, work, email, email2) VALUES ('$firstname','$lastname','$address','$home','$mobile','$work','$email','$email2')
table içerigi
_____________________________________
CREATE TABLE addressbook (
id int(9) unsigned NOT NULL auto_increment,
firstname varchar(255) NOT NULL,
lastname varchar(255) NOT NULL,
address text NOT NULL,
home text NOT NULL,
mobile text NOT NULL,
work text NOT NULL,
email text NOT NULL,
email2 text NOT NULL,
bday tinyint(2) NOT NULL,
bmonth varchar(50) NOT NULL,
byear varchar(4) NOT NULL,
PRIMARY KEY (id)
);
INSERT INTO addressbook (firstname, lastname, address, home, mobile, work, email, email2, vergidairesi, notlar) VALUES ('sdf','sdfs','fsdf','sdf','sdfs','sdf','sdfs','dfsd','fsdf','sdfsfd')Could not query:Unknown column 'vergidairesi' in 'field list'
Iyi Çalismalar
Aykut ARDIÇ