Newbie - Complex Select
Newbie - Complex Select
mccarville
Posts: 4Questions: 0Answers: 0
Can anyone point me in the right direction for setting up a dynamic table with SELECT like the code below? I have been beating my head against the wall and have tried starting from sever_processing.php and from server_processing_details_col.php
[code]SELECT filename, week, dept, course, lp_dept.description, lp_weeks.year, lp_weeks.desc FROM lp_plans, lp_dept, lp_weeks WHERE username = '" .$_SESSION['MM_Username']. "' AND lp_plans.dept=lp_dept.id AND lp_plans.week=lp_weeks.id ORDER BY `timestamp` DESC[/code]
[code]SELECT filename, week, dept, course, lp_dept.description, lp_weeks.year, lp_weeks.desc FROM lp_plans, lp_dept, lp_weeks WHERE username = '" .$_SESSION['MM_Username']. "' AND lp_plans.dept=lp_dept.id AND lp_plans.week=lp_weeks.id ORDER BY `timestamp` DESC[/code]
This discussion has been closed.