My first code... doesn't work (what a suprise!)

realized

So i have this html file that is basicly a form. The form calls a PHP that should in theory access the mysql db but it doesn't. well. it kind of does..

Let me start with the code.. the WEBSITE is plane html with a bunch of "input names" for the fields. these are the same names as in the database..

i.e <input name="fname" size=30>
firstname ;P

so anyways..

so when i press submit, it runs the phpscript..

i have LOTS of notes in my php script so i can see where it is failing...

$DBhost = "myhost.isp.com";
$DBuser = "username";
$DBpass = "password";
$DBName = "testing";
$table = "data";
print "Connecting to Database...";
print "<p>";
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");
print "Connected to Database - Sending data...";
print "<p>";
@mysql_select_db("$DBName") or die("Unable to select database $DBName");

$sqlquery = "INSERT INTO $table VALUES('','$fname','$lname','$address','$city','$state','$zip','$hphone','$wphone')";

print "Data Sent!";
print "<p>";
print "Closing Database";
$results = mysql_query($sqlquery);
mysql_close();
print "<p>";
print "Database closed!.. Wait for result..";
print "<p>";
print "File: $fname, $lname ";
print "was added  to the database";
?>

and i get the result..

Connecting to Database...
Connected to Database - Sending data...

Data Sent!

Closing Database

Database closed!.. Wait for result..

File: hihi, john was added to the database

but my mysql database has no records.. if i break part of it i.e host, pass, etc.. i get errors, even if i break the table or db name.. so its connecting.. also i see it connected.

all of the $lname etc matches exactly whats in the database... minus the $ of course.. i.e "$lname" matches "lname" in the database..

what am i missing?

it connects to the database, just doens't add the line..

new7media

It looks to me like you missed just a little bit of code. You need to identify which table fields you are populating. So your INSERT should look like this:

$sqlquery = "INSERT INTO $table ('id','fname','lname','address','city','state','zip','hphone','wphone') VALUES ('','$fname','$lname','$address','$city','$state','$zip','$hphone','$wphone')";

I took a guess on the first field being your unique "id" -- make sure to change this to the name you are using.

Hope this helps!

Roger_Ramjet

You do not need to use an empty string as a placeholder, which is what your query looks like. Just leave out the name of the column and any value for it and it will end up with the default specified for that column.
You cannot insert an empty string into a number type column - it will break your query with an invalid data type. You certainly don't try to insert an empty string into an autoinc column, just leave it to do it's job.