convert a sql query to php laravel query .
DB::select("SELECT distinct q_id,theme, ownerID, p_id, q_type, screen, leadin,
scenario, option_text, o_media, correct, display_method,
score_method, q_media, q_media_width, q_media_height, marks_correct,
marks_incorrect, display_pos, STATUS, correct_fback, feedback_right,last_edited,
locked, settings FROM (papers, questions) LEFT JOIN options ON questions.q_id = options.o_id WHERE paper=$id AND papers.question=questions.q_id GROUP BY(q_id) ORDER BY screen ASC");
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire