Database Code Issues

[danielwtn]

using assorted guides on the internet, i managed to peice together a php code for opening a database, writing values to it, and closing it; but for some reason it doesn't work. i wanted to know whether or not it was my code or my database, and if it is the code how do i fix it?

Here is my code:

<?php
$fname=$_POST[fname];
$lname=$_POST[lname];
$uname=$_POST[uname];
$pname=$_POST[pname];
$ename=$_POST[ename];
$member=mysql_connect(localhost,ncpi_danielwtn,danny21);
mysql_query(members,$member);
$register=insert into members (firstname,lastname,username,password,email) values ($fname,$lname,$uname,$pname,$ename);
mysql_query(members,$register);
mysql_close($member);
?>

[Ed]

Try after your query:

CODE

echo mysql_error();

Also, you really should be sanitizing the values being inserted by using http://www.php.net/mysql-real-escape-string