Code: Select all
UPDATE dep_list='1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,24,25,26,'
WHERE user_id=35i recive only :
Code: Select all
1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,why is that?
thnaks i nadvance
peleg
Moderator: General Moderators
Code: Select all
UPDATE dep_list='1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,24,25,26,'
WHERE user_id=35Code: Select all
1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,Code: Select all
CREATE TABLE /*!32300 IF NOT EXISTS*/ users (
user_id tinyint(3) unsigned NOT NULL auto_increment,
user_name varchar(10) ,
user_name_heb varchar(30) ,
user_pass varchar(10) ,
firm_list varchar(20) ,
level enum('1','0') NOT NULL DEFAULT '1' ,
is_mankal enum('1','0') DEFAULT '0' ,
is_hashav enum('1','0') DEFAULT '0' ,
dep_list text ,
signature varchar(20) ,
tel varchar(12) ,
tools varchar(50) ,
invoice_access enum('1','0') DEFAULT '0' ,
PRIMARY KEY (user_id),
UNIQUE user_id (user_id),
INDEX user_id_2 (user_id)
);