Help with an insert

[grantus]

This seems like it would be simple enough but I can't figure it out!

I have a form with 3 fields for the user to fill out. They don't have to fill out all of the fields, and this is where my problem is. If I leave the option #3 empty, then it still gets inserted into the database, but it's just an empty row. I don't want this. I want to only insert into the database the fields that were filled in. How would I do this?

Here's what I have:

$option1 = $_POST['option1'];
$option2 = $_POST['option2'];
$option3 = $_POST['option3'];

And my insert query:

$add_answers = "INSERT INTO answers (answer) VALUES ('$option1'), ('$option2'), ('$option3')";

Thanks in advance.

[stolzyboy]

your query shouldn't be working anyway as you have your vars in single quotes

it should real like

$add_answers = "INSERT INTO answers (answer1, answer2, answer3) VALUES ('" . $option1 . "', '" . $option2 . "', '" . $option3 . "')";

and if there is nothing in whatever option, it'll just insert either nothing or a NULL value, the field will always be there

[grantus]

Thanks for the advice. I guess I can live with an empty entry, then I can not show the empty entry when I echo the results.