10 {{ upvoteCount | shortNum }}
10 {{ upvoteCount | shortNum }}

Display contents of field from MySQL

by Gene Pimentel
8 replies
I have a site built with the Butterfly Script. It uses MySQL to store the Member data.

I'd like to display the content of ONE field from the Member's profile from the MySQL database, on the public sales page.

The sales page would display that data based on the cookie that was set by the visitor, which contains the referrer's ID#.

Any help would be appreciated :-)

Gene
#contents #display #field #mysql
  • Profile picture of the author markfail
    whats this "Butterfly Script", what sort for mysql class does it use?


    what about database structure, can u be more clear as to the field names or even table name.
    Signature

    *NEW* Wordpress Auction Theme - your own Flippa or eBay website in minutes!
    Wordpress Directory Script - creating a directory website is easy!
    Wordpress Shopping Cart - setup your own online store or Amazon affiliate store!

    {{ DiscussionBoard.errors[1124641].message }}
  • Profile picture of the author Gene Pimentel
    The Butterfly Marketing script is a popular membership & site content script (Butterfly Marketing - By Mike Filsaime).

    MySQL class? Not sure what you mean by 'class', but this is what I see:

    MySQL version 5.0.81-community
    # Server version: 5.0.81-community
    # Protocol version: 10
    MySQL charset: UTF-8 Unicode (utf8)


    table name: members
    field name: cbnickname


    Thanks,

    Gene
    {{ DiscussionBoard.errors[1124762].message }}
  • Profile picture of the author Dan Liptak
    I seem to be having problems posting the php code. PM me your email and I will send it to you.
    {{ DiscussionBoard.errors[1124898].message }}
  • Profile picture of the author Gene Pimentel
    Thanks Dan, I PM'ed you
    {{ DiscussionBoard.errors[1124915].message }}
  • Profile picture of the author Gene Pimentel
    Dan, your code works perfectly! Than you so much. I really appreciate that.

    Gene
    {{ DiscussionBoard.errors[1125024].message }}
    • Profile picture of the author viane
      If you can give me your php code then I will edit it as per your need.
      {{ DiscussionBoard.errors[1125864].message }}
  • Profile picture of the author Gene Pimentel
    Thanks for the offer viane, but see my post above. Dan has already done this for me.
    {{ DiscussionBoard.errors[1126873].message }}
    • Profile picture of the author willmartinapj
      just a little side note this was already done in the membership forum. if you would have asked over there someone would have pointed you to the link.
      {{ DiscussionBoard.errors[1136784].message }}

Trending Topics