Script not working when sending message

[pcw]

Hi, I have this script, it all works fine until it gets to the message sending point. What I want is if the $registerMail variable is set to yes then send the message and redirect user to login page, if not then just redirect the user to the login page.

 

However once registered, the user is sent to the login page and the message isnt sent.

 

<?php

include_once("data/server.php");

function decode_variable(&$siteName)
{
    $siteName = urldecode($siteName);
    $siteName = str_replace('%20',' ',$siteName); 
    return $siteName;
} 

decode_variable($siteName);

$registerMail = $_GET['regMail'];

$password1 = $_POST['password1'];
$password2 = $_POST['password2'];
// Get Posted Variables

$username = $_POST['username'];
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$address = $_POST['address'];
$town = $_POST['town'];
$county = $_POST['county'];
$postcode = $_POST['postcode'];
$email = $_POST['email'];
$approved = "no";
$IP = $_SERVER['REMOTE_ADDR'];

if ($password1 != $password2) {

echo "Your passwords did not match, please go back and register again";

} else {

// MySQL Connection

include_once("data/mysql.php");

$mysqlPassword = (base64_decode($mysqlpword));

$con = mysql_connect("$localhost", "$mysqlusername", "$mysqlPassword") or die(mysql_error());
mysql_select_db("$dbname", $con) or die(mysql_error());


$query = "SELECT COUNT(*) AS count FROM members WHERE username='$username'";
$results = mysql_query($query) or die ("Error reading from database");
$existingUsername = mysql_fetch_array($results);

if ($existingUsername['count'] > 0) {

echo "I'm sorry our database already contains that username please choose a new username to continue. ";

} else {

///// Check IP address does not belong to a unapproved user

$query = "SELECT COUNT(*) AS count FROM members WHERE IP='$IP' AND approved='$approved'";
$results = mysql_query($query) or die ("Error reading from database");
$bannedIP = mysql_fetch_array($results);

if ($bannedIP['count'] > 0) {
echo "I'm sorry your IP address has been banned from registering another account, please contact $adminEmail  ";

} else {

$sql = "INSERT INTO members (IP, username, firstname, lastname, address, town, county, postcode, email, password, approved)
VALUES
('$_SERVER[REMOTE_ADDR]','$_POST[username]','$_POST[firstname]','$_POST[lastname]','$_POST[address]','$_POST[town]','$_POST[county]','$_POST[postcode]','$_POST[email]','$_POST[password2]','$approved')";

mysql_query($sql,$con);
mysql_close($con);

}
}
}
///////////////// Send registration Mail ///////////////////////////

if ($registerMail == 'yes') {


$bodyReg = file_get_contents('data/registrationMail.php');

$to = "$email";
$subject = "Welcome to $siteName";
$body = "\nDear $firstname;\n$bodyReg\nUsername: $username\n Password: $password2;";
$headers = "From: $adminEmail\r\n" .
     "X-Mailer: php";
if (mail($to, $subject, $body, $headers)) {
echo "Registration Successful. You will be redirected to login in 5 seconds.";

?>

<meta http-equiv="REFRESH" content="5;url=../login.html">

<?php

}
} else {

echo "Registration Successful. You will be redirected to login in 5 seconds.";

?>

<meta http-equiv="REFRESH" content="5;url=../login.html">

<?php
}


?>

 

As always any help is much appreciated

[pcw]

Hi,

 

Can anyone help with this please?

[pcw]

SOLVED - I was trying to retreive the wrong variable lol

[Maq]

SOLVED - I was trying to retreive the wrong variable lol