PHP and MySQL

[gncreditcards]

Hi, I have this form in html . When it fills the information and send it fails to database information entry.

Why my php form fails to entry the information en the SQL

Thanks



<form method="post" action="/mailinglist/sender.php">
<table border="0" cellpadding="5" ><tr >
<td colspan="2">Unete ay recibe por email de noticias y actividades </td></tr>

<tr><td >E-mail:</td>
<td><input type="text" name="email" size="25"></td>
</tr><tr>
<td>Nombre:</td><td><input type="text" name="fname" size="25"></td></tr>
<tr><td>Apellido:</td>
<td><input type="text" name="lname" size="25"></td>
</tr><tr>
<td>Pais:</td>
<td><input type="text" name="country" size="25"></td>
</tr><tr>
<td colspan="2"align="center"><input type="submit" value="Enviar"></td>
</tr></table></form>


AND A SEND PHP FORM
$conn = mysql_connect("$localhost", "$usernam", "$pass") or die("Invalid server or user."); // Connects to MySQL Database
mysql_select_db("$db", $conn);

//function insert_mail() {

$fname = $_POST['fname'];
$lname = $_POST['lname'];
$email = $_POST['email'];
//}

$sql2="SELECT * FROM mail";
$result2=mysql_query($sql2) or die("select fails");
$no=mysql_num_rows($result2);

if ($no==0) {


$sql = mysql_query("insert into mail(id,fname,lname,email) values(NULL,'$fname','$lname','$email')");
$result = mysql_query($sql);
}

[awatson]

What error are you getting? Try adding:

echo "<!-- $sql -->\n";

Before the "$result=..." and then view source on the page and copy the query. Then run the query on your database via phpmyadmin or command line and see what error you get.