Can i use GROUP BY in mysql query?

I can share my code
I must need to complete in 2 days otherwise they can fire me

He won’t allow it

wtf man, resign that job

login depends on you, store info whatsoever you want

logic*

I’m in probation time.
And can’t even resign on my own
Because of bond

I’m stucked at showing result
After inserting the quiz result
How much questions user attended
How much correct
And how much wrong

If correct then 10 point plus

This is where I stuck

simple logic, store the answer in one db, compare it with all the answers submitted, show the data

what’s the big deal in it

Not all data man
If user id 3 has given 5 questions then
Only that 5 questions would be shown

For that

Can i use GROUP BY in mysql query??

there is something called where clause in sql

It should be dynamic

and what do you mean by dynamic?

If I use where clause
Then obviously i have to put something like
Where user_id = 5

So result of 5th user will be there

Right?

yeah, that’s the use of it

But every different time
Different user’s info i need

For that?

show the result who is logged in?

Instead of 5 what should i writr

Yes

Write*

get the user id from $_SESSIONS[ ] variable

Right

if it is stored in session variable

Yes
User id is in session

the get that

then*

Oky
I’ll try tomorrow

why tomorrow, try now

if you want it, get it now, don’t delay it

I just came from office
Did 12 hours job today
So I’m tired

hah, you have only 2 days

time is running

It is but i need some rest too.
With headache i can’t do it

struggle man, this what makes a man successful

Yes right brother

But i also forgot to backup my today’s code for practice

Thanks a lot for help @rohit267 ✌️🏻

Appreciate.

work hard, never stop

I will.

Firebase?

Just use that ID in Session and update the table with
Question ID and option user selected

Like
QID UID ANS
1 1001 4
4 1001 1

AT AFTER SUBMITTING THE TEST JUST CALCULATE THE RESULT

HOPE THIS SORTS YOU OUT WITHOUT USING ANY OTHER STORAGE

I’m getting only last question details user enters

Like
UserID questions ID userANS
1. 1. animal
1. 2. Bird
1. 3. Animal

So I’m getting only last result