not inserting

[pinehead18]

<php>
<?php
$con = mysql_connect("localhost","","") or die(mysql_error());
$db = mysql_select_db("pinehead",$con) or die(mysql_error());
$sql = "INSERT INTO users (uname) VALUE ('HI')";

mysql_query($sql);
mysql_close();
echo $sql;
echo "</p>";
echo "Was inserted into the db";
?>
[/code]

This is my code yet it does not insert anything into the db.. Any ideas?

Thank you for your help

[cgraz]

this is covered in the Database Forum sticky (MySQL troubleshooting), but try using mysql_error() to see what it says.

mysql_query($sql) or die(mysql_error());

But before you do that, you may want to change the word VALUE to VALUES 😃

Cgraz

[tasistro]

try

$sql = 'INSERT INTO users (uname) VALUE ("HI")';