I'm looking for some help on adding a record to a database. On my website I have a field for people to add their E-mail if they want to subscribe to a newsletter. At the moment I have a cgi script that E-mails it to me and then I add it to an access database. This is pretty labour intensive. What I want to do is add it straight to a database then return the user to the same page they were on.
I have a mysql database and support for cgi and php with my hosting. What would be the easiest way to do this preferably without having to write any php or perl. I have used asp before but don't have a clue about perl/php.
Thanks in advance.
What I want to do is add it straight to a database then return the user to the same page they were on.
...without having to write any php or perl.
Sorry, but I think these are mutally exclusive.
The only way to automatically insert a record is to write script that will do the job for you. Otherwise, you'll need to open the db up with some tool like PHPMyAdmin (or use the command line) and manually insert the record much like you're doing now.
Or, you can use a mailing list management application like mailman from list.org or majordomo or something. That may be more than you're looking for, though, as they do more than just add addresses. They also handle the mails, which it sounds like you already handle in a different way.
Or, you can find some programmer to write you a script. You can post a request on freelancer websites like scriptlance.com or elance or any of the other hundreds. You can probably get it done for a few bucks.
Hope it helps.
-Andy
