a problem with empty fields and INSERT

earlparkerii

I have a form with 14 fields, the contents of which I would like to insert into a MySQL db (using PHP). Here's the problem- if all the form fields contain data, the row in inserted and it contains the data. However, if some of the fields are left blank, the row is inserted but there is no data to be seen. Would using a default field value help or is there a more elegant solution?

LordShryku

When you insert, are you using
INSERT INTO [table] VALUES
or
INSERT INTO [table] ([field1], [field2]) VALUES

earlparkerii

Good point and something I should have stated. I'm using

INSERT INTO table_name
SET col 1 = $var 1, col 2 = $var 2,...

LordShryku

Hrmm....and you're saying that is one of the fields is left blank, th whole row will be inserted blank? MAybe you should show some code here...

leatherback

Hi,

Add quotes around your values. THat should solve the problem.

Also.. after your $result = mysql_query($query)
place: or die(mysql_error)

This will throw an error with your current query, I suppose.

earlparkerii

Here's the code:

$insert = "INSERT INTO
membership
SET
name = '$name',
fname = '$fname',
mi = '$mi',
lname = '$lname',
address1 = '$address1',
address2 = '$address2',
city = '$city',
state = '$state',
zip = '$zip',
phone = '$phone',
fax = '$fax',
employees = '$employees',
email = '$email',
url = '$url'";
$result = mysql_query($insert) or die('Message: ' . mysql_error());

I'll be out for 3 or so hours but will check in when I get back- thanks for your time!

BTW, the variables were converted from $POST variables, as in $name = $POST['name'];.