mysql TEXT type

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
pelegk2
Forum Regular
Posts: 633
Joined: Thu Nov 27, 2003 5:02 am
Location: Israel - the best place to live in after heaven
Contact:

mysql TEXT type

Post by pelegk2 »

i am updating :

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=35


i 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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

post an export of the table structure. (SQL format)
User avatar
pelegk2
Forum Regular
Posts: 633
Joined: Thu Nov 27, 2003 5:02 am
Location: Israel - the best place to live in after heaven
Contact:

here it is

Post by pelegk2 »

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)
);
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

are you absolutely sure you're getting up to that? Post an export version (INSERT ...) of that record please.
Post Reply