toolman Posted December 21, 2009 Share Posted December 21, 2009 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? Quote Link to comment Share on other sites More sharing options...
Vebut Posted December 21, 2009 Share Posted December 21, 2009 mysql_select_db("***, $connection"); should be mysql_select_db("***", $connection); Quote Link to comment Share on other sites More sharing options...
toolman Posted December 21, 2009 Author Share Posted December 21, 2009 Many thanks! Quote Link to comment Share on other sites More sharing options...
Vebut Posted December 21, 2009 Share Posted December 21, 2009 You're welcome Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.