null form variables???

Anon

I have a form with various fields. If all aren't filled out, how can I get it to add NULL to the mysql db. Right now it must be entering a space or something because if I do a (Select * from NAME Where SOMETHING IS NOT NULL) it show everything including the black fields.

Form is currently: (example input)

<td width=50 class="sans">First:</td><td><input type="Text" name="first_name" value="<?php echo $first_name?>" size="30">

processing page:

<?php

$db = mysql_pconnect("pittweb");

mysql_select_db("mylan");

$sql = "INSERT INTO members (first_name,last_name,address,company,faxlist,city,state,
zip,k,q,conference,calendar,christmas,pocketcal,email,phone,fax) VALUES
('$first_name','$last_name','$address','$company','$faxlist','$city','$state',
'$zip','$k','$q','$conference','$calendar','$christmas','$pocketcal','$email',
'$phone','$fax')";

$result = mysql_query($sql);

Anon

You'll need to check each variable to see if it holds a value other than "". If it doesn then you need to change that variable to = "NULL".

Anon

That's what I'm trying to figure out how to do. I keep trying but my format is all wrong.

Anon

<?php

$db = mysql_pconnect("pittweb");

mysql_select_db("mylan");

// Do this for each of your variables
// It's a basic test that could be written better but I don't have the time

if ($first_name == "") {
then $first_name = "NULL";
}

$result = mysql_query($sql);

Anon

I've done the following for a few:

$db = mysql_pconnect("pittweb");

mysql_select_db("mylan");

if ($first_name == "") {
then $first_name = "NULL";
}

if ($email == "") {
then $email = "NULL";
}

if ($phone == "") {
then $phone = "NULL";
}

if ($fax == "") {
then $fax = "NULL";
}

$result = mysql_query($sql);

and get the following error.

Parse error: parse error in /usr/local/etc/httpd/vhosts/mylan-ir/add/add_complete_new.php3 on line 45.

That line is where the first if statement is. Seems logical, but i'm missing something????

Thanks again

Anon

Oops, I forgot to take the 'then' out. Last question. In the example you provided it puts "NULL" in the field. When doing the following:

("SELECT email FROM members WHERE email IS NOT NULL")

It still even picks and lists the fields that say NULL.

I know this shouldn't be that difficult but, I have no idea.

Anon

Sorry, my bad I should have been more specific.

// Current Statement
$sql = "INSERT INTO members (first_name,last_name,address,company,faxlist,city,state,
zip,k,q,conference,calendar,christmas,pocketcal,email,phone,fax) VALUES
('$first_name','$last_name','$address','$company','$faxlist','$city','$state',
'$zip','$k','$q','$conference','$calendar','$christmas','$pocketcal','$email',
'$phone','$fax')";

// New Statement
$sql = "INSERT INTO members (first_name, last_name, address, company, faxlist, city, state, zip, k, q, conference, calendar, christmas, pocketcal, email, phone, fax) VALUES (";

if ($first_name == "") {
$sql .= "NULL";
}
else {
$sql .= "'$first_name'";
}

$sql .=")";

Again this should be written in a much better form, I'd suggest that you use the global variable for the posted form variables and then loop through them performing the above if..else on each of them.