Skip to Content Skip to Menu

🎃 Happy Halloween! Treat yourself with an awesome discount on memberships! Get 20% off now with code SPOOKY-2024!

[SOLVED] MySQL field

  • cardoso69
  • cardoso69
  • OFFLINE
  • Posts: 27
  • Thanks: 1
  • Karma: 0
  • Add-ons
11 years 9 months ago - 11 years 9 months ago #219919 by cardoso69
[SOLVED] MySQL field was created by cardoso69
J!2.5 and CB 1.9

I have a field called cb_date in a field displayed on a tab.
Now i'm trying to use the same value of the cb_date in another tab.
I thought in use mysql field to do this.

I've created the query:

SELECT:cb_date
FROM:#c621_comprofiler
WHERE:id=$user->id

And i get no result.

If i put WHERE:id=521(one user id) the value is displayed.
What i'm i doing wrong?
Last edit: 11 years 9 months ago by krileon.

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

  • cardoso69
  • cardoso69
  • OFFLINE
  • Posts: 27
  • Thanks: 1
  • Karma: 0
  • Add-ons
11 years 9 months ago #219921 by cardoso69
Replied by cardoso69 on topic MySQL field
SOLVED:
Find my own answer, sorry...

SELECT:cb_date
FROM:#c621_comprofiler
WHERE:id={USERID}

That did the trick...
The following user(s) said Thank You: nant

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

Moderators: beatnantkrileon
Powered by Kunena Forum