Insert Query through PHP does not insert data into MySQL Table

[servo]

I am using the following code. Why it does not insert record in the MySQL Table through php script:

<?php
$dbhost='localhost';
$dbuser='root';
$dbpass='newpass';
$mysqldb='mysql';
 
if(isset($_POST['add'])){
 
$username=$_POST['username']; // echo test for $username is OK
$password=$_POST['password']; // echo test for $password is OK
 
$conn=mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting MySQL'); mysql_select_db($mysqldb) or die ('Error connecting database');
 
$query = "INSERT INTO user (host, user, password, select_priv, insert_priv, update_priv) VALUES ('localhost', '$username', PASSWORD ('password'), 'Y', 'Y', 'Y')";
 
//more code to close database and html form
?>

Plz help me regarding this.

Regards

[pbmods]

Heya, Servo.

You need to execute your query using mysql_query().

Please use CODE tags when posting source code:

[CODE=php]
PHP code goes here.
[/CODE]

[pbmods]

While you're at it, check out this article for more information on creating MySQL User accounts.