require_once('const.inc'); require_once('includes.inc'); $FORM_CUSTOM_VALIDATIONS = array(2=>'+ text_email_check(form_name, \'$field_name\', \'$FIELDTITLE\')'."\n", 3=>'+ text_number_check(form_name, \'$field_name\', \'$FIELDTITLE\')'."\n", 4=>'+ date_format_check(form_name, \'$field_name\', \'$FIELDTITLE\')'."\n"); function on_before_perform_insert($table_name, &$data, $ed_id) { $LNAME = $data['LNAME'] = ucfirst($data['LNAME']); $FNAME = $data['FNAME'] = ucfirst($data['FNAME']); $EMAIL = $data['EMAIL']; $LNAME= mysql_real_escape_string($LNAME); $FNAME= mysql_real_escape_string($FNAME); $EMAIL= mysql_real_escape_string($EMAIL); $addrtocheck = substr($data['ADDR1'].$data['ADDR2'], 0,6); $name_exists = get_rec_count($table_name, " (`LNAME` LIKE '$LNAME') AND (`FNAME` LIKE '$FNAME') AND `EMAIL` like '$EMAIL' "); if ($name_exists) die("Error: Such Name already exists. Click Back button on your browser and try again..."); return 0; } function on_after_perform_insert($table_name, &$data, $ed_id){ run_query("UPDATE `$table_name` SET `THE_TIME` = NOW() WHERE `ID`= '$ed_id'"); } open_db(); $alternative_processed_location = "$site_protocol://{$this_site_URL}display.php?"; include "process.inc"; $table_name = "tbl_probowl_promo"; $form_titles_arr = array('First Name', 'Last Name', 'Address 1', 'Address 2', 'City', 'State', 'Zip Code', 'Age', 'Phone', 'Email'); $field_names_arr = get_table_fields_arr($table_name, array('ID', 'THE_TIME')); include 'prepare_defaults.inc'; $FORM_DEFINITIONS['AGE']['MANDATORY'] = $FORM_DEFINITIONS['ADDR2']['MANDATORY'] = false; $FORM_DEFINITIONS['EMAIL']['VALID'] = 2; $FORM_DEFINITIONS['EMAIL']['MANDATORY'] = true; for ($i=0; $iplease reenter..."; if (!empty($fname)) perform_plain_update($table_name, array('PICT'), array($fname), $new_id); include "build_form.inc"; close_db(); ?> SantaFePackingCompany.com First Name: Last Name: Address 1: Address 2: City: State: State Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware DC Florida Georgia Guam Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hamp. New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virgin Islands Virginia Washington West Virginia Wisconsin Wyoming Zip: Age: Phone: Email: