I'd like to know how to connect in Perl to a mysql database to check for a value entered in a survey against database values.
In Unveriefied Perl I have VALUE("Accesscode") which has been entered in the survey.
I have set up a simple mysql test database with
db name: db342250_4
db user: db342250_4
fields: ID (autoincrement), Code (Varchar)
What would be the Perl code to check if VALUE("Accesscode") matches with any value in "Code"?
I know, this goes far beyond the usual stuff, but if anybody could help, that would be great.