thanks a lot for all the help.

Lets say I have 2 folders with 3 files under each

Folder 1
- file 1 ( Hello guys in Mysql help )
- file 2 ( thanks a lot )
- file 3 aaaaaaaaaaaaa


Folder 2
- file 5 bbbbbbbbbbb
- file 6
- End

How can I insert this data to the database

FileIndex FileName ULR contents
1 file1 /Folder1/file1 Hello guys in Mysql help
2 file2 /folder1/file2 thanks a lot
3 file3 /folder1/file3 aaaaaaaaaaaaa
4 file5 /folder2/file5 bbbbbbbbbbbbb

......

and so on ?

How can I do a query that do this ?

no answer ?!

Insert Into....

ya but how to do a loop ?

client progam