automated ftp downloader
===

I dont have much experiance with SQL but i know this is doable on it. What i am looking for is a script that would let me download from an FTP website. Couple of critierias that are important:

unix server

files from server are deleted every four days that is why i want to download the files to company hard drive. 

i dont want a duplicate of folders/files downloaded every time. 

when i log in as the admin, there are 20 folders. each folder is named after a company member. when the company member logs in they see only the content of the folder that is specified to them. i want to download the content of the folders. because if i download the folder. it will just download the whole folder and i'll have a lot of folders by the same name. so the thing i did was make directories on my hard drive that has the same name as the folders i see. (this part might be confusing so ask me to explain if needed. )

also i think it would be a good idea  to delete the contents of the folder once the download happens so no duplicates are downloaded. 

if anyone has written a similer script or has a SQL file that will help me out, i'd appricate it. 



Thank you!
