• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
select user by user_id

#1
Sad 
Hello everyone, here I am, facing a problem.

voice ma bdd:

id user_id currency_id currency_id currency_symbol balance last_update
25 AKWEYR 817014 KST 0.000000000000 2019-06-22 17:40:31
26 AKWEYR 1182 BTC 0.0000000000 2019-06-19 17:54:12
31 OWONWR 817014 KST 0.000000000000 2019-06-22 17:40:21
32 OWONWR 1182 BTC 0.0000000000 2019-06-20 17:53:43

I'm looking to display balance when currency_symbol = KSD and user_id = AKWEYR

I have tried a lot of things but nothing works
thank you in advance.

Translated with www.DeepL.com/Translator
Reply

#2
We could give you a correct answer, but if we do; You won't learn on the way there.

What have you tried? And what did you get? (if you got anything)

Selecting Data
Looking for Specific Data
Method Chaining
Reply

#3
Database where
What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )
Reply

#4
Quote:id user_id currency_id currency_id currency_symbol balance last_update
25 AKWEYR 817014 KST 0.000000000000 2019-06-22 17:40:31
26 AKWEYR 1182 BTC 0.0000000000 2019-06-19 17:54:12
31 OWONWR 817014 KST 0.000000000000 2019-06-22 17:40:21
32 OWONWR 1182 BTC 0.0000000000 2019-06-20 17:53:43

I'm looking to display balance when currency_symbol = KSD and user_id = AKWEYR

I have tried a lot of things but nothing works

Are you sure there must be records in your table with currency symbol "KSD"? In the example you included, I only see "KST". So that would explain why you don't get any results. But like jreklund says: it's hard to tell without knowing what you already tried.
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.