PHP: 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

 

[Loon]

Query Error: Unknown column '$stud' in 'field list'

Do you have a column named "stud" in your table?

 

[QReyes]

Originally posted by Loon
Do you have a column named "stud" in your table?

Yes.

 

[dawizman]

<?php

mysql_connect("localhost","root","") or die("Connection Error: " . mysql_error());

mysql_select_db("thecofc_ama") 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);

?>

Try that

 

[QReyes]

Same error as before:

Query Error: Unknown column '$stud' in 'field list'

 

[dawizman]

Try this then:

<?php

mysql_connect("localhost","root","") or die("Connection Error: " . mysql_error());

mysql_select_db("thecofc_ama") or die ("Database Error:     " . mysql_error());

$result = mysql_query("INSERT INTO sc_nom (stud, studnum, email, pres, vice, sec, treas, proe, pro1, sgt, strep, ndrep, rdrep, datetime) VALUES (`$stud`, `$studnum`, `$email`, `$pres`, `$vice`, `$sec`, `$treas`, `$proe`, `$proi`, `$sgt`, `$strep`, `$ndrep`, `$rdrep`, NOW())") or die("Query Error: ".mysql_error());

mysql_free_result($result);

mysql_close($link);

?>

 

[QReyes]

Thanks for your inputs, guys. BTW, dawizman, that code worked.