Mam tabele w MySQL, tworze tak:
CREATE TABLE users (id smallint(5) NOT NULL, login varchar(30) NOT NULL default , password varchar(30) NOT NULL default
, email varchar(30) NOT NULL default '', first_name varchar(30) default NULL, surname varchar(30) default NULL, city varchar(40) default NULL, PRIMARY KEY(id))
Pola: ID, Login, Password, Email, First_Name, Surname, City, ID to Primary Key.
Teraz probuje dodac usera:
INSERT INTO users VALUES($Admin_Login, $Admin_Pass, $Admin_Mail, $Admin_Name, $Admin_Surname, $Admin_City)'
Wyskakuje blad (w phpMyAdmin):
#1136 - Column count doesn't match value count at row 1
O co chodzi? :/