Adding a new record

mtmcfarl

When I try to insert a new record into my database, I get no error, and it seems to work, however, the form fields go blank again, and it doesn't insert into the database. What could be wrong here. Everything is installed correctly. I have no problems displaying the records, I just can't add a new one.

Any Ideas?

Matt

[deleted]

You'll need to post some code, we can't help just from "it doesn't work" 🙂

freddyfiasko

Have U mixed your submit-button with your reset-button????

Freddy....

mtmcfarl

Here is the code:

<?php
if ($submit) {
include("dbcnx.php");
$sql = "INSERT INTO customer (first, last, phone, dlnum, state, email)" .
"VALUES ($first, $last, $phone, $dlnum, $state, $email)";

	if (@mysql_query($sql)) {
	echo("<p>New Customer Added</p>");
	} else {
	echo("<p>Error adding new customer: " . mysql_error() . "</p>");
	}
}

?>

This is the form action:
<form action="<?=$PHP_SELF?>" method="post">

These are my input type buttons:
<input type="submit" name="submit" value="Submit">
<input type="reset" name="reset" value="Reset">
By the way the dbcnx.php file works fine, thats no problem.

Just resets the form and does nothing.
Any ideas?

JDcrack

You may want to add an Or die statement, this will help in weeding out errors:
(also try using apostrophes around your '$values' )

Change:
$sql = "INSERT INTO customer (first, last, phone, dlnum, state, email)" . 
"VALUES ($first, $last, $phone, $dlnum, $state, $email)"; 

To this:
(sql statement should be all on one line)
$sql = "INSERT INTO customer (first, last, phone, dlnum, state, email) 
VALUES ('$first','$last','$phone','$dlnum','$state','$email')";
$result = mysql_query($sql)
or die("ERROR: Values not entered into Table");

mtmcfarl

still no luck. Is it true that when you use <?$PHP_SELF?> that it runs the script that is located on the same page, from the top of the page down?? It seems as if when I click on the submit button, the script interprets the submit as false and does not execute the code inside the if statement.

Any ideas?

Matt