Error:: Building a Blog in Dreamweaver with PHP and

I'be been floowing the direction for build a blog from the developer section
and it mentionscreating a foriegn key for idtop_art But I don't see how to
create this part of the database. Does anyone know how to create a foriegn key
between two databases? Thanks

MySQL is not a purely-relational database language. This means the idtop_art
field will not really be linked in any way to the id_top field, except as a
concept. Conceptually, a foreign key is a reference to a field in another
table, which logically links records from the two tables. Basically, the
idtop_art stores the unique ID of the topic associated to the current article,
so you would know which article belongs to which topic.

In the actual tutorial, you don't have to do anything to create the foreign
key. Just execute the sample code in the MySQL console:

CREATE TABLE blg_article_art (
id_art int(11) NOT NULL auto_increment,
idtop_art int(11) NOT NULL default '0',
title_art varchar(100) NOT NULL default '',
description_art varchar(255) NOT NULL default '',
text_art longtext NOT NULL,
date_art datetime default NULL,
PRIMARY KEY (id_art));

Good luck!

.oO(Marius2004)

MySQL is not a purely-relational database language. This means the idtop_art
field will not really be linked in any way to the id_top field, except as a
concept.

In its default configuration with MyISAM tables MySQL ignores them, but
if you use InnoDB for example you can use foreign key constraints.

Micha