What's wrong with this code?

[QReyes]

<?php
$link = mysql_connect("localhost","root","") or die("Connection Error: ".mysql_error());
mysql_select_db("thecofc_ama",$link) or die ("Database Error:  ".mysql_error());
$result = mysql_query('INSERT INTO `sc_nom` (`stud`, `studnum`, `email`, `pres`, `vice`, `sec`, `treas`, `proe`, `proi`, `sgt`, `strep`, `ndrep`, `rdrep`, `datetime`) VALUES (`$stud`, `$studnum`, `$email`, `$pres`, `$vice`, `$sec`, `$treas`, `$proe`, `$proi`, `$sgt`, `$strep`, `$ndrep`, `$rdrep`, NOW())',$link) or die("Query Error: ".mysql_error());
mysql_free_result($result);
mysql_close($link);
?>

You can try it out at http://thecofclub.distanthost.com/AMA/sc_nom.php