$value) { // escape the element if(!is_array($_POST[$key])){$_POST[$key] = mysql_escape_string($value);} } // get the mysql class require_once("mysql.class.php"); // instantiate $mysql = new MYSQL_Wrapper(DB_USERNAME, DB_PASSWORD, DB_SERVER, 'twest2'); // if user doesn't want to subscribe to newsletter $receive_newsletter = 0; if (isset($_POST['receive_newsletter'])) $receive_newsletter = 1; // construct the query $query = " insert into win_million (title, first_name, last_name, partner, street_1, street_2, suburb, state, postcode, country, phone_home, phone_work, phone_mobile, email, marital_status, age_group, income, last_holiday, own_home, submitted_ts, referrer, ip_address, receive_newsletter) values ( '{$_POST['title']}', '{$_POST['first_name']}', '{$_POST['last_name']}', '{$_POST['partner']}', '{$_POST['street_1']}', '{$_POST['street_2']}', '{$_POST['suburb']}', '{$_POST['state']}', '{$_POST['postcode']}', '{$_POST['country']}', '{$_POST['phone_home']}', '{$_POST['phone_work']}', '{$_POST['phone_mobile']}', '{$_POST['email']}', '{$_POST['marital_status']}', '{$age_group}', '{$_POST['income']}', '{$_POST['last_holiday']}', '{$_POST['own_home']}', NOW(), '{$_SERVER['HTTP_REFERER']}', '{$_SERVER['REMOTE_ADDR']}', {$receive_newsletter} )"; //print $query;die; // run the query if ($mysql->insert($query)) { require_once("functions.php"); send_email($_POST['email'], $_POST['first_name'], $_POST['receive_newsletter']); header("Location: thankyou.php"); } else { // show success $outcome_msg = ""; } } else { $hasError = true; } } function check_field ($fieldname, $fieldvalue, $str) { if (isset($_POST[$fieldname])) { if (strpos($_POST[$fieldname], $fieldvalue) !== false) return $str; } } function check_checkbox ($fieldname, $fieldvalue) { if (isset($_POST[$fieldname])) { if (in_array($fieldvalue, $_POST[$fieldname])) return "checked"; } } ?> Win a Million With Trendwest

All questions must be answered. No purchase necessary to enter contest or redeem prizes.

This contest is open to residents of Australia, New Zealand, Fiji, USA & Canada over the age of 18 years. There is a limit of one entry per household.

Title:
First name:
Last name:
Partner:
Address:

Suburb/city:
State:
Postcode:
Country
Phone (H):
Phone (W):
Mobile phone:
Email address:
I am currently:
/>Single />Married />Other

My/my partner's age group(s):
(two categories if necessary)
/>18-24 />25-72 />73+

My and my partner's combined household income:
(check one category)
/>Under $40,000
/>$40,000 - $44,000
/>$45,000 - $54,000
/>$55,000 +
When did you last take a holiday?
/>Less than 6 months
/>6 - 12 months
/>More than 1 year
/>Too long to recall!
Own, rent or mortgage home?
/>Own />Rent />Mortgage
checked />
Verification measure:
Please enter the text in the image below.

Please enter the text in the field above.
This question helps ensure that each competition entry is submitted by a person manually. Too difficult to read? Request a new image.