How to pass data dynamically to mysql query

Question

I have following query,

SELECT t_subject.subject, SUM( t_skilllist.skill_level ) AS total_skill, t_users.first_name, 

t_skilllist.skill_level
FROM  `t_skilllist` 
JOIN t_subject ON t_subject.id = t_skilllist.subject_id
JOIN t_users ON t_users.id = t_skilllist.user_id
WHERE t_subject.subject =  'html'
GROUP BY t_users.first_name
ORDER BY total_skill DESC 
LIMIT 0 , 30

I want to display subject and skill level for each student. But, for one subject I can do that with above query. As an example for html it works. However, I want to pass more than one subject to the query dynamically. I tried to combined subjects with AND operator but it return empty result set.

How to solve this? How to pass more than two subjects to the query? I am using PHP as server side scripting language.

use OR instead of AND

Pinoniq
– Pinoniq

2013-07-04 10:29:30 +00:00
Commented Jul 4, 2013 at 10:29 — Pinoniq
– Pinoniq, Commented Jul 4, 2013 at 10:29

hjpotter92 · Accepted Answer · 2013-07-04 10:34:31Z

2

You can use the IN() clause.

WHERE t_subject.subject IN ('html', 'php', 'and', 'a', 'lot', 'more')

answered Jul 4, 2013 at 10:34

hjpotter92

81.1k36 gold badges148 silver badges188 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to pass data dynamically to mysql query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related