In message <[EMAIL PROTECTED]>, Grant Harrington <[EMAIL PROTECTED]> writes > >CREATE TABLE `january08_practices` ( > `email` varchar(100) default NULL, > `Practices` varchar(100) default NULL, > `Fees` varchar(100) default NULL, > `id` int(11) NOT NULL default '0', > PRIMARY KEY (`id`) >) ENGINE=MyISAM DEFAULT CHARSET=latin1 > >I then have a form that when submitted goes to me and someone else,
Not sure what you mean by that. A form, when submitted, would go to another page. What does that page do? >However, once I added the other emails and yes/no fields new form >submissions won't populate the DB. Does it have something to do with >the id and auto-increment? You haven't said what error you are getting, so it's a little difficult. But, you don't have an auto-increment in this table... If you mean the id field, it would be `id` int(11) NOT NULL auto_increment You can leave the id blank when you enter a new record, or (my preference) set id=0, and it will increment the value of the field. Perhaps, because you don't have autoinc set, you are getting a duplicate key, and the software is not telling you? >Is there a quick and easy bit of PHP code to pull the results of the >Practices and Fees from the DB and place it in a table on the website? It's very simple to do, but I think that all your questions in this area are answered at http://www.tizag.com/mysqlTutorial/mysqltables.php which takes you through creating a (database) table, to creating a (html) table. As an aside, varchar(100) doesn't seem right, especially for fees... -- Pete Clark Sunny Andalucia http://hotcosta.com/Andalucia.Spain
