Need help in debugging php inserting records into Mysql DB

sri2002

I am not sure how do I debug my code. I am not getting any erro but I dont see any records in my DB. This is my code. Any help will be greatly appreciated.
Thanks much
Sri

<html>
<head>
<TITLE>MIRS Customer Feed Back Survey</TITLE>
</HEAD>
<P align=center><STRONG><h4><FONT face=Arial, color="cc0033"><BIG><BIG>Michigan Information Research Services Online User Survey</BIG></BIG></FONT></STRONG></h4></P>
<BODY>
<body bgcolor="#99ccff" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<?php
if (isset($submit))
{
//proces form
$db = mysql_connect ("localhost", "enddebtm_sri", "") or die ('I cannot connect to the database.');
mysql_select_db ("enddebtm_Mirssurvey",$db);
$sql = "INSERT INTO mirs_survey1 (qno, emailid, date, email_alert,capitol_capsule, mirs_service, coverage_written, coverage_democrat, written_repub, ADeep, service, update, competitor, good, accounts, list, bill, price, staff, Rreport, BCalendar, Inet, Attn, version, email, text, list_fundraisers, content_capsule, Mirs_content, Mirs_cover, Mirs_delivery, Mirs_online, Mirs_search, Mirs_newsemail, Mirs_anotherletter, Mirs_otherbipolitical, Mirs_servicecharge, Mirs_keyissues, Mirs_othernewsletters, Mirs_providemore, Mirs_judicial, Mirs_aspects, Mirs likeleast)
VALUES
('','$emailid', '$date', '$email_alert','$capital_capsule','$mirs_service','$coverage_written','$coverage_democrat','$written_repub','$ADeep', '$service', '$update', '$competitor', '$good', '$accounts', '$list', '$bill', '$price', '$staff', '$Rreport', '$BCalendar', '$Inet', '$Attn', '$version', '$email', '$text', '$list_fundraisers', '$content_capsule', '$Mirs_content', '$Mirs_cover', '$Mirs_delivery', '$Mirs_online', '$Mirs_search', '$Mirs_newsemail', '$Mirs_anotherletter', '$Mirs_otherbipolitical', '$Mirs_servicecharge', '$Mirs_keyissues', '$Mirs_othernewsletters', '$Mirs_providemore', '$Mirs_judicial', '$Mirs_aspects', '$Mirs likeleast')";
$result = mysql_query($sql);
echo "ThankYou!\n";
}
else
{
?>
<form id="MIRSSURVEY" name="MIRSFORM" method="post" action="<?PHP echo $PHP_SELF?>">
<p><FONT face=Arial>Email ID:             
<INPUT type="text" name="emailID"</FONT> </P>
<p><FONT face=Arial>Today's Date:             
<INPUT type="text" name="date" value ="<?php $today = date("m.d.y"); print $today;?>"</FONT> </P>
<p><FONT face=Arial>
<p><FONT face=Arial>
25.) The daily content of MIRS Capitol Capsule is too long and provides too much information.<br>
<INPUT type="radio" name="content_capsule" value="1">1</option>
<INPUT type="radio" name="content_capsule"Option value="2">2</option>
<INPUT type="radio" name="content_capsule"Option value="3">3</option>
<INPUT type="radio" name="content_capsule"Option value="4">4</option>
<INPUT type="radio" name="content_capsule"Option value="5">NA</option>
</FONT> </P>
<p><FONT face=Arial>
26.) The daily content of MIRS Capitol Capsule is well edited, well written and to the point.<br>
<INPUT type="radio" name="Mirs_content" value="1">1</option>
<INPUT type="radio" name="Mirs_content"Option value="2">2</option>
<INPUT type="radio" name="Mirs_content"Option value="3">3</option>
<INPUT type="radio" name="Mirs_content"Option value="4">4</option>
<INPUT type="radio" name="Mirs_content"Option value="5">NA</option>
</FONT> </P>
<p><FONT face=Arial>
27.) MIRS covers the events and happenings that are important to know about.<br>
<INPUT type="radio" name="Mirs_cover" value="1">1</option>
<INPUT type="radio" name="Mirs_cover"Option value="2">2</option>
<INPUT type="radio" name="Mirs_cover"Option value="3">3</option>
<INPUT type="radio" name="Mirs_cover"Option value="4">4</option>
<INPUT type="radio" name="Mirs_cover"Option value="5">NA</option>
</FONT> </P>
<p><FONT face=Arial>
28.) I receive MIRS by delivery and have found the delivery service employed by MIRS to be reliable and timely.<br>
<INPUT type="radio" name="Mirs_delivery" value="1">1</option>
<INPUT type="radio" name="Mirs_delivery"Option value="2">2</option>
<INPUT type="radio" name="Mirs_delivery"Option value="3">3</option>
<INPUT type="radio" name="Mirs_delivery"Option value="4">4</option>
<INPUT type="radio" name="Mirs_delivery"Option value="5">NA</option>
</FONT> </P>
<p><FONT face=Arial>
29.) I am aware that MIRS is available on-line.<br>
<INPUT type="radio" name="Mirs_online"Option value="1">Yes</option>
<INPUT type="radio" name="Mirs_online"Option value="0">NO</option>
</FONT> </P>
<p><FONT face=Arial>
30.) I am aware that on-line I can search back articles by keyword and by date.<br>
<INPUT type="radio" name="Mirs_search"Option value="1">Yes</option>
<INPUT type="radio" name="Mirs_search"Option value="0">NO</option>
</FONT> </P>
<p><FONT face=Arial>

31.) I receive other news services by e-mail.<br>
<INPUT type="radio" name="Mirs_newsemail"Option value="1">Yes</option>
<INPUT type="radio" name="Mirs_newsemail"Option value="0">NO</option>
</FONT> </P>
<p><FONT face=Arial>
32.) I subscribe to and read another daily Michigan government newsletters in addition to MIRS.<br>
<INPUT type="radio" name="Mirs_anotherletter"Option value="1">Yes</option>
<INPUT type="radio" name="Mirs_anotherletter"Option value="0">NO</option>
</FONT> </P>
<p><FONT face=Arial>
33.) I subscribe and read other bi-weekly political newsletters.<br>
<INPUT type="radio" name="Mirs_otherbipolitical"Option value="1">Yes</option>
<INPUT type="radio" name="Mirs_otherbipolitical"Option value="0">NO</option>
</FONT> </P>
<p><FONT face=Arial>

34.) MIRS does a good job of informing clients of service changes.<br>
<INPUT type="radio" name="Mirs_sericecharge" value="1">1</option>
<INPUT type="radio" name="Mirs_sericecharge"Option value="2">2</option>
<INPUT type="radio" name="Mirs_sericecharge"Option value="3">3</option>
<INPUT type="radio" name="Mirs_sericecharge"Option value="4">4</option>
<INPUT type="radio" name="Mirs_sericecharge"Option value="5">NA</option>
</FONT> </P>
<p><FONT face=Arial>
35.) MIRS Capitol Capsule articles properly characterize what is going on surrounding key issues.<br>
<INPUT type="radio" name="Mirs_keyissues" value="1">1</option>
<INPUT type="radio" name="Mirs_keyissues"Option value="2">2</option>
<INPUT type="radio" name="Mirs_keyissues"Option value="3">3</option>
<INPUT type="radio" name="Mirs_keyissues"Option value="4">4</option>
<INPUT type="radio" name="Mirs_keyissues"Option value="5">NA</option>
</FONT> </P>
<p><FONT face=Arial>
36.) MIRS Capitol Capsule articles provide more analysis than other daily Michigan government newsletters.<br>
<INPUT type="radio" name="Mirs_othernewsletters" value="1">1</option>
<INPUT type="radio" name="Mirs_othernewsletters"Option value="2">2</option>
<INPUT type="radio" name="Mirs_othernewsletters"Option value="3">3</option>
<INPUT type="radio" name="Mirs_othernewsletters"Option value="4">4</option>
<INPUT type="radio" name="Mirs_othernewsletters"Option value="5">NA</option>
</FONT> </P>
<p><FONT face=Arial>
37.) MIRS Capitol Capsule articles do not provide as much analysis as other daily newsletters.<br>
<INPUT type="radio" name="Mirs_providemore" value="1">1</option>
<INPUT type="radio" name="Mirs_providemore"Option value="2">2</option>
<INPUT type="radio" name="Mirs_providemore"Option value="3">3</option>
<INPUT type="radio" name="Mirs_providemore"Option value="4">4</option>
<INPUT type="radio" name="Mirs_providemore"Option value="5">NA</option>
</FONT> </P>
<p><FONT face=Arial>
38.) The coverage of the state's Judicial Branch inside MIRS is adequate.<br>
<INPUT type="radio" name="Mirs_judicial" value="1">1</option>
<INPUT type="radio" name="Mirs_judicial"Option value="2">2</option>
<INPUT type="radio" name="Mirs_judicial"Option value="3">3</option>
<INPUT type="radio" name="Mirs_judicial"Option value="4">4</option>
<INPUT type="radio" name="Mirs_judicial"Option value="5">NA</option>
</FONT> </P>
<p><FONT face=Arial>
39.) In the space provided, please detail what aspects of MIRS' service you like the most.<br>
<Textarea name="mirs_aspects" cols=40 rows=8 value="mirs_aspectslike"></textarea>
</FONT> </P>
<p><FONT face=Arial>
40.) In the space provided, please detail what aspects of MIRS' service you like least.<br>
<Textarea name="mirs_likeleast" cols=40 rows=8 value="mirs_aspectshate"></textarea>
</FONT> </P>
</SELECT></FONT></TD></TR></TBODY></TABLE>
<p><input type="Submit" name="submit" value="Submit">     <input type="reset" value="Reset"></p>

</script>
<?echo "<?PHP echo $PHP_SELF?>"?>
</form>
<p align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><a href="http://www.mirsnews.com" target="_blank">©
2002 Michigan Information Information & Research Services Inc.</a></font> </p>
<p align="center"> </p>
<?php
}//endif
?>
</body>
</html>

ozzie

$result = mysql_query($sql) or die(mysql_error());

GBahle

In the values part of your SQL statement, you have got one space too many I think. This might be the problem:

VALUES
('','$emailid', '$date', '$email_alert','$capital_capsule','$mirs_service',
'$coverage_written','$coverage_democrat','$written
repub','$ADeep', '$service', '$update', '$competitor', '$good', '$accounts', '$list', '$bill', '$price', '$staff', '$Rreport', '$BCalendar', '$Inet', '$Attn', '$version', '$email', '$text', '$list_fundraisers', '$content_capsule', '$Mirs_content', '$Mirs_cover', '$Mirs_delivery', '$Mirs_online', '$Mirs_search', '$Mirs_newsemail', '$Mirs_anotherletter', '$Mirs_otherbipolitical', '$Mirs_servicecharge', '$Mirs_keyissues', '$Mirs_othernewsletters', '$Mirs_providemore', '$Mirs_judicial', '$Mirs_aspects', '$Mirs ----> whitespace here!!! likeleast')";

sri2002

Thanks for the help so far. I am close to finding the error now. Now the error is
You have an error in your SQL syntax near 'update,competitor,good,accounts,list,bill,price,staff,Rreport,BCalendar,Inet,Att' at line 1
Where do I look for this error?
Thanks
Sri

Lars_Berg

You should not use update as a column name as it is a reserved word in SQL. Change into something more innocous.

The use of Text may pose the same problem.

GBahle

i don't see any error in your code atm, but is it possible that you misspelled one of the column names of the table?

sri2002

Thanks a lot. I mispelled two column name.
Thanks much
Sri

sri2002

One more problem. 4 columns in my query are not getting update. EmailID the datatype is varchar(255), Date (Datatype is date), two more fields whose data types are varchar(255).
Any ideas??
Thanks
Sri

sri2002

The records inserted seems to be like this:
The 2nd column '','0000-00-00' and the last two columns are the problem ones...

INSERT INTO mirs_survey1 VALUES (6, '', '0000-00-00', 0, 0, 0, 2, 3, 4, 4, 0, 5, 5, 5, 5, 2, 3, 4, 2, 4, 4, 0, 2, 4, 0, 0, 1, 4, 4, 2, 3, 0, 0, 0, 1, 1, 4, 3, 4, 3, 2, '', '');
Thanks
Sri

GBahle

hm, i don't know how your database is set up, but it is possible that a null value is allowed, but an empty string is not. you could try using null (without any quotes) instead of the empty string

about the date, '0000-00-00' isn't a valid date; null would be probably, if the field can be nulled, or else use a dummy like 1970-01-01

sri2002

I still can't understand where the error is.
This is my table script:
CREATE TABLE mirs_survey1 (
qno tinyint(4) NOT NULL auto_increment,
emailid varchar(255) default NULL,
date date default NULL,
email_alert tinyint(4) NOT NULL default '0',
capitol_capsule tinyint(4) NOT NULL default '0',
mirs_service tinyint(4) NOT NULL default '0',
coverage_written tinyint(4) NOT NULL default '0',
coverage_democrat tinyint(4) NOT NULL default '0',
written_repub tinyint(4) NOT NULL default '0',
ADeep tinyint(4) NOT NULL default '0',
service tinyint(4) NOT NULL default '0',
Mirs_update tinyint(4) NOT NULL default '0',
competitor tinyint(4) NOT NULL default '0',
good tinyint(4) NOT NULL default '0',
accounts tinyint(4) NOT NULL default '0',
list tinyint(4) NOT NULL default '0',
bill tinyint(4) NOT NULL default '0',
price tinyint(4) NOT NULL default '0',
staff tinyint(4) NOT NULL default '0',
Rreport tinyint(4) NOT NULL default '0',
BCalendar tinyint(4) NOT NULL default '0',
Inet tinyint(4) NOT NULL default '0',
Attn tinyint(4) NOT NULL default '0',
version tinyint(4) NOT NULL default '0',
email tinyint(4) NOT NULL default '0',
Mirs_text tinyint(4) NOT NULL default '0',
list_fundraisers tinyint(4) NOT NULL default '0',
content_capsule tinyint(4) NOT NULL default '0',
Mirs_content tinyint(4) NOT NULL default '0',
Mirs_cover tinyint(4) NOT NULL default '0',
Mirs_delivery tinyint(4) NOT NULL default '0',
Mirs_online tinyint(4) NOT NULL default '0',
Mirs_search tinyint(4) NOT NULL default '0',
Mirs_newsemail tinyint(4) NOT NULL default '0',
Mirs_anotherletter tinyint(4) NOT NULL default '0',
Mirs_otherbipolitical tinyint(4) NOT NULL default '0',
Mirs_servicecharge tinyint(4) NOT NULL default '0',
Mirs_keyissues tinyint(4) NOT NULL default '0',
Mirs_othernewsletters tinyint(4) NOT NULL default '0',
Mirs_providemore tinyint(4) NOT NULL default '0',
Mirs_judicial tinyint(4) NOT NULL default '0',
mirs_aspects varchar(255) default NULL,
mirs_likeleast varchar(255) default NULL,
PRIMARY KEY (qno),
UNIQUE KEY qno (qno),
KEY qno_2 (qno),
FULLTEXT KEY emailid (emailid)
)
Ideas/thoughts ?
Thanks
Sri

sri2002

Can't understand where I am missing something.
Any thoughts?
Thanks
Sri