'; print_r($_POST); print_r($_GET); print_r($_REQUEST); echo ''; */ $set = $HTTP_POST_VARS['set']; $file = $HTTP_POST_VARS['file']; $platform = $HTTP_POST_VARS['platform']; $other = $HTTP_POST_VARS['other']; $output = $HTTP_POST_VARS['output']; $stats = $HTTP_POST_VARS['stats']; $geo = $HTTP_POST_VARS['geo']; $program = $HTTP_POST_VARS['program']; $size = $HTTP_POST_VARS['size']; $criteria = $HTTP_POST_VARS['criteria']; $purpose = $HTTP_POST_VARS['purpose']; $idAuto = $HTTP_POST_VARS['idAuto']; $set = addslashes($set); $file = addslashes($file); $platform = addslashes( $platform); $other = addslashes($other); $output = addslashes($output); $stats = addslashes($stats); $geo = addslashes($geo); $program = addslashes($program); $size = addslashes($size); $criteria = addslashes($criteria); $purpose = addslashes($purpose); $notes = "\nData request:\nData set: $set\nData file: $file\nComputer platform: $platform\nOther: $other\nOutput format: $output\nStatistical software version: $stats\nGeographical criteria: $geo\nType of program criteria: $program\nSize criteria: $size\nOther criteria: $criteria\nPurpose for research: $purpose\n"; echo "ID: $idAuto
\n"; if (strlen($idAuto) < 1 ){ echo "Error processing request. No ID specified. Please email communityplatformNOREPLY@urban.org.
"; } // $idAutoResult = MYSQL_QUERY("select max(idAuto) as idAuto from sp_users"); // $idAuto = mysql_result($idAutoResult,0,"idAuto"); $query="update admin.sp_users set notes = concat_ws('',notes,'$notes') where idAuto=$idAuto"; $result = MYSQL_QUERY($query); if ( ! $result ){ echo "Problem updating information:
$query

The system administrator has been automatically notified."; mail("communityplatformNOREPLY@urban.org","Data request Problem","Problem retrieving information:\n$query\n","From: nccsdataweb@urban.org\r\n"); } else { $qry2 = "select * from admin.sp_users where idAuto=$idAuto"; $fieldResult = MYSQL_QUERY($qry2); if ( ! $fieldResult ){ mail("communityplatformNOREPLY@urban.org","Data request Problem","Problem retrieving information:\n$qry2\n","From: nccsdataweb@urban.org\r\n"); echo "Problem retrieving information:
$qry2

The system administrator has been automatically notified."; } else { $email = mysql_result($fieldResult,0,"email"); $fname = mysql_result($fieldResult,0,"fname"); $lname = mysql_result($fieldResult,0,"lname"); $title = mysql_result($fieldResult,0,"title"); $org = mysql_result($fieldResult,0,"org"); $OrgType = mysql_result($fieldResult,0,"OrgType"); $address = mysql_result($fieldResult,0,"address"); $city = mysql_result($fieldResult,0,"city"); $state = mysql_result($fieldResult,0,"state"); $zip = mysql_result($fieldResult,0,"zip"); $phone = mysql_result($fieldResult,0,"phone"); $comments = mysql_result($fieldResult,0,"notes"); $reasons = mysql_result($fieldResult,0,"purpose"); mail("communityplatformNOREPLY@urban.org","Data request","$notes\nEmail: $email\nLast name: $lname\nFirst name: $fname\nTitle: $title\nOrganization: $org\nOrganization Type: $OrgType\nAddress: $address\nCity: $city\nState: $state\nZip: $zip\nPhone: $phone\nComments: $comments\nReasons: $reasons\nTo update this record: http://communityplatform.us/PubApps/regis/requestIntro.php","From: nccsdataweb@urban.org\r\n"); include("registration_reg.php"); } } ?>