'; $s_email1 = safe($f_email1); $s_email2 = safe($f_email2); if($s_email1 !== NULL && $s_email1 == $s_email2) $s_email = $s_email1; else $message .= 'Please enter the same email address twice.
'; $s_firstname = safe($f_firstname); if($s_firstname == NULL) $message .= 'Please enter your first name.
'; $s_lastname = safe($f_lastname); if($s_lastname == NULL) $message .= 'Please enter your last name.
'; $s_company = safe($f_company); $s_address1 = safe($f_address1); if($s_address1 == NULL) $message .= 'Please enter the first line of your address.
'; $s_address2 = safe($f_address2); $s_address3 = safe($f_address3); $s_town = safe($f_town); if($s_town == NULL) $message .= 'Please enter your town.
'; $s_county = safe($f_county); $s_postcode = safe($f_postcode); if($s_postcode == NULL) $message .= 'Please enter your postcode.
'; $s_telephone = safe($f_telephone); if($s_telephone == NULL) $message .= 'Please enter your telephone number.
'; if($message == ''){ $query = "select id from user where name = '$s_username'"; $result = mysql_query($query) or die(sqlDeath(__LINE__, __FILE__)); if(mysql_num_rows($result) > 0){ $message .= 'That username is already in use, please choose another.
'; }else{ $query = "select id from user where email = '$s_email'"; $result = mysql_query($query) or die(sqlDeath(__LINE__, __FILE__)); if(mysql_num_rows($result) > 0){ $message .= 'That email address is already in use, please choose another.
'; }else{ if(!$user_key || $user_key == null){ $message .= 'You must enable cookies to register.
'; }else{ $query = "insert into address values ('', $user_id, '$s_firstname $s_lastname', '$s_company', '$s_address1', '$s_address2', '$s_address3', '$s_town', '$s_county', '$s_postcode', '$s_telephone', 1)"; mysql_query($query) or die(sqlDeath(__LINE__, __FILE__)); $address = mysql_insert_id(); $query = "update user set name = '$s_username', password = '$s_password', email = '$s_email', firstname = '$s_firstname', lastname = '$s_lastname', address = $address, access_level = 1 where id = '$user_id'"; mysql_query($query) or die(sqlDeath(__LINE__, __FILE__)); $registered = true; $mail_to = $admin_email; $mail_subject = 'New Website Account Request.'; $mail_headers = "From: $server_email"; $mail_message = <<

Thank you for registering

You are currently registered.

1) { ?>

You have full access to surfacequery.com content via a subscription.

Your access to surfacequery.com content is currently via our free-of-charge service.

To have your account upgraded for full access please contact Finishing Publications Ltd at office@finpubs.com

Register

Create your own FREE account with surfacequery.com and we will contact you with more details about a subscription or a one-off search.

If you then order a subscription, (or already have a subscription) your free surfacequery.com account will be upgraded and the "author", "journal", "source", "date", "volume" and "page" details will be presented along with the "abstract titles" and "anstracts".

To create your free account and register as a surfacequery.com user please fill in your details below and click the Submit button.

User Name

Enter Password

Confim Password

E-mail Address

Confim E-mail

First Name

Last Name

Company Name

Address Line 1

Address Line 2

Address Line 3

Town

County

Postcode

Telephone Number

If you are an existing Finishing Publications customer please tick this box: checked>