Welcome Guest, Not a member yet? Register   Sign In
[SOLVED]Newbie question: Create a Multi-Dimensional Array
#2

[eluser]smilie[/eluser]
It's late here, can't think properly.
But wanted to give you one advise regarding DB structure and naming convention.

Make every single field name in all of your tables and databases unique.
What I see now is that you have:

Table cms_section, field name;
Table cms_article, field name;

So, when you do SQL queries, you must specify table name and field name.

In this case:

Table cms_section, field section_name;
Table cms_article, field article_name;

MySQL recognizes that both field names are unique and does not require you to specify table, so:

$this->db->select('article_name,section_name');

will be sufficiant for MySQL to perform query :-)

Good luck!

Cheers,
Smilie


Messages In This Thread
[SOLVED]Newbie question: Create a Multi-Dimensional Array - by El Forum - 11-10-2010, 10:15 AM



Theme © iAndrew 2016 - Forum software by © MyBB