mercredi 1 décembre 2021

convert a sql query to php laravel query

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