<?php

$LoggedinID2 = $HTTP_SESSION_VARS["LoggedinID"];

echo "$LoggedinID2";

$host="localhost"; // Host name
$username="dsadsad"; // Mysql username
$password="dsadsad"; // Mysql password
$db_name="belmont"; // Database name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$FName = preg_replace('/[^\w]/','',$_POST['FNameupdated']);
$LName = preg_replace('/[^\w]/','',$_POST['LNameupdated']);
$Address1 = preg_replace('/[^\w]/','',$_POST['Address1updated']);
$Address2 = preg_replace('/[^\w]/','',$_POST['Address2updated']);
$Postcode = preg_replace('/[^\w]/','',$_POST['Postcodeupdated']);
$Telephone = preg_replace('/[^\w]/','',$_POST['Telephoneupdated']);
$Mobile = preg_replace('/[^\w]/','',$_POST['Mobileupdated']);
$Email = $_POST['Emailupdated'];

$query = "UPDATE guests
SET FName = '".$FName."', LName = '".$LName."', Address1 = '".$Address1."', Address2 = '".$Address2."', Postcode = '".$Postcode."', Telephone = '".$Telephone."', Mobile = '".$Mobile."', Email = '".$Email."'
WHERE GuestID = '".$LoggedinID2."'"

mysql_query($query) or die ('Error: ');

echo "Data Updated";

?>