using php to INSERT INTO

[david fipp]

I am very new to all of this but man I am having fun with it. In advanced thanks for your help.

I have the below code in a file. I am not sure why it is not working. The connection is working. When I run it I get a result echoed "Entered" but the information is not in the database?

<?php
include('dbconnection.php');

//insert into users table
$name="test";
$email="[e-mail]";
$password="test123";

$sql2="INSERT INTO users SET username='$name', email='$email', password='$password'";
$result2=mysql_query(sql2);

if($sql2){
echo"Entered";
}else{
echo"failed";
}
?>