Member Offer
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Creating MySQL tables for my newsletter forms

Discussion in 'Website Coding & Programming Forum:' started by Karma, Apr 15, 2012.

  1. Karma

    Karma New Member

    How do I create MySQL tables for my newsletter forms?

    I have the following fields in my form:
    First Name
    Last Name
    Choose a city
    Email Address

    Any advise will be appreciated.
  2. Corrosive

    Corrosive Moderator Staff Member

    You can create MySQL tables in a database using PHPmyAdmin.
  3. Karma

    Karma New Member

    Thanks Corrosive.

    My MySQL knowledge isn't great, I've tried looking online for tutorials but no luck really on what I'm trying to do.

    How would I go about creating my tables and fields in phpmyadmin?

  4. Corrosive

    Corrosive Moderator Staff Member

    It's not going to be that easy to explain in a forum post because there are many different options such as integers, varchar, blobs etc. Perhaps start and ask more specific questions as you go.
  5. Stationery Direct

    Stationery Direct Administrator Staff Member

    ..or maybe see how much it would cost for someone to sort for you, just a thought.
  6. Edge

    Edge Active Member

    I'd be looking around for some off the shelf software that manages it all for you - wordpress and newsletter plugins do it. I can't remember the last time I created a table for mysql as that's not the way it's done anymor - it's all about configuring avaiable packages than dealing directly with a database.
    Corrosive likes this.
  7. Corrosive

    Corrosive Moderator Staff Member

    Yes, that is a very good point. Or even sign up for a mailchimp account and let them handle all your data.
  8. Paul Murray

    Paul Murray Moderator Staff Member

    I was gonna suggest MailChimp too. I know a lot of people use it and it takes the hassle out of doing it yourself.
  9. Karma

    Karma New Member

    Well it's just a form for people to submit their email address' basically on a splashpage.

    This is the code I've got for my database:


Share This Page