Copying tables from one database to anot

[Anon]

Here's my problem....

//this i can do
People submit details and these are inserted into a database.
//Heres my problem
The admin then distributes these entries to different users.

Am i better to use different databases? Or is there a better way of distributing these entries?

I REALLY need ANY help available, this is my most important website to date.....this could be my ticket to getting my business of the ground.

Im on msn messanger btw.

[Anon]

use the same database. All the information that is stored in, then you use PHP/MySQL commandes to distribute the entries.. easy as that.

[sepodati]

Would it be distributed to multiple users or just one?

I would just add another column to the one table and insert the user it's assigned to there. When that user logs on, you just select all entries where assigned_to is equal to their user_id.

You can do the same thing for multiple users, but it would probably be better to use a second table,then. Simply have two columns, one with user_id, and one identifying the entry assigned to them. When the admin assigns an entry to some people, you make multiple entries in the second table with the users user_id and the entry_id.

---John Holmes...

[Anon]

Hmm,

Could you illaberate on that?
Maybe an example? Im pretty new to al this....I took on a big project, more than i can chew....so any help would be appreciated