pallavibhoite

Plz frenz help me. I want to display timetable of college lectures using PHP/MySQL. I stored the information about lectures in Lectures_Info table. It has following fields: Subject_Name- name of subject, Lecture_Start-start timing of lecture(like 09:00), Lecture_Day-Day of lecture(like Monday,Tuesday). I attached image for the format of timetable. There are …

I want to develop application using PHP. One module in this application displays attendance of students under particular teacher, between given two dates. The structure of tables in database - 1. student_info(Roll_No, Teacher_Id, First_Name, Last_Name) 2. attendance_info(Teacher_Id,Roll_No,Date,Present) Present stores '1' if student is present on that date and '0' if …

I have problem with SQL query. I have table in my database which stores attendance of students. It has fields Teacher_Id, Roll_No, Date, Present('0' if student is absent on that date and '1' if present). I wrote following query SELECT count(Present ) , sum( Present ) FROM attendance_info WHERE Teacher_Id …