I have a couple websites hosted with different hosting providers (one with Go Daddy and one with HostGator). I want to be able to email a specific address (that I would create on one of those sites)- and emails to that address would get automatically "processed" by some kind of script as follows: if there is an attachment on the email- it would get saved to a specific directory on the web server- and then a row would get added to a MySQL database to indicate the file is there. The challenging part will be monitoring for an incoming email and then managing the attachment. Is there a website where I could find a script that might help me with this?

(The reason I am doing this is b/c the iPhone will let me email photos but not upload them to a website- so I want to email vacation photos while I am away and have them get processed and uploaded to a website so they can be viewed.)

Thanks!

mySQL database?

I m creating a database that holds data on a large number of users. The database is meant to keep track of "awards" that users have. Each user has an id number and each type of award has an id number. The database will need to be queried about what awards a certain user has.

I m new to database programming and am trying to figure out what the best practice for this design should be. Should I make just one massive table that holds all of the users awards and just filter my queries based on user id number- or should I make separate tables for each user that uses the user s id number as part of its name?

Any help on this issue or links to helpful database programming sites are greatly appreciated.

Still learning about Network security and web page development. Currently Learning PHP and MySQL. Other than that- I am pretty much an HTML- JScript amatuer web designer. On my web site- I would like to be able to record and log the IP address of people who visit my site. Is this accomplished through code on a page- or by adding software to the server? And While I have you here reading- what programming is best for log in abilities (creating user names and passwords)? As I said- still learning- so any help is appreciated. Any references to tutorial sites- or books is also appreciated. I would like to learn as much as possible about web development- network security- and intrusion detection and prevention.
Thank you! ( And yes- I give best answer)

I have a TOTALRATINGS column and a
NO OF RATINGS column
i want to make a new column called
AVERAGE RATINGS
this will be based on dividing the totalratings by no of ratings.

How is this column created so it does this calculation automatically and stores value in that column.(the value will be a floating point integer)

Would it be;
ALTER TABLE tablename ADD averageratings INT(10)[TOTALRATINGS/NO OF RATINGS];
Sorry i wasn t thinking!
The statements when updating the database do this calculation for you and store it in the column!!Duh!!

plz i want to confiqure mysql with php my admin in itrello.com for making a site in phpbb3 hosting. i am begineer to this. plz chat with me for helping . i need the help now itself