$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); //using addValueOnInsert to track their IP address $tblEventAttendee->addValueOnInsert("fldIPAddress", $_SERVER["REMOTE_ADDR"]); $tblEventAttendee->setTextboxWidth("fldTimeArriving", 8); $tblEventAttendee->setTextboxWidth("fldLastName", 25); $tblEventAttendee->setTextareaHeight("fldComments", 70); //comment field should be a bit wider height #set the number of rows to display (per page) $tblEventAttendee->setLimit(25); //after 25 people, the resultset will paginate $tblEventAttendee->setAddPlaceholderText("fldTimeArriving", $fldTime); $tblEventAttendee->setAddFieldNote("fldTimeArriving", "Leave blank if you'll be on time."); $tblEventAttendee->setAddFieldNote("fldWillBeLate", "If you will be arriving late, please enter the time in the next box."); $tblEventAttendee->modifyFieldWithClass("fldTimeArriving", "time"); $tblEventAttendee->modifyFieldWithClass("fldLastName", "required"); $tblEventAttendee->modifyFieldWithClass("fldFirstName", "required"); $tblEventAttendee->formatFieldWithFunction("fldWillBeLate", "displayWillBeLate"); $tblEventAttendee->formatFieldWithFunctionAdvanced("fldTimeArriving", "displayArrivalTime"); $tblEventAttendee->emptyTableMessage = "No one has signed up yet! Press the '<b>Add Person</b>' button below to sign up for this event.";