How to code for Null or Empty column values in MySql

marthaj6289

How do I describe null or empty columns when setting up my definitions in server side scripts? For example, middlename may empty or null.

$columns = array(
array( 'db' => 'firstname', 'dt' => 0 ),
array( 'db' => 'middlename', 'dt' => 1 ),
array( 'db' => 'lastname', 'dt' => 2 ),
array( 'db' => 'email', 'dt' => 3 )
)
);