getting data from a form to a database table

Tiroka

ok i have two files, one which is the form to insert the data and the script file that is suposed to insert the data. I can't seem to get it to work. I know for sure that the tabel in the database is set fine and has all the right permisions.

if you could help me out

this is the form page:

<?php $db = mysql_connect ("localhost", "username", "pass");
mysql_select_db ("tiroka_uk_db", $db);

<body>
<form method=post action="script.php">
First: <input type=text name="first1"><br>
Last: <input type=text name="last1"><br>
Birth: <input type=text name="birth1"><br>
Address: <input type=text name="add1"><br>
City: <input type=tesxt name="city1"><br>
State: <input type=text name="state1"><br>
Zip: <input type=text name="zip1"><br>
Home: <input type=text name="home1"><br>
Cell: <input type=text name="cell1"><br>
<input type=submit value="Submit">
</form>
</body>
</html>

and the script file is as follows:

<?php
$con = mysql_connect("localhost", "username", "pass") or die("Could not connect to server");
$db = mysql_select_db("databasename", $con) or die("Could not select database");

$sql = "INSERT INTO phone (id,first,last,birth,add,city,state,zip,home,cell)
VALUES (' ','$first1','$last1','$birth1,'$add1','$city','$st
ate1','$zip1','$home1','$cell1')";

mysql_query($sql, $con) or die("Could not execute query");

all i ever get is my die message saying it could not execute the query and the data won't go in.I know it connects just fine and selects the database just fine as well. If anyone sees something wrong (other then the fact that i have a connect running to the database in the form page, i know don't need, i just have not taken it out)

Thanks, Tiroka

tomhath

A call to mysql_error() might shed some light on it. I'm going to guess that the "id" column is AUTOINCREMENT, which means you can't supply a value for it (the empty string you are passing is a value). You could pass the keyword NULL without quotes but I prefer to not mention that column at all; try removing both "id" and the '' from the INSERT:

$sql = "INSERT INTO phone (first,last,birth,add,city,state,zip,home,cell)

VALUES ('$first1','$last1','$birth1,'$add1','$city','$st

ate1','$zip1','$home1','$cell1')"; 

mysql_query($sql, $con) or die("Could not execute query " . mysql_error() );

Shadeless

$sql = "INSERT INTO phone (id, first, last, birth, add, city, state, zip, home, cell)

try spaces not sure it works but well easy to try...