Help with flat DB

[sjmojeck]

Hi,
I have a script that allows people to input user information such as first name, last name, etc... and writes it to a flatfile.

Is there a way then to check the entries for duplicates, copy the first 50 entries ouf of the database (flat) and email them to a person, then remove them from the database and store them in a secondary database? Any help is appreciated.

 

[goBoating]

Sure.
I'd use DBI DBD::CSV modules. Those will enable you to use normal SQL update, insert, delete, and other statements. The checking for duplicates, deleting records and adding to another file become very straight forward.

Then, if need be, the code can be converted to talk to a database server very easily.

'hope this helps

If you are new to Tek-Tips, please use descriptive titles, check the FAQs, and beware the evil typo.

 

[sjmojeck]

Sounds great, however I am a newbie to CGI databases - do you have any examples on how to do this? Thanks.

 

[PaulTEG]

Check out search.cpan.org, as it's said around these parts
it's your friend

--Paul

It's important in life to always strike a happy medium, so if you see someone with a crystal ball, and a smile on their face ...

 

[sjmojeck]

Thanks guys!