} #Create an instance of the class $tblEventAttendee = new ajaxCRUD("Person", "tblEventAttendee", "pkAttendeeID", "../ajaxcrud/"); $tblEventAttendee->doActionOnShowTable = false; //this ensures showTable() does not call doAction; i do not want to do this because my onAdd callback function creates a cookie $tblEventAttendee->omitPrimaryKey(); #Create custom display fields //$tblEventAttendee->displayAs("pkAttendeeID","User ID"); $tblEventAttendee->displayAs("fldFirstName", "First Name"); $tblEventAttendee->displayAs("fldLastName", "Last Name"); $tblEventAttendee->displayAs("fldPhone", "Phone #"); $tblEventAttendee->displayAs("fldWillBeLate", "Will You Be Late?"); $tblEventAttendee->displayAs("fldTimeArriving", "Arrival Time"); $tblEventAttendee->displayAs("fldComments", "Comments/Other"); $tblEventAttendee->displayAs("fldIPAddress", "IPAddress"); $tblEventAttendee->omitFieldCompletely("fldIPAddress"); $tblEventAttendee->omitFieldCompletely("fkEventID"); $tblEventAttendee->omitFieldCompletely("fldPhone"); $tblEventAttendee->omitFieldCompletely("fldAttending"); $tblEventAttendee->validateDeleteWithFunction("canRowBeModifiedOrDeleted"); $tblEventAttendee->validateUpdateWithFunction("canRowBeModifiedOrDeleted"); $tblEventAttendee->defineCheckbox("fldWillBeLate"); $tblEventAttendee->addOrderBy("ORDER BY fldFirstName ASC"); #Add WHERE clause so we only display information specific to the event that was selected $tblEventAttendee->addWhereClause("WHERE fkEventID = {$eventID}"); #I could add filter boxes to the top, but have chosen not to do so; commenting these out //$tblEventAttendee->addAjaxFilterBox("fldFirstName"); //$tblEventAttendee->addAjaxFilterBox("fldLastName"); //$tblEventAttendee->addAjaxFilterBox("fldAttending"); //using addValueOnInsert so when someone signs up it will automatically add them to this event $tblEventAttendee->addValueOnInsert("fkEventID", $eventID);