You're going to hate this ... add the $ so that you have $month, $year.
Miles
PS I've done it too - you red it so many times you no longer see anything.

At 03:10 PM 5/21/01 +0100, Shane Barry wrote:
>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]

Reply via email to