[Resolved] query help plz

[k994519]

hi guys

i need help with modifying my query below so it does what is described ...........

 
"select question_id, question from questions, tests  where tests.test_id = '$test' and tests.module_id = questions.module_id and questions.required = 'yes' order by rand()";

......................HERE
this works i was wondering if there is away of displaying the all the questions but show the field questions.question_required =yes at the top ..... i would not need the random function for this

any help would be great

thanks a lot

[epp_b]

Sure...assuming the only possible answers are "yes" and "no" 😃

"select question_id, question from questions, tests where tests.test_id = '$test' and tests.module_id = questions.module_id ORDER BY questions.required DESC";

This will order the questions answered "YES" before the questions answered "NO".

[k994519]

Hi

thanks for your help

1 quick question how can i changed the order so that the "required" shows the no's before the yes's

Im looking for the opposite of desc......

thanks for all ur help.... very much appreicated.....

[drew010]

opposite of order by desc is order by asc

[Weedpacket]

Originally posted by drew010
opposite of order by desc is order by asc

Or not to put anything; ascending order is the default.