insert into mysql db driving me CRAZY!!

[758]

Alright, I have this code, its pretty simple:

mysql_connect('db', 'user', 'pass);
mysql_select_db(test);
$query = "INSERT INTO users(name, user, pass) VALUES('$name', '$user', '$pass')";
$insert = mysql_query($query);

But it will not insert anything into the database. I have tried everything i can think of to get it to work. It hasnt sent back any errors and ive checked the tables over and over. I have also taken the $insert variable out and just used mysql_query($query) but that doesnt work either. Can anybody tell me whats wrong with it???

[sford999]

This mysql_connect('db', 'user', 'pass); should be

mysql_connect('host', 'user', 'pass);
mysql_select_db(dbname);