Display contents of field from MySQL

by 8 replies
10
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
#programming #contents #display #field #mysql
  • 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.
  • 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
  • I seem to be having problems posting the php code. PM me your email and I will send it to you.
    • [ 1 ] Thanks
  • Thanks Dan, I PM'ed you
  • Dan, your code works perfectly! Than you so much. I really appreciate that.

    Gene
    • [1] reply
    • If you can give me your php code then I will edit it as per your need.
  • Thanks for the offer viane, but see my post above. Dan has already done this for me.
    • [1] reply
    • 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.
Join the discussion

Next Topics on Trending Feed