CI2 - Why am I getting this database error: Not unique table/alias

CI2 - Why am I getting this database error: Not unique table/alias - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: CI2 - Why am I getting this database error: Not unique table/alias (/showthread.php?tid=32343)

CI2 - Why am I getting this database error: Not unique table/alias - El Forum - 07-20-2010

[eluser]dallen33[/eluser]
PHP

Code:
&lt;?php

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

    foreach ($query->result() as $row):

        echo $row->name;

    endforeach;

?&gt;

Result

Code:
A Database Error Occurred

Error Number: 1066

Not unique table/alias: 'heritage'

SELECT * FROM (`heritage`, `heritage`)

CI2 - Why am I getting this database error: Not unique table/alias - El Forum - 07-20-2010

[eluser]KingSkippus[/eluser]
We need more context. What are you doing with $this->db above the lines you quoted above?

CI2 - Why am I getting this database error: Not unique table/alias - El Forum - 07-20-2010

[eluser]pickupman[/eluser]
This could be caused by a table and field having the same name. What are your columns in the 'heritage' table. Or do you have a stored procedure by the same name?