Database Error: Show Line Number

[eluser]John_Betong[/eluser]
Try this:

Code:

function sql_error($method, $line, $sql)
{
  echo '<br />', 'method() ', $method;
  echo '<br />', 'line : ',   $line;
  echo '<br />', 'SQL: ',     $sql;
  
  // or if you have your config error logging setup
  log_message('ERROR', 'SQL error:' .$method  .': ' .$line  .$sql);

  die;
}


// Your Query
// TRYING TO PRODUCE AN ERROR
  $this->db->select('junk');
  $this->db->from(‘news’);
  $this->db->where(‘id’, $content_id);  

  $query = $this->db->get();

  if($query == NULL OR empty($query))
  {
    $this->sql_error(__METHOD__, __LINE__, $this->db->last_query());
  }

  // no error so do your stuff