Hi i have a table with different fields and i make an insert query and i want to skip the insert query if a value is null in one of the fields. Example
Table
id name surname kids
1 john doe 2
2 mary jones 3
and i want if the new insert has no value in the field kids to skip that entry. is there a possible way to check that?` the code i have is this
INSERT INTO `clients`.`kids` (`id`, `name`,`surname`,`kids`) VALUES (NULL,'".$data['name']."','".$data['surname']."','".$data['kids']."');";`