Re: Data errors in entering

The problem is in your insert statement. You forgot the $ on your month and year variable values. Your statement should read: $sql = "INSERT INTO $table_name (day,daydate,month,year,time,place,numbers, details,reportby) VALUES ('$day',$daydate,$month,$year,'$time','$place','$numbers','$details','$reportby')"; ^ ^ Another note, you do not need the quotes around your integer values for $daydate, $month, $year. You also should use single quotes on the other values rather than double quotes. Shane Barry <boomer@redbrick.dcu.ie> said: > I seem to be having a problem with a php script I use to enter data into a > sql database from a php frontend. The data are ints (months and years as > a number). > > The Database is : > > +----------+---------+------+-----+---------+-------+ > | Field | Type | Null | Key | Default | Extra | > +----------+---------+------+-----+---------+-------+ > | day | text | YES | | NULL | | > | daydate | int(11) | YES | | NULL | | > | month | int(11) | YES | | NULL | | > | year | int(11) | YES | | NULL | | > | time | text | YES | | NULL | | > | place | text | YES | | NULL | | > | numbers | text | YES | | NULL | | > | details | text | YES | | NULL | | > | reportby | text | YES | | NULL | | > +----------+---------+------+-----+---------+-------+ > > The html file takes the data in as (Using the post method): > > <P><STRONG>DATE:</STRONG><BR> > <INPUT TYPE="int" NAME="daydate" SIZE=10 MAXLENGTH=10></p> > > <P><STRONG>MONTH:</STRONG><BR> > <INPUT TYPE="int" NAME="month" SIZE=10 MAXLENGTH=10></p> > > <P><STRONG>YEAR:</STRONG><BR> > <INPUT TYPE="int" NAME="year" SIZE=10 MAXLENGTH=10></p> > > and the php script interacts with the data as: > > $sql = "INSERT INTO $table_name > (day, daydate, month, year, time, place, numbers, details, > reportby) > VALUES > ("$day", "$daydate", "month", "year", > "$time", > "$place","$numbers","$details", "$reportby") > "; > > The Sections affected are month and year all the others including daydate > which is exactly the same are working. Can someone please point out the > error to me? > > Shane > > -- > Webmaster > Dublin & Wicklow Mountain Rescue Team > www.dwmrt.ie > > Irish Mountain Rescue Association > imra.ie.eu.org > > ICQ # 103528846 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > --