if weeks<>"" then
sql="select lab_arrangement.lab_room_id,lab_arrangement.week,lab_arrangement.day,lab_arrangement.Course_Name,lab_arrangement.Class_Name,lab_arrangement.lab_state,time_dictionary.time_description,Teachers.Teacher_Name from lab_arrangement,time_dictionary,Teachers where Teachers.Teacher_ID=lab_arrangement.Teacher_ID and lab_arrangement.time_id=time_dictionary.time_id and lab_arrangement.lab_room_id='" & weeks & "'"
else if timeid<>"" then
sql="select lab_arrangement.lab_room_id,lab_arrangement.week,lab_arrangement.day,lab_arrangement.Course_Name,lab_arrangement.Class_Name,lab_arrangement.lab_state,time_dictionary.time_description,Teachers.Teacher_Name from lab_arrangement,time_dictionary,Teachers where Teachers.Teacher_ID=lab_arrangement.Teacher_ID and lab_arrangement.time_id=time_dictionary.time_id and lab_arrangement.week='"&(timeid)&"'"
else if lab_room<>"" then
sql="select lab_arrangement.lab_room_id,lab_arrangement.week,lab_arrangement.day,lab_arrangement.Course_Name,lab_arrangement.Class_Name,lab_arrangement.lab_state,time_dictionary.time_description,Teachers.Teacher_Name from lab_arrangement,time_dictionary,Teachers where Teachers.Teacher_ID=lab_arrangement.Teacher_ID and lab_arrangement.time_id=time_dictionary.time_id and time_dictionary.time_description='"&(lab_room)&"'"
end if
end if
end if