Welcome Guest, Not a member yet? Register   Sign In
Database Error: Show Line Number
#4

[eluser]John_Betong[/eluser]
[quote author="wilso417" date="1285359007"]Here is my code:

$this->db->select('junk');
$this->db->from('news');
$this->db->where('id', $content_id);

Here is my database error that gets outputted on screen:


A Database Error Occurred

Error Number: 1054

Unknown column 'junk' in 'field list'

SELECT `junk` FROM (`news`) WHERE `id` = '160'

I would like that error to have the following as well:

content_m.php line 360

I have a lot of queries in one page load and it's not easier for me to track down which one is causing an error.[/quote]
 
I do not understand why you should search for the 'junk' field if it does not exist?
 
I think it is a case of GIGO (Garbage In, Garbage Out). Clean up your input and you should have less errors.
 
 


Messages In This Thread
Database Error: Show Line Number - by El Forum - 09-23-2010, 05:36 PM
Database Error: Show Line Number - by El Forum - 09-24-2010, 06:16 AM
Database Error: Show Line Number - by El Forum - 09-24-2010, 09:10 AM
Database Error: Show Line Number - by El Forum - 09-26-2010, 09:21 PM
Database Error: Show Line Number - by El Forum - 09-27-2010, 06:25 AM
Database Error: Show Line Number - by El Forum - 09-27-2010, 08:48 AM
Database Error: Show Line Number - by El Forum - 09-27-2010, 09:56 AM
Database Error: Show Line Number - by El Forum - 09-27-2010, 10:04 AM
Database Error: Show Line Number - by El Forum - 09-27-2010, 11:00 AM
Database Error: Show Line Number - by El Forum - 09-27-2010, 11:07 AM
Database Error: Show Line Number - by El Forum - 11-23-2010, 10:14 AM
Database Error: Show Line Number - by El Forum - 11-23-2010, 10:44 AM
Database Error: Show Line Number - by El Forum - 12-06-2012, 11:33 AM
Database Error: Show Line Number - by El Forum - 12-11-2012, 05:53 AM



Theme © iAndrew 2016 - Forum software by © MyBB