Reply
Read from files and organize data
Old 11-09-2006, 10:33 AM Read from files and organize data
Junior Talker

Posts: 1
HI

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 ?
motivation is offline
Reply With Quote
View Public Profile
 
When You Register, These Ads Go Away!
Old 11-10-2006, 06:05 AM Re: Read from files and organize data
chrishirst's Avatar
Super Moderator

Posts: 15,326
Location: Blackpool. UK
can't be done in SQL

You need a server side script to read the folder structure and build a query.
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
Indifference will be the downfall of mankind, but who cares?
Code Samples | People Counting System | Bits & Bobs
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Reply     « Reply to Read from files and organize data
 

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Webmaster Resources Marketplace:
Software Development Company | Webhosting.UK.com | Text Link Brokers 


   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML

 


Page generated in 0.11315 seconds with 12 queries