Using PHP to add a record

[Anon]

Im very new to PHP and devloping in PHP! ive got a university project to create an admin site... i cant seem to get the following script working

mysql_connect($host, $user, $password);
print "Link : $sname; $link <br>";
$query = "INSERT INTO salford.test VALUES ('$sname')";
$result = mysql_db_query("$db", $query);

basically $sname is a value being passed via a text box...!! once i press the submit button nothing happens and no record is added to the DB... i dont undestand..!! with my knowledge of PL/SQL it should work!! ive got a feeling there is some sort of constraint that doesnt allow me to add date to a DB, but saying that i can add fields via PHPMyAdmin.. your help would be most appreciated!!

[amcgrath]

Umm, is $db actually assigned? If not, try : $db = mysql_connect($host, $user, $password);