Hi fellow members,

I need to attach a email/pdf/files to my interaction record. The interaction record is my database which is in phpmyadmin. I tried to find around but seems like i could not find the solution.

It works something like in an email where you attach files to your email.

Any help would be appreciated.

Thanks.

I doubt 'my database is in PHPMyAdmin'
so do we assume you are using an Access front end (user interface) connected to a MySQL backend (data store)?
usually the best way to store such 'stuff' is as a url pointing to the file that is stored outside the system. the downside of this approach is that you have to consider how you control access to that external storage.. as its all to easy for third parties to delete or modify that. so I generally allow users to create or modify files elsewhere and then copy them to the secure location where they become read only.

I have a web based interface, so the attach of files will allow user to choose what files to attach to the records.

My database is in phpmyadmin.

What i need to question is if there is a way ( by coding or format ) where i can come out with a function similar to hotmail attachment of files.

no your database is not in PHPMyAdmin, PHPMyAdmin is a tool that talks to/manipulates databases.
according to phpMyAdmin its specifically designed to manipulate MySQL databases, although it can export to various formats FROM a MySQL db

if its a web application then its unlikely that you are using Access as a front end tool...
so what are you using to store the data
what language are you using for the front end (the web interface)

I suspect you are probably using PHP in which case you should look do a google search for PHP file upload

My scenario is this,

After query on the web based interface, all the data from the database will appear according to the query.

There will be a 'attach' button beside each contact.

So when i click on the attach button, it will pop out a window to trigger user to choose the files he wants to attach.

After choosing, the file will be attached to the user.

Beside the 'attach' button will be a 'send email' button.

Thus clicking on the button will send the email over to the user by the address in the database.

Yes, im using PHP.

Sorry my english is bad. ):

Please help. (:


Thanks

moved to he PHP forum

Means i start a new thread over there ?

*EDIT*

Oh thanks for the move. Appreciated it. (: