Hello and thanks for checking this out… My aider!
I’m trying to get some values from
a selected row in MySQL table
The table looks like this;
class. subject. score.
----------------------------
A. maths. 45
----------------------------
B. phys. 50
----------------------------
B. phys. 70
----------------------------
A. maths. 65
----------------------------
B. phys. 50
----------------------------
A. maths. 55
----------------------------
B. phys. 50
----------------------------
A. maths. 65
----------------------------
B. phys. 55
----------------------------
A. maths. 95
----------------------------
B. phys. 40
Now I want to fetch 3 random score from Maths as subject
Also fetch 3 random score from Phys as subject
How do I fetch these values using PHP and MySQL ?
Thanks