How to show a fied FK - belongs_to


#1

Hi,

i have two tables

CREATE TABLE categories (
id int(11) NOT NULL auto_increment,
name varchar(50) DEFAULT NULL,
PRIMARY KEY (id)
);

CREATE TABLE forums (
id int(11) NOT NULL auto_increment,
category_id int(11) DEFAULT NULL,
name varchar(50) DEFAULT NULL,
description varchar(100) DEFAULT NULL,
PRIMARY KEY (id)
);

I wanna show the name field of the forums table, buy in the line of the
all fields of the table categories like:
id category name description
1 programming C++ tutorials of C++
2 religion chrismas card hi all

how to code this??