help with insert

[toolman]

Hi there,

 

I am trying to insert some data into a database, but for some reason, it is not inserting.

 

Can anyone see anything wrong with my code:

 

<?php

$host = "***";
$username = "***";
$password = "***";


$connection = mysql_connect($host, $username, $password);
mysql_select_db("***, $connection");

mysql_query("INSERT INTO events14 (name)
VALUES ('$_POST[name]')");

?>

 

I have also set up an ID field which auto increments and this seems to be working, but nothing is being entered into the "name" field.

 

This is my form:

 

<form action="add_event.php" method="post">
<input type="text" name="name" id="textfield" />
<input type="submit" name="button" id="button" value="Submit" />
</form>

 

 

The file with the php code is called add_event.php, so everything is on one page.

 

Any ideas what I have wrong?

 

[Vebut]

mysql_select_db("***, $connection"); should be mysql_select_db("***", $connection);

[toolman]

Many thanks! 

[Vebut]

You're welcome