MySQL cannot trigger PHP when there is an insert/update. You would need to use a polling mechanism from PHP, query for changes every N seconds/minutes (assuming adding and viewing are two separate disconnected entities).
ok this is my problem description:
in my database i have a table named student. everytime an insert/update/delete is performed on student, the old values, the action performed(i.e inssert/update/delte), time&date of change is stored in another table student_history.
now what i am asked to do is, create an "echo" statement using php, to display columnA and columnB of the record inserted into student_history. i.e everytime an insert is performed on student_history, a new page should open up indicating the value of columnA and columnB of the inserted record. and if 10 records are inserted simultaneously, 10 windows should open, indicating the inserted record