I'm having trouble inserting records into a MYSQL database using PHP 5 (don't have the exact version. I can insert records directly in the table itself. What makes this strange is that the code below already exists from prior coding and works fine. I used the same exact syntax for the new database and table, but it will not insert any records. I receive no error messages either. Any suggestions?
------------------------------------------
<?
$conn=mysql_connect("mysql", "User", "Password")or die(mysql_error());
mysql_select_db("eventcal",$conn)or die(mysql_error());
mysql_query("INSERT INTO eventshows(date,event_name,desc,links_page)VALUES
('$_POST[date]','$_POST[event_name]','$_POST[desc]','$_POST[links_page]')");
Print "Thank you for updating the event calendar!";
?>
------------------------------------
MySQL client version: 5.1.55
Thanks
Chelsea
------------------------------------------
<?
$conn=mysql_connect("mysql", "User", "Password")or die(mysql_error());
mysql_select_db("eventcal",$conn)or die(mysql_error());
mysql_query("INSERT INTO eventshows(date,event_name,desc,links_page)VALUES
('$_POST[date]','$_POST[event_name]','$_POST[desc]','$_POST[links_page]')");
Print "Thank you for updating the event calendar!";
?>
------------------------------------
MySQL client version: 5.1.55
Thanks
Chelsea