Hello Wade, Yes once amonth I will download file files from the IRS and upload them, when I am uploading them is when I would love to do this filtering but don't know how I would do this. I am VERY new to PHP and MySQL.
ok, let me see if I can explain this a bit better: I download five files from IRS website, I then decompress these and I have then five files These files are definded by space so say feild one is from 1 - 9 and feild two is 10 - 27 and so on so I got to upload these to the database and the only way I know how is buy uploading them to access and then connecting access and exporting MySQL. Then from there have MySQL filter the files and move them where should go. some of the files will meet more then one critar and other won't at all, the ones that don't stay in the database that they are in (this would change after the first time) OK, now the way I would like it to be is: First I download and uncompress that files from IRS and then go to a webpage and upload the files the way they are and have it filted and put in to the database they belong to the once that pass go to one and the once that don't go to the other. now with all filting there is them that get by and there for I would sort them my self over time and put them into a database for blocking. now the next time I upload the files it would do three things, filter out what is on the blocked list, filter and see if already there and if have been updated sence the last upload. I hope this sound right. If it does can you help me with this. IT is NOT for a for-profit it is for a project that is for helping people find infromation they are looking for (blindness and deafness data) Sincely, Christopher & Missy --- In [email protected], Wade Smart <[EMAIL PROTECTED]> wrote: > > 03232006 1557 GMT-6 > > So once a month you are matching each record > to one of 40 criteria AND if they match any of them > you want to move them copied from db1, put into another > db2, and deleted from db1. > > Does that mean every month you will add to db2? Does that > mean db1 will be getting smaller and smaller? > > If you are doing this through a web interfact, php is > the way to go - but if you have access to the machine, > just store the procedure and do it there. > > Wade The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
