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