i am updating :
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 :
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
Hi Peleg,
Well not sure, but a couple of things to look at.
Is this being posted from a Form? If it is, is the field correct.
What have you got the Column type set to in the datbase. A VARCHAR set to 255 should be enough.
Just out of interest try;
$thing = '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,' UPDATE dep_list = $thing WHERE user_id=35
That should do exactly the same thing as you have already.
Hope this helps a little.
Cheers,
Neil.
i printed it to the screen and it show all the data hrough mysql-front it dosent
UPDATE tablename SET fieldname_1 = new_value_1, fieldname_2 = new_value_2
what does mysql_error say to your UPDATE?
it udates
as posted by cheese, what's your column type? the DB may be truncating the data if the field type isn't big enough.
:
ooops sorry. didn't read it properly 🙁 can you echo your SQL statement and post it here so we can have a look?
