Problem with INSERT statement

Hi

I'm trying to insert data into a database via a form.

The form has a drop down menu called $name

and a textarea called $report

I'm sure my problem has something to do with the INSERT statement syntax.

Can someone help with this please?

if (isset($_POST['submit'])) {
$name = $_POST['name'];
$report = $_POST['report'];
$output_form = 'no';

if (empty($name) || empty($report)) {
echo 'Please fill in all fields.<br />';
$output_form = 'yes';
}
}
else {
$output_form = 'yes';
}

if (!empty($name) && !empty($report)) {
$dbc = mysqli_connect('127.0.0.1', 'root', 'root', 'abe')
or die('Error connecting to MySQL server.');
date_default_timezone_set('Europe/London');
$date = date('Y'-'m'-'d');
$query = ("INSERT INTO reports VALUES ('', '$name', '$report', '$date')") or die(mysqli_error());
mysqli_query($dbc, $query)
or die ('Data not inserted.');

echo 'data added.';

mysqli_close($dbc);
}

Best regards maxwellmb