Welcome Guest, Not a member yet? Register   Sign In
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




Theme © iAndrew 2016 - Forum software by © MyBB