Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $query = "SELECT SF.survey_id, SF.surveytitle, SF.survey_description, SF.surveycategory, C.categoryname AS pcatname, SF.surveysubcategory, SC.categoryname AS scatname, SF.gender, SF.age_start, SF.age_end, SF.occupation, SF.date_created, O.name, SF.location, SF.occupation_status, SF.status, SFQ.question_id, Q.questiontitle FROM surveyform AS SF
- LEFT JOIN category AS C ON SF.surveycategory = C.category_id
- LEFT JOIN category AS SC ON SF.surveysubcategory = SC.category_id
- INNER JOIN occupation AS O ON SF.occupation = O.occupation_id
- INNER JOIN surveyform_questions AS SFQ ON SF.survey_id = SFQ.survey_id
- INNER JOIN question AS Q ON SFQ.question_id = Q.question_id WHERE SFQ.survey_id = $id";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement