I am only a beginner but I always use single quotes, I am using mySQL.
Such 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 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'
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 p
