Echoing results from a database

[eluser]TheFuzzy0ne[/eluser]
[quote author="mdcode" date="1236833345"]I appreciate any and all input...

Now, if I'm understanding you, and Fuzzy, correctly then I think that I am using the database correctly, since the things stored in these particular tables are rarely changing. The intro text, while only used on the front page for instance, is a 'large' block of text pulled from a TEXT type field in the database.

While the other items are quite small, such as the adminEmail and siteTitle, and could be held in a special config file, it seems superfluous to then hold the intro text in the database since it would then be the only item in there.

Thinking aloud, I guess then though, I could just make that static text on the home page just like the "Welcome to the" is right now, and drop two tables out of the db.[/quote]

My suggestion would be something like this:

In ./system/application/config/config.php:

Code:

$config['admin_email'] = '[email protected]';
$config['site_title'] = 'My Site';

The config file is automatically loaded by CodeIgniter, so you can grab the values using $this->config->item('site_title') and so on. You're free to change the data as you see fit, and it's probably easier than editing a database, as you just need to open a file and edit it.

Basically, the information will be there for you readily on each request - no need to mess about with databases. Consider a database table to be a bit like a big-ass CD rack. You wouldn't buy a CD rack capable of holding 200 CDs to hold only one CD, would you? ...Or would you?? The other reason for my suggestion is that you seem to be querying the database once for each setting, which is not very efficient.