how to store many files in one database field

[lyealain]

how to store many files in one database fields?? i manage to store one file into database field.. but fail to store many files.....

how should i do that>> one database field for many files name.. is this way correct???

or each field for one filename?? 10 fields for 10 files??

[christopherpond]

Sounds like you should create association table

[lyealain]

is this how all people do for this problem?? how do u all insert multiple files into database>>> ???

[lyealain]

is this how all people do for this problem?? how do u all insert multiple files into database>>> ???

waht is association tables.

[christopherpond]

Well I don't have your schema but I would keep your existing Table A and create another table call it documents that has a foreign key to Table A's ID column.

For example,
Table A
ID = 1

Table B (2 columns (or 3 if you don't want composite key)
Columns
Filename
Table A ID

Then you can have a single record in Table A but many filenames in Table B.