script inserts BLANK ROWS into mysql db

[ppatwari]

Hi
I have 2 different .php files: 1. submit.php and 2. createentry.php

Submit.php has all the html form tags and calls createentry.php upon button selection. here is the code of createentry.php

<?php
mysql_connect("localhost", "parth", "patwari") or
die ("Coultn't connect to database.");
mysql_select_db("sitenoc") or
die ("Couldn't slect database.");
if($submit = "Sign!" )
{
$query = "INSERT INTO test1
(fname,lname,email) VALUES
('$f_name','$l_name','$e_mail')";

$result = mysql_query($query);// or 
			//die (mysql_error());

?>

<h2> did it </h2>

<?php
}
else
{
include ("submit.php");
}
?>

Now I don't know why but in my table (test1) all the rows are blank. It doesn't carry all the data which I typed into the textboxes of submit.php

Can anyone help me?

Thanks,

Parth

[hand]

Since for security reasons register_globals is set to off (php.ini):

Instead of $f_name , $l_name, $e_mail try to use:

if form method="get": $GET[f_name], $GET[l_name], $_GET[e_mail] or

if form method="post": $POST[f_name], $POST[l_name], $_POST[e_mail]

$query = "INSERT INTO test1 
(fname,lname,email) VALUES 
('$_GET[f_name]', '$_GET[l_name]', '$_GET[e_mail]')";