Please help me with this code. I can not enter into MySQL and do not know where I'm wrong.
<?php
define('TITLE', 'VIRTUAL MUSEUM');
require ('header.html');
include ('footer1.html');
print '<div id="rightcontent">
<h1>ADD USERS</h1>';
session_start();
if (!isset($_SESSION['user'])){
header('Location:login.php');
exit();
}
else{
if (isset($submit)){
if ($dbc = @mysql_connect ('localhost', 'root', 'pass')) {
if (!@mysql_select_db('room')){
die('<p>Could not select the database because:<b>' . mysql_error() . '</b></p>');
}
} else {
die('<p>Could not connect to MySQL because:<b>' . mysql_error() . '</b></p>');
}
$query = "INSERT INTO admin(user, pass, level,name) VALUES ('$user', '$pass', '$level', '$name')";
if (@mysql_query($query)){
print '<p>User ' . $user. ' added.</p>';
} else {
print "<p>Can not add user because:<b>" . mysql_error() . "</b>. query was $query.</p>";
}
mysql_close();
}
}
?>
