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]

Reply via email to