data base will not update after inserting data

Hi guys im new to php and I have to do design a blog for a first year project but im stuck atm, the php connects to the database but when i run it and enter contents, nothing happens. as in the database does not update with the contents entered. i dont know what i have done wrong… this is my code:

<?php $dbc = mysql_connect("HOST", "username", "password"); if($dbc){ mysql_select_db("username", $dbc); echo ("Database has successfuly connected."); } else { ("Erorr"); } ?> <?php if(isset($_POST['submit'])){ $author = $_POST['Author']; $title = $_POST['title']; $content = $_POST['Content']; mysql_query("INSERT INTO 'myblog' ('Author', 'Title', 'Content') VALUE ('$author', '$title', '$content')"); } else { ?> Author: title: Content:
<?php } ?>

help would be appreciated. thanks

Sponsor our Newsletter | Privacy Policy | Terms of Service