Re: Data errors in entering

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: 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