Wsrtjtyk

I am just fooling around with some sample web pages as I haven't touched form to database submissions for some time and I've noticed mysql_* is no longer widely used and has been replaced with mysqli_*. I have what I believe to be a simple form(can post if needed but I don't think the problem lies within the form). My connection code for the database is as follows,

<?php 

    //addslash() for sanitization

    ExtendedAddslash($_POST);



    //correct form name's for data to be inserted

    $name = $_POST['name'];

    $specName = $_POST['specName'];

    $weight = $_POST['weight'];

    $weightUnits = $_POST['weight-units'];

    $description = $_POST['description'];



    $conn = mysqli_connect("localhost","root","CENSORED","testDB");

    if (mysqli_connect_errno()) {

        echo "Failed to connect to MySQL :" . mysqli_conect_error();

    }

    else {

      echo "Connection was OK!n";

    }



    $result = mysqli_query($conn,"INSERT into 'testDB.users' (name, specName, description, weight, weightUnits) VALUES ('$name','$specName','$description', '$weight', '$weightUnits')");

    if ($result) {

      echo "Successn";

    }

    else {

      echo "Errorn";

    }



    mysqli_close($conn);

  ?>

In the past this worked out pretty straight forward but I have changed some of the syntax to match mysqli standards. The connection test always results in "Connection was OK" however I always seem to get the "Error". Is the problem the $result variable? or am I just not executing this query properly.