The Big Picture

[MattBCool]

Hello,

Im completely new to databases. Can someone give me just the big picture? Im pretty sure OsCommerce manages my database by helping me catalog products. And from the looks of it, Oscomm also seems to a tool to make a web site. SO bascially for any specifics I can research information, but right now, I just need to know how general information about how each part communicated with the other.

-Matt

[bill110]

PHP and mysql work together. the two configure.php files tell the php script where the database is. functions (both standard php and defined by code) make calls to the database to get or post data.

example

  if ($category_depth == 'nested') {
$category_query = tep_db_query("select cd.categories_name,cd.categories_description,cd.categories_heading_title, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and cd.categories_id = '" . (int)$current_category_id . "' and cd.language_id = '" . (int)$languages_id . "'");
$category_query = tep_db_fetch_array($category_query);

The query ( $category_query) = tep_db_query(a pre-defined function with parameters)( this part is an sql query that gets data for $category_query)

The string($category)= the array obtained from the database query.

[MattBCool]

Ahhh, ok. Thanks man.