Im also using bravenet premem with the my sql database and hat i think its not conecting right so well heres my cody for register.php
<html><head><title>Register</title></head><center><h2>Register</h2><hr><body><?php$conn=sql2.bravehost.com('northwind','','');if (!$conn) {exit("Connection Failed: " . $conn);}$sql="SELECT * FROM customers";$rs=($conn,$sql);if (!$rs) {exit("Error in SQL");}<?if ($_POST['submit']){$un = $_POST['username'];$pass = $_POST['password'];$passc = $_POST['passwordc'];$pass2 = $_POST['password'];$un = stripslashes($un);$pass = stripslashes($pass);$passc = stripslashes($passc);if ($un == "") { $error=true; }if ($pass == "") { $error=true; }if ($passc == "") { $error=true; }if ($pass != $passc) { $error=true; }if($error){ echo "The following errors have occured:<br /><ul>"; if ($un == "") { echo "There is no username.<br />"; } if ($pass == "") { echo "There is no password.<br />"; } if ($passc == "") { echo "There is no password confirmation.<br />"; } if ($pass != $passc) { echo "Passwords don't match.<br />"; } echo "</ul>";}else{ $pass=md5($pass); $sql="INSERT INTO users (username, password) VALUES ('$un', '$pass')"; $query=sql2.bravehost.com($sql); if($query) { echo "You are now registered!, You can now <a href='login.php'>Login</a>."; } else { echo "Sorry There was an Error Try Later and it mite be fixed or contact me mikemanx2@hotmail.com"; } exit; }}?><form action="" method="post"><table><tr><td>Username:</td><td><input name="username" type="text" maxlength="20" value="" /></td></tr><tr><td>Password:</td><td><input name="password" type="password" maxlength="16" value="" /></td></tr><tr><td>Confirm Password:</td><td><input name="passwordc" type="password" maxlength="16" value="" /></td></tr><tr><td><input type="submit" value="register" name="submit" /></td></tr></table></form></body></html>