Data errors in entering

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