[eluser]gabe[/eluser]
Hi
I have a table with a column called datacash_ref, it can be null. Only after someone successfully pays does a reference number get entered.
About half the entries are NULL and the other half have references. I am trying to select only those that are empty (null).
These don't work:
Code:
$this->db->get_where( 'ci_bookings', array( 'datacash_ref' => '' ) );
Code:
$this->db->get_where( 'ci_bookings', array( 'datacash_ref' => 'NULL' ) );
Code:
$this->db->get_where( 'ci_bookings', array( 'datacash_ref' => FALSE ) );
What's the correct way to approach this, please?
Kind regards