seegy87

The case is this... I am setting up a new site that will contain many different tabs. It will have the ability to sign up and post your own tablatures, so therefore it needs a way to add a record for everytime someone signs up etc. So i made a page called signupprocess.php or something and put at the top my connection details and a query with INSERT INTO (i\'ll post the whole thing further down...) Well, it didn\'t work, so i had an idea! I added a record using phpMyAdmin, and copied the code that it churned up (the confirmation bit thingy). I then deleted the old record so that it wouldn\'t try to overwrite the old thing and cause a problem. I then slapped that code into my php page and it didn\'t work :x I was wondering if anyone could help me... here is my code... <?php $db = mysql_connect(\"localhost\", \"jamieguthrie\", \"******\") or die(\"could not connect\"); mysql_select_db(\"jamieguthrie_uk_db\",$db); ?> <?php INSERT INTO `user` (`userid`, `forename`, `surname`, `fav_tabs`, `fav_quote`) VALUES (\'\', \'Jamie\', \'Guthrie\', \'GreenDay\', \'howdy\'); ?> (that insert bit is exactly what came out of phpMyAdmin) That is what i have basically. The database is called jamieguthrie_uk_db, my username is jamieguthrie, my password is ******, the table i want to add to is called user, there are 5 rows (you can see them in the coding) Please help, as i don\'t know what i have done wrong :? P.S. that \'\' before the \'Jamie\' bit in the VALUES bit is a double \'. It is the id set to autoincrement so it hasn\'t been filled in.