Re: help need with relations

[Maciej Glinkowski]

how to put this primary key? i've got for example structure:

CREATE TABLE TBook (
IDbook smallint(5) unsigned NOT NULL auto_increment,
IDauthor smallint(5) NOT NULL default '0',
title varchar(50) NOT NULL default '',
PRIMARY KEY (IDbook)
) TYPE=MyISAM;

CREATE TABLE TAuthor (
IDauthor smallint(5) unsigned NOT NULL auto_increment,
name varchar(50) NOT NULL default '',
PRIMARY KEY (IDauthor)
) TYPE=MyISAM;

and i want that field TBook.IDauthor = TAuthor.IDauthor and to show me in this field TAuthor.name in browser instead of number... in phpmyadmin i've got here number with link the text