How to produce error msg on ambiguous column names?

This is possible. The reason that CI doesn't throw up SQL errors about ambiguous column names is because it appends the name of the table when selecting so for example SELECT `table`. `name`, `table2`.

`name` FROM `table`, `table2` The reason you then don't get to see these columns is because the array key generated by mysqli_fetch_assoc() or whichever driver you're using is name for both and obviously gets overwritten. The following answer is suitable for those using CI2. X Extend the Database driver result class in a similar fashion used in my answer to CodeIgniter: SQL Audit of all $this->db->query() method calls?

Once you've extended the database driver result class you have two options. You can throw an error as you requested as follows: Result - associative array * * Returns the result set as an array * * @access private * @return array */ function _fetch_assoc() { if (!($row = mysql_fetch_array($this->result_id))) { return null; } $return = array(); $row_count = mysql_num_fields($this->result_id); for($i = 0; $i result_id, $i); if( array_key_exists( $field, $return ) ) { log_message('Error message about ambiguous columns here'); } else { $return$field = $row$i; } } return $return; //Standard CI implementation //return mysql_fetch_assoc($this->result_id); } Or alternatively you can further manipulate the output of the function to simulate the query behavior by prepending tablename to the column name resulting in an array like SELECT * FROM `users` LEFT JOIN `companies` ON `users`. `id` = `companies`.

`id` Array ( users_id => 1 users_name => User1 companies_id => 1 companies_name => basdasd companies_share_price => 10.00 ) To achieve this you can simply modify the for loop in the above function to the following: for($i = 0; $i result_id, $i); $field = mysql_field_name($this->result_id, $i); $return"$table_$field" = $row$i; }.

This is possible. The reason that CI doesn't throw up SQL errors about ambiguous column names is because it appends the name of the table when selecting so for example SELECT `table`. `name`, `table2`.

`name` FROM `table`, `table2` ... The reason you then don't get to see these columns is because the array key generated by mysqli_fetch_assoc() or whichever driver you're using is name for both and obviously gets overwritten. The following answer is suitable for those using CI2.x. Extend the Database driver result class in a similar fashion used in my answer to CodeIgniter: SQL Audit of all $this->db->query() method calls?.

Once you've extended the database driver result class you have two options. You can throw an error as you requested as follows: /** * Result - associative array * * Returns the result set as an array * * @access private * @return array */ function _fetch_assoc() { if (!($row = mysql_fetch_array($this->result_id))) { return null; } $return = array(); $row_count = mysql_num_fields($this->result_id); for($i = 0; $i result_id, $i); if( array_key_exists( $field, $return ) ) { log_message('Error message about ambiguous columns here'); } else { $return$field = $row$i; } } return $return; //Standard CI implementation //return mysql_fetch_assoc($this->result_id); } Or alternatively you can further manipulate the output of the function to simulate the query behavior by prepending tablename_ to the column name resulting in an array like SELECT * FROM `users` LEFT JOIN `companies` ON `users`. `id` = `companies`.

`id` Array ( users_id => 1 users_name => User1 companies_id => 1 companies_name => basdasd companies_share_price => 10.00 ) To achieve this you can simply modify the for loop in the above function to the following: for($i = 0; $i result_id, $i); $field = mysql_field_name($this->result_id, $i); $return"$table_$field" = $row$i; }.

Nice response, thank you for the effort explaining all of that! – jjwdesign Nov 10 at 1:35 Just read your comment and spotted a bug in my code. $result should be $this->result_id.

Will fix when at a computer. No problem though, you're welcome – Ben Swinburne Nov 10 at 7:41 Fixed, all $result variables have been replaced with $this->result_id – Ben Swinburne Nov 10 at 10:07.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.