I have a form: http://www.garlandcnorris.com/registration_tradeShow.html That then goes to this page: <code> $display_block = ""; $date_sub = date("mdY - H:i:s"); $addtocart = "insert into show values('','$_POST[Accnt_name]','$_POST[acc_num]','$_POST[email]','$_POST [auth_buyer]','$_POST[attend_1]','$_POST[attend_2]','$_POST[attend_3]',' $_POST[num_att]', '$date_sub')"; $result = mysql_query($addtocart); mysql_close(); $error = mysql_error(); print "the query I just ran was: $addtocart<br>"; print "the result I just ran was: $result<br>"; print "the error I just ran was: $error<br>"; $display_block = ""; $display_block .= "<center><h1>Thank you for registering for the Garland C Norris 100 year Celebration Trade Show and party!</h1></center>\n<BR><BR>\n<ul>The information you submitted on $date_sub was:<li>Account Name: $_POST[Accnt_name]<li>Account Number: $_POST[acc_num]<li>Email Address: $_POST[email]<li>Authorized Buyer: $_POST[auth_buyer]<li>Attendee: $_POST[attend_1]<li>Attendee: $_POST[attend_2]<li>Attendee: $_POST[attend_3]<li># Attending Party: $_POST[num_att]</li></ul>"; $sendto = "$_POST[email]"; $subject = "Registration Details"; $message = "Thank you for registering for the Garland C Norris 100 year Celebration Trade Show and party! \n\n The information you submitted on $date_sub was: \n Account Name: $_POST[Accnt_name] \n Account Number: $_POST[acc_num] \n Email Address: $_POST[email] \n Authorized Buyer: $_POST[auth_buyer]\nAttendee: $_POST[attend_1]\nAttendee: $_POST[attend_2]\nAttendee: $_POST[attend_3]\n# Attending Party: $_POST[num_att]"; $header = 'From: registration@xxxxxxxxxxxx'; mail($sendto, $subject, $message,$header); $display_block .= "<BR><BR>\n<a href=\"http://www.gcnorris.com/index3.html\";>Click Here</a> to continue through to the Garland C Norris Website.<BR><BR> You should be receiving an email shortly with the information you have just submitted.<BR><BR>We look forward to seeing you in May!"; ?> <HTML> <HEAD> <TITLE>Thanks For Registering</TITLE> <style type="text/css"> <!-- A{text-decoration:none} H{text-transform:capitalize} --> </style> </HEAD> <body bgcolor="#ffffff" topmargin="0" leftmargin="0" bottommargin="0" rightmargin="0" marginwidth="0" marginheight="0" height="100%" width="100%"> <?print $display_block; ?> </BODY> </HTML> </end code> This is the results: the query I just ran was: insert into show values('','robert\'s Test','123456','robert@xxxxxxxxxxxx','Robert','','','','69', '03032004 - 17:30:20') the result I just ran was: the error I just ran was: Thank you for registering for the Garland C Norris 100 year Celebration Trade Show and party! The information you submitted on 03032004 - 17:30:20 was: Account Name: robert\'s Test Account Number: 123456 Email Address: robert@xxxxxxxxxxxx Authorized Buyer: Robert Attendee: Attendee: Attendee: # Attending Party: 69 DB Table: Empty Field descriptions: CREATE TABLE `show` ( `id` int(11) NOT NULL default '0', `act_name` text, `acc_num` int(6) default '0', `email` text, `auth_buyer` text, `attend_1` text, `attend_2` text, `attend_3` text, `num_att` int(2) default NULL, `date_sub` text, PRIMARY KEY (`id`) ) TYPE=MyISAM; There are no errors in the php-error log, the mysql error log, the httpd error log, however there is NOTHING in my 'show' table right now and I should have about 80 things in there. Any thoughts?? I am at my wits end trying to figure out the goofy thing. I have counted the fields (10 for each) so I made doubly sure I have 10 fields in the DB table -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
