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.
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