[shnips6]

I am trying to process my first online form with PHP. From my troubleshooting I beleive it is connecting to the database but is having a query problem. I am sure the fix will be quite basic as this is my first attempt at processing a form but I seem to have hit a wall.
If anybody can take a look at my php script and see if any problem sticks out, it would be greatly appreciated.
Thanks a lot. Below is my script:

PHP Code:

<?php
    $property_type = $_POST['property_type'];
    $number_of_bedrooms = $_POST['#_of_bedrooms'];
    $number_of_bathrooms = $_POST['#_of_bathrooms'];
    $state_province = $_POST['state_province'];
    $city = $_POST['city'];
    $address = $_POST['address'];
    $name = $_POST['name'];
    $email = $_POST['email'];
    $phone = $_POST['phone'];
    $additional_info = $_POST['additional_info'];
$dbc = mysqli_connect('localhost', '********', '******', 'circlema_propertydatabase')or die('Error connecting to MySql server');
    $query = "INSERT INTO circlema_propertydatabase (property_type, number_of_bedrooms, number_of_bathrooms, state_province, city, address, " . 
        "name, email, phone, additional_info) " .
        "VALUES ('$property_type', '$number_of_bedrooms', '$number_of_bathrooms', '$state_province', '$city', '$address', " . 
        "'$name', '$email', '$phone', '$additional_info')";
$result = mysqli_query($dbc, $query) or die('Error querying database.');
        mysqli_close($dbc);
?>

[Nico]

1st: Don't post your username and password on the internet (I removed it for you now)
2nd: Instead of using or die('Error querying database.');, use or die(mysqli_error());. That'll give you an exact error message.
3rd: Don't ever put direct user input into your SQL strings. That leaves your site widely open to SQL injections. Call mysqli_real_escape_string() on every user defined variable you're putting into this string.

PHP Code:

$name = mysqli_real_escape_string($_POST['name']); 

This is very important. Read this.