My code won't work... Help me please.

[mart]

The code below seem to have worked at some point to write the information from the strings into the database, but now, I don't know what happened, all it does is write the date and no other info. Can someone please give me some feedback as to why this is not working?

<?php
$dbHost = "localhost";
$dbUser = "sssss";
$dbPass = "********";
$link = @mysql_connect($dbHost, $dbUser, $dbPass);
$dbName = "vvvvvvv";
$db = mysql_select_db($dbName, $link) or die("couldn't select database");

$date = date("Y-m-d");
$firstname = $POST["First_Name"];
$lastname = $POST["Last_Name"];
$address = $POST["Address1"];
$city = $POST["City"];
$statezip = $POST["State_Zip"];
$phone = $POST["Phone"];
$album = $_POST["album"];

$query = "INSERT INTO orders (date, firstname, lastname, address, city, statezip, phone, album)
VALUES ('$date','$firstname','$lastname','$address','$city','$statezip','$phone','$album')";
mysql_query($query,$link)or die(mysql_error() .'<hr />'.$query.'<hr />');

?>

[Undrium]

Hey! Try this instead, should work.

<?php
$dbHost = "localhost";
$dbUser = "sssss";
$dbPass = "********";
$link = @mysql_connect($dbHost, $dbUser, $dbPass);
$dbName = "vvvvvvv";
$db = mysql_select_db($dbName, $link) or die("couldn't select database");

$date = date("Y-m-d");
$firstname = $_POST["First_Name"];
$lastname = $_POST["Last_Name"];
$address = $_POST["Address1"];
$city = $_POST["City"];
$statezip = $_POST["State_Zip"];
$phone = $_POST["Phone"];
$album = $_POST["album"];

$sql = "INSERT INTO orders SET
		date='$date',
		firstname='$firstname',
		lastname='$lastname',
		address='$address',
		city='$city',
statezip='$statezip',
phone='$phone',
album='$album';


if (@mysql_query($sql)) {
	echo '<p>Your stuff has been added!.</p>';
	} else {
	echo '<p>Error adding account: ' .
		mysql_error() . '</p>';
	}
?>

[Nomaad]

Here ya go, PHP is case sensitive (First_Name is very different from firstname) I changed the code assuming that the code in your query is correct. Also, I fixed the syntax of query for you. You had forgot to concate the INSERT and VALUE statements.

$firstname = $POST['firstname'];
$lastname = $POST['lastname'];
$address = $POST['address'];
$city = $POST['city'];
$statezip = $POST['statezip'];
$phone = $POST['phone'];
$album = $_POST['album'];

$query = "INSERT INTO orders (date, firstname, lastname, address, city, statezip, phone, album)".
"VALUES ('$date', '$firstname', '$lastname', '$address', '$city', '$statezip', '$phone', '$album')";

mysql_query($query,$link)or die(mysql_error() .'<hr />'.$query.'<hr />');

?>

[Nomaad]

Almost forgot, you also need to call the insert into action . . . notice the call to 'insert' you need to set your form button up like this:
<input name="insert" type="submit" id="insert" value="Submit">

if(isset($POST['insert']))
{
$firstname = $POST['firstname'];
$lastname = $POST['lastname'];
$address = $POST['address'];
$city = $POST['city'];
$statezip = $POST['statezip'];
$phone = $POST['phone'];
$album = $POST['album'];

$query = "INSERT INTO orders (date, firstname, lastname, address, city, statezip, phone, album)".
"VALUES ('$date', '$firstname', '$lastname', '$address', '$city', '$statezip', '$phone', '$album')";

mysql_query($query,$link)or die(mysql_error() .'<hr />'.$query.'<hr />');
}

[zipdisk]

It is oK to pur "First_Name" in $_POST[] array though php is case-sentive. First_Name can be a variable in the form only.

[Nadzree]

ya..think so...as long as the text boxt is named the same..