mysql LIMIT查询不确定该怎么做

Question

I am a quite confused now using mysql and unable to get things work :( .

I want to do this:

$qid has question_id and $subject has subject name. Database has a list of questions. For example I have $qid = 16 and subject = Chemistry, now I want to show 10 questions after question_id = 16 with subject = Chemist .

I am unable to figure out how it will be done.

Answer 1

Assuming your question ids are autonumeric, you can set a limit of 10 and then only show questions with an id >16:

WHERE question_id > 16
AND subject = 'Chemist'
LIMIT 10