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??