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");



from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3dnEgKN
via IFTTT

Aucun commentaire:

Enregistrer un commentaire