[RESOLVED] INSERT QUERY - EXCLUDE EMPTY FIELDS

fontener

$result = mysql_query("INSERT INTO pd (pd_fn, pd_sn, pd_p, pd_pe, pd_e, s_l) VALUES ('$pdfirstname', '$pdsurname', '$pdphone', '$pdphoneext', '$pdemail', '$callabcs')") or die(mysql_error());

$pdfirstname and $pdsurname are the only field items that are required.

How do I write the insert query to exclude empty fields??

Thanks!!

dagon

if the variable is empty then the db will insert the default (blank, unless you specified otherwise)

fontener

for example.. the pd_p where the $pdphone would be inserted into has a default of NULL but if the field is empty it inserts a 0 .. so I figured the only logical thing was to omit it from the insert statement if it is empty...

dagon

odd, if the db field default is null and you insert a blank then it should be null not 0, sure its set to null? it would be 0 if its an int and not null

fontener

Field:pd_p  	Type:bigint(10)  	Collation: 	 Attributes: 	NULL:Yes  	Default:NULL   Extra:

dagon

well im wrong, just ran a test, you will have to write the query to exclude the blanks

fontener

No biggie.. just looking for some help/direction on how to code that.. the insert statement really... i can handle the if statements..

dagon

$fields = array('pd_fn' => $pdfirstname,'pd_sn' => $pdsurname,'pd_p' => $pdphone,'pd_pe' => $pdphoneext,'pd_e' => $pdemail,'s_l' => $callabcs);

foreach($fields as $key => $var){
	if(!empty($var)){
		$f .= $key.',';
		$v .= "'".$var."',";
	}
}
	$q="INSERT INTO pd (".rtrim($f,',').") VALUES(".rtrim($v,',').")";
	//echo $q;
	$result = mysql_query($q);

ps. the foreach loop would be a good place to sanitise the input data, if you have not done so already.

fontener

Gracias senor!! You are a lifesaver... and far too quick at this sorta thing!! 😃