[nekeno12]

Okay, the system I'm working on is for a credit counselour. He get's some clients from Mortgage brokers, works on the clients file, and allows the broker to login to our system and see the results.

So, when a new client is added, I'm looking for a way to assign particular clients to particular brokers.

All the information is stored on a mysql database.

So, my idea is to take the id numbers for each client, and store the values in the sql database under the broker in a column called clientlist.

So the values stored, would be an array of like 1, 5, 6 in comma separated format.

Then when the broker logs on, he gets a list of just the clients with the key id's 1, 5, and 6.

Now, that's the best way to do it in my opinion. But how to code that is where I'm lost.

What's the best way to ADD to the values pulled from mysql and UPDATE them into mysql with the new client added to the broker.

For example, if Pulte Mortgage has clients 1, 2 but we want to add 3 to them and still have the comma separated format, what is the best way to do that?

Thanks in advance

[scriptsagency]

You can update it easilly by selecting the value and adding to it the new id . For example to add to $string1 another text you just do $string1.="text added" ;
To separate the id's if you need to use only one you use $arrayy=explode(" , " , $string) ; and to create a string from an array you do $stringg=implode("," , $arrayy);