Updated Code

MelissaGPeck

I posted my first one but
I kind of updated it to this:
<html>
<body>

<?php
if ($submit)
{ // form processor

$db = mysql_connect('localhost', "scholarships", "michael219");
if (!$db) { echo "Error connecting to the database"; exit; }

// mysql_select_db("usaa-scholarships_org-testdb",$db);

$sql = "INSERT INTO tbl_test (firstname ='$firstname')";
//$sql = "INSERT INTO tbl_test (lastname = '$lastname')";

echo "<P>$sql</P>";
mysql_close($dbconn);
// $result = mysql_query($sql);

echo "Thank you! Your Information Has Been Entered.\n";

?>
//} else{

// display form

// <form method="post" action= "<?php echo $PHP_SELF; ?>">
// First Name:<input type="Text" name="firstname" value ="<? echo $firstname ?>"><br>
// Last Name:<input type="Text" name="lastname"><br>
// <input type="Submit" name="submit" value="Enter information">
//</form>
</body>
</html>
I tried to isolate the problem by commenting out phases of it. Probably not a smart move but I hoped it would show me my error. This one only uses 2 fields and is a test daabase that I made up. The other one is the actual database, but if I can get this one running I can hopefully translate it into the other one. I don't need any fancy stuff just grab the info witht the form then sock the info into the DB.
Thanks guys.

pjleonhardt

Originally posted by MelissaGPeck
I posted my first one but
I kind of updated it to this:
<html>
<body>

<?php
if ($submit)
{ // form processor

$db = mysql_connect('localhost', "scholarships", "michael219");
if (!$db) { echo "Error connecting to the database"; exit; }

// mysql_select_db("usaa-scholarships_org-testdb",$db);

$sql = "INSERT INTO tbl_test (firstname ='$firstname')";
//$sql = "INSERT INTO tbl_test (lastname = '$lastname')";

--------------------------------------------------------------------------------

echo "<P>$sql</P>";
mysql_close($dbconn);
// $result = mysql_query($sql);

echo "Thank you! Your Information Has Been Entered.\n";

?>
//} else{

// display form

// <form method="post" action= "<?php echo $PHP_SELF; ?>">
// First Name:<input type="Text" name="firstname" value ="<? echo $firstname ?>"><br>
// Last Name:<input type="Text" name="lastname"><br>
// <input type="Submit" name="submit" value="Enter information">
//</form>
</body>
</html>
I tried to isolate the problem by commenting out phases of it. Probably not a smart move but I hoped it would show me my error. This one only uses 2 fields and is a test daabase that I made up. The other one is the actual database, but if I can get this one running I can hopefully translate it into the other one. I don't need any fancy stuff just grab the info witht the form then sock the info into the DB.
Thanks guys.

try this

<html>
<body>

<?php
$submit = $_POST['submit'];
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
if ($submit == "Enter information") 
{  //  form processor



 $db = mysql_connect('xxxx', "xxxx", "xxxx") or die("Error connecting to db: ". mysql_error());

 mysql_select_db("usaa-scholarships_org_-_testdb",$db);

$sql = "INSERT INTO tbl_test (firstname, lastname) VALUES (".$firstname.", ".$lastname.")";


//--------------------------------------------------------------------------------


echo "<P>$sql</P>";
mysql_close($dbconn); 
//  $result = mysql_query($sql);

  echo "Thank you! Your Information Has Been Entered.\n";


} else{

// display form
?>
<form method="post" action= "<?php echo $PHP_SELF; ?>">
First Name:<input type="Text" name="firstname"><br>
Last Name:<input type="Text" name="lastname"><br>
<input type="Submit" name="submit" value="Enter information">
</form>
</body>
</html>

my guess what be that globals are off...
so you have to grab the variable either using $POST or $GET depending on the method of the form..

Also, I made your query a lil smaller

where you have
echo $PHP_SELF
I'm pretty sure you're going to have to change that.. I know there is a new way to do that with reg_globals off but I'll let you research that.