connection problem please help

[Flolondon]

<?php
$host = 'localhost';
$user = 'root';
$pass = '';
$database = 'house';

$connection = mysql_connect ("localhost", "root", "")
or die("Could not connect to server");

mysql_select_db("house", $connection) // profile is the name of your DB
or die("Could not select database");

$name = addslashes ($_POST['name']);
$address = addslashes($_POST['address']);
$email = addslashes($_POST['email']);
$telephone = addslashes($_POST['telephone']);
$comments = addslashes($_POST['comments']);
$deliverytime = $_POST['deliverytime'];
$bread = $_POST['bread'];

$query = "INSERT INTO house (name, address, email, telephone, comments, deliverytime, bread)
VALUES ( '$name', '$address', '$email', '$telephone', '$comments', '$deliverytime', '$bread',)";

$result = mysql_query($query) or die ("Could Not Insert Record Into Database.");

mysql_close($connection);

?>

i get the comment, could not insert record into database

[jatar_k]

change that from

$result = mysql_query($query) or die ("Could Not Insert Record Into Database.");

to

$result = mysql_query($query) or die ("Could Not Insert Record Into Database: " . mysql_error());

that should give you the error from mysql

[Flolondon]

Could Not Insert Record Into Database: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Johne, 53 Stewart Street, Street@yahoo, 23432, asdfsdfff, , ,)' at line 2

this is the error it gave me.. please help

[jatar_k]

it doesn't look like the code you posted and what is actually trying to interact with your db are the same

this has quotes around values
( '$name', '$address', '$email', '$telephone', '$comments', '$deliverytime', '$bread',)

check the manual that corresponds to your MySQL server version for the right syntax to use near 'Johne, 53 Stewart Street, Street@yahoo, 23432, asdfsdfff, , ,)' at line 2

the above does not and should cause an error

also in the top snippet the trailing comma should be removed

[Flolondon]

MySQL 3.23 is the version i am using at present

[Flolondon]

Heo Jatar... so you are saying that the values should have quotes or they should not have quotes? sorry i am bit confused with your answer..

[jatar_k]

they should have them

[Flolondon]

OK. THANKS JATAR

[Habtom]

You might have not null values for the last null values, otherwise the code looks ok to me.

[scriptmasterdel]

If its still failing then could it be something to do with the comma at the end of the insert values?

( '$name', '$address', '$email', '$telephone', '$comments', '$deliverytime', '$bread',)

to ...

( '$name', '$address', '$email', '$telephone', '$comments', '$deliverytime', '$bread')

If this makes no difference then please let me know

Del

[Flolondon]

Thanks so much... it has worked... thanks..

[Flolondon]

Please help. I notice that the last two variables deliverytime and bread were not posted to the database... please help.. what have i done

please note that the last two variables are drop down/select menu

[coopster]

If the rest of the columns were populated then you just don't have data in the variables of the same name there, 'deliverytime' and 'bread'. Have you checked that the <form> variables and the $_POST variables have the same exact-spelled name?

[Flolondon]

ok i can see what i did wrong.. was used the same name for a table for a variable hence it did not go..

but for one of the variables it has not gone through.. ie deliverytime

[Flolondon]

ok i can see what else i did wrong as well. Deliverytime must been some kind of php variable or mysql synax variable or so because as soon as I changed deliverytime to delivery... it worked... thanks... all