Welcome Guest, Not a member yet? Register   Sign In
Database error, but no error number or message
#1

[eluser]digity[/eluser]
I'm getting an empty result return on the model code below and a page title that just says "Database error"... no actual mysql error number or message is given anywhere:

Code:
$this->db->select('topics.topic_id');
$this->db->select('COUNT(*) AS comment_count');
$this->db->from('topics');
$this->db->from('comments');
$this->db->where('topics.topic_id','comments.topic_id');
$this->db->where('comments.comment_created >= NOW() - INTERVAL '.$options['time_number'].' '.$options['time_unit']);
$this->db->group_by('topics.topic_id');
$this->db->order_by('comment_count', 'DESC');

Any ideas?


P.S. - Yes, the query works and it runs fine the long way with $this->db->query() (but I need the above structure to work).


Messages In This Thread
Database error, but no error number or message - by El Forum - 10-04-2011, 01:32 AM



Theme © iAndrew 2016 - Forum software by © MyBB