Until I create a php file to add/change events to the webpage, I have to do this by hand. Here are some examples:
To add a Monday Seminar by Mark:
insert into events values (NULL,2,'2007-04-09',3,'16:15:00','17:15:00','RI-480','Mark Oreglia','University of Chicago','The Roadmap to the ILC','',1);
To add an announcement about the floors in HEP being redone
insert into events values (NULL,1,'2007-04-09','17:00:00','19:00:00','HEP','Dennis Hannum','4-5661 with questions','HEP Floors Cleaned-Please Remove All Personal Items from the Floor','',7);
To change the speaker info on a Lunch Talk
update events set speaker='Bruce Mellado',institution='UW-Madison',title='Missing ET Reconstruction in ATLAS' where date='2005-04-02' and starttime='12:15:00';
To delete an entry
Find the id of the entry to delete
select * from events where speaker='Dennis Hannum'; delete from events where id=70;
Could do this command in one line, but it’s a good idea to make sure you’re deleting the right data.