PHP +MYSQL +NMS FORMMAIL

A project to take the input of a web form + get ipaddress of sender. Save form information in MySQL database, based on rules change boolean flags in the database. Send via nms formmail (NMS FORMMAIL ONLY) send email with certain columns as subject & body. Initial database looks like this (db1) ------------From FORM varchar FName varchar LName varchar Email varchar City varchar country varchar Type varchar Code varchar indicator --------------- END FROM FORM varchar ip Date Date bool send bool diff bool wrongtype bool already bool incomplete bool override bool overridden Second table (db2) int code varchar country bool flag third table (db3) varchar indicator varchar type check country logic if ip(db1)>code>country != db1 country diff=true else diff=false check indicator if indicator(db1) not in type(db3) wrong=true else wrong=false if Fname<2 incomplete=true else incomplete=false if FName=LName incomplete=true else incomplete=false if Fname[1]=Fname[2]=Fname[3] for len of fname incomplete=true else incomplete=false if LFname<2 incomplete=true else incomplete=false if LName=FName incomplete=true else incomplete=false if Lname[1]=Lname[2]=Lname[3] for len of fname incomplete=true else incomplete=false if email in select email from db1 already=true else already=false table 3 needs to be created from [login to view URL], they have php (needs to be 5) api to do the country check. it needs to be put in a sql table, not as a disk file. Take a look at maxmind. when the above checks are done, then it needs to call nms formmail with the subject "send" OR "diff" OR "wrongtype" OR "already" OR "incomplete" because the logic should mutually exclude each type body containing three lines 1 sender (email) 2 type 3 code Also a php script that allows to view the complete database from IE, in the form of column data, text boxes & check boxes for the bool options. that I can change the check boxs of, and when i click submit, it updates the database and calls again NMS formmail as above, but no rules are done, and ONLY for the override=true items, once sent it changes the state of override to false and overridden to true. I hope thats complete enough for you, any questions ask. STEVEN