Search the Community

Hi Can anyone help me with this form processor file, I have tried to change the script so it comply's with newer php source. I'm pretty new to php and have some basic knowledge, I usaully find something on the internet that will point me in the right direction but everything i try just stinks. Can someone give me some examples how to change this code. <?php $where_form_is="http://".$_SERVER['SERVER_NAME'].strrev(strstr(strrev($_SERVER['PHP_SELF']),"/")); include("config.inc.php"); $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); if(!$link) die ('Could not connect to database: '.mysql_error()); mysql_select_db(DB_DATABASE,$link); $query = "INSERT INTO `".scores."` (field_1,field_2,field_3,field_4,field_5,field_6,field_7,field_8,field_9,field_10,field_11,field_12,field_13,field_14,field_15,field_16,field_17,field_18,field_19,field_20,field_21,field_22,field_23,hiddenField) VALUES ('" . $_POST['field_1'] . "','" . $_POST['field_2'] . "','" . $_POST['field_3'] . "','" . $_POST['field_4'] . "','" . $_POST['field_5'] . "','" . $_POST['field_6'] . "','" . $_POST['field_7'] . "','" . $_POST['field_8'] . "','" . $_POST['field_9'] . "','" . $_POST['field_10'] . "','" . $_POST['field_11'] . "','" . $_POST['field_12'] . "','" . $_POST['field_13'] . "','" . $_POST['field_14'] . "','" . $_POST['field_15'] . "','" . $_POST['field_16'] . "','" . $_POST['field_17'] . "','" . $_POST['field_18'] . "','" . $_POST['field_19'] . "','" . $_POST['field_20'] . "','" . $_POST['field_21'] . "','" . $_POST['field_22'] . "','" . $_POST['field_23'] . "','" . $_POST['hiddenField'] . "')"; mysql_query($query); mysql_close($link); $ToEmail = 'myemail@home.co.uk'; $mailheader = "From: ".$ToEmail."\r\n"; $mailheader .= "Cc: ".$_POST["hiddenField"] . "," . $_POST["field_23"] . ""; mail($ToEmail, "From: " . $_POST['field_1'] . " Week: " . $_POST['field_2'] . " - PredictaScores","Form data: Name: " . $_POST['field_1'] . " Week: " . $_POST['field_2'] . " Game1: " . $_POST['field_3'] . "," . $_POST['field_4'] . " Game2: " . $_POST['field_5'] . "," . $_POST['field_6'] . " Game3: " . $_POST['field_7'] . "," . $_POST['field_8'] . " Game4: " . $_POST['field_9'] . "," . $_POST['field_10'] . " Game5: " . $_POST['field_11'] . "," . $_POST['field_12'] . " Game6: " . $_POST['field_13'] . "," . $_POST['field_14'] . " Game7: " . $_POST['field_15'] . "," . $_POST['field_16'] . " Game8: " . $_POST['field_17'] . "," . $_POST['field_18'] . " Game9: " . $_POST['field_19'] . "," . $_POST['field_20'] . " Game10: " . $_POST['field_21'] . "," . $_POST['field_22'] . " E-mail!: " . $_POST['field_23'] . " ",$mailheader); include("confirm.html"); ?> Thanks thegringo