<?
  Header('Cache-Control: no-cache');
  Header('Pragma: no-cache');
?>

<?php

$user=$_POST['username'];

$pass=$_POST['password'];

$con = mysql_connect("mysql7.000webhost.com","a9804977_game","rick14");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("a9804977_data", $con);


$sql="SELECT * FROM members WHERE username = '".$user."'";

$result = mysql_query($sql);

while($row = mysql_fetch_array($result)){

if ($row['username']==$user){

echo "<center><a href='register.php'><-Back </a>Username already exists.</center><br>";

}

else{

$query="INSERT INTO members(username,password) VALUES('$_POST[username]','$_POST[password]')";

$result=mysql_query($query);

echo "<center>Registration successful!</br> Username:$_POST[username]<br>Password:$_POST[password]</center>";

}

mysql_close($con);

?>