[MySQL][PHP]Logowanie, Błąd MySQL Opcje

[Adalberd]

Na podstawie książki robię system logowania:

Przy próbie logowania ( po nacisnięciu przycisku zaloguj) wyskakuje mi bląd mysql:

MySQL ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 'admin' AND password = (password('xxxx'))' at line 1

Oto zapytanie do bazy:

[SQL] pobierz, plaintext 
 
IF (isset($_POST['submit'])) {
$query = "SELECT username. password. admin_level FROM admin" .
       "WHERE  username = '" . $_POST['username'] . "' " .
       "AND password = (password('" . $_POST['password'] . "'))" ;
$result = mysql_query($query)
OR die("MySQL ERROR: ".mysql_error());
$row = mysql_fetch_array($result);
 
[SQL] pobierz, plaintext 

Tabelki:

[SQL] pobierz, plaintext 
CREATE TABLE admin (
username varchar(50) NOT NULL,
password varchar(255) NOT NULL,
admin_level int(2) NOT  NULL,
id int(10) NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id)
);
 
INSERT INTO admin (username, password, admin_level, id)
VALUES('wojtek', PASSWORD('wojtek'), '1', ' ');
 
[SQL] pobierz, plaintext