"; $query = "INSERT INTO admin.sp_list (ticket_createdby_userid, ticket_owner_id, ticket_short_description, ticket_full_description, ticket_status, ticket_severity, groups, ticket_added_date) VALUES ($idAuto, $idAuto, QUOTE('$details') , QUOTE('$details'), 'Open','Medium','2', '$today')"; $result = MYSQL_QUERY($query); // send email; if ($reqType == "data") { include("registration_data.php"); } else if ($reqType == "info") { mail("nccs@ui.urban.org", "Information Request", "Email: $email\nLast name: $lname\nFirst name: $fname\nTitle: $title\nOrganization: $org\nOrganization Type: $OrgType\nAddress: $address\nCity: $city\nState: $state\nZip: $zip\nPhone: $phone\nRequested password: $password\nComments: $comments\nReasons: $reasons\nRequest type: $reqType\nTo update this record: http://communityplatform.us/PubApps/regis/formGenerator.php?idAuto=$idAuto", "From: nccsWeb@ui.urban.org\r\n"); include("registration_reg.php"); } else { mail("nccs@ui.urban.org", "Data Access Request", "Email: $email\nLast name: $lname\nFirst name: $fname\nTitle: $title\nOrganization: $org\nOrganization Type: $OrgType\nAddress: $address\nCity: $city\nState: $state\nZip: $zip\nPhone: $phone\nRequested password: $password\nComments: $comments\nReasons: $reasons\nRequest type: $reqType\nTo update this record: http://communityplatform.us/PubApps/regis/formGenerator.php?idAuto=$idAuto", "From: nccsWeb@ui.urban.org\r\n"); include("registration_reg.php"); } ?>