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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]