Skip to Content Skip to Menu

Need to know how to call the variables

13 years 7 months ago #163899 by thesnowsnake
Need to know how to call the variables was created by thesnowsnake
I am inserting into a mysql database and I need to know how to handle the users company field wich I added to the profile. I used this for user id:

** <code type="user" />, but this only stores the user ID from the original registration file.

So can anyone give me the sql code to call and store the company field for the current user??

Please Log in or Create an account to join the conversation.

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
13 years 7 months ago #163906 by nant
I do not understand what you are trying to do and why you have to do it directly in database and code.

Please Log in or Create an account to join the conversation.

13 years 7 months ago - 13 years 7 months ago #163975 by thesnowsnake
Replied by thesnowsnake on topic Re: Need to know how to call the variables
OK first let me say I'm brand new to community builder.

I am not sure how to store the current users infomation into the database tables I use.
I also use LFRM LOGO which allow me to store some user infomation eg:


INSERT INTO feedback (ID_feedback,
client_ref,
FBlastname,
FBphone,
FBcity,
author,

FBrate,
FBcomment,
FB_date )

values (
NULL,
'<input name="client.Idclient" hidden="yes" />',
'<input name="LastName" hidden="yes"/>',
'<input name="Phone" hidden="yes" />',
'<input name="City" hidden="yes" required="n"/>',
<code type = "user" />,


***** But I would also like to insert or update the company field info of that user into feeback.company where feedback.feedback_ID= <code type = "user"


hope this all makes sense to you..


I need this infomation to display a company name on a feedback profile rather than a criptic ID number.
Last edit: 13 years 7 months ago by thesnowsnake.

Please Log in or Create an account to join the conversation.

13 years 7 months ago #163976 by thesnowsnake
Replied by thesnowsnake on topic Re: Need to know how to call the variables
Also is there a list somewhere of the session variables that community builder uses and a hint on how to store said variables into my tables...Ya I'm a noob but I'm trying LOL

Please Log in or Create an account to join the conversation.

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
13 years 7 months ago #163988 by nant
Suggestions:

Download CB API document from FREE download area and study it.
It should give you a better understanding of things.

You can become an advanced member and get the detailed CB documentation - will also help you understand much better what you already have. Plus you get many more add-ons.

There is also CB Juice which can help you import users and data to your CB website.

Best I can suggest because honestly I still don;t know what you are trying to do.

Please Log in or Create an account to join the conversation.

13 years 7 months ago #164075 by thesnowsnake
Replied by thesnowsnake on topic Re: Need to know how to call the variables
I'm sorry but I thought I explained I am doing a feedback database and need to store certain infomation from active sessions. I am sure that I can figure this out.

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum