I'm new to the list and PHP/MySQL. I'm a long time Access DB user (not power user, but close), so I understand the concept of queries, forms, reports, table layout, etc...
I've got two quick questions. I have created a DB with the following fields 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, and is supposed to dump the data to a MySQL DB. I set it up, and when I tested it, it added the info as it should. I then (using CocoaMySQL on the Macintosh) added previously emailed results. It's a simple survey asking for email address, and two yes/no questions. 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? I'm only sending the email, Practices, and Fees to the DB (the first test form submit created id=0, I then added 1, 2, 3, etc...) I'm using FormsToGo to create the form and here are the settings for the DB dump: http://skitch.com/harringg/rm6s/mysql-settings 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? Practices|Fees yes|no yes|yes no|no etc... Thanks, Grant [Non-text portions of this message have been removed]
