Hi,
>I got a series of string value in this format ie: 1,2,3, say pretend that
these are telephone number, which is one feild >in user table.
>I need to update this telephone number field, I got 3 user ID in series
like this too, ie: 3,4,5 and normally it is like
>
>update set .... where userID IN (3,4,5) ( when there is one vaule to
update, not series of string to update).
I would think about the general layout of the DB. It is not good
to store more than one value in one field. Do some normalisation
on your DB or read:
http://www.devshed.com/Server_Side/MySQL/Normal/ and
http://www.devshed.com/Server_Side/MySQL/Normal2/
hope it helps
Johannes
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
