为什么我的php文件不会将数据插入我的mysql数据库？

Question

I have been having trouble getting my PHP file to insert data into my database. I have gone so far as making one simple script to put data into my database and it still isn't working. I'm hoping that someone will see something that will make me feel like a dork for having missed it. The code below is what is in my simple script that isn't inserting into my database.

<? php
$con=mysql_connect("localhost","user","password","database"

mysql_query($con,"INSERT INTO table_name (username, pass) VALUES ('bob', 'tom')");

mysql_close($con);

?>

I hope that you guys see the problem because I'm drawing a complete blank.

Answer 1

You're missing mysql_select_db("yourdatabase", $con);

Edit: forget that, you have it in your connection, but like someone commented, you have a syntax error.

You can also use mysql_error() to see what's going wrong.

P.s. the use of the old mysql extension is highly discouraged.