Adding column in table code not working

I want to add a column in my salespayment table

public function getSalesPaymentByID($id) 
    {

        $q = $this->db->get_where('sales_payments', array('id' => $id), 1); 
          if( $q->num_rows() > 0 )
          {
            return $q->row();
          } 

          return FALSE;

    }

what query should i place??


Source: mysql

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.