6 replies to this topic

[madness69]

Could someone tell me what is the query for what im trying to do, for example:
i have 2 tables, one is "comments" table and the other is "articles" tables.
In the comments table there is a 3 columns (id, title, message) and in the articles table there is 3 columns too(id, title,info)
I would like is to get all the data of the column message from the table "comments" but the table "comments" got to have the same title of the column title of the column title of Articles table.
I dont no if im beign confusing, im sorry.

[Barand]

Not much point in storing a title in the comments table then.

How do you know which comments belong to which article?

[madness69]

The title given is a unique name and are the same name in the coment and article

Edited by madness69, 08 December 2012 - 05:58 PM.

[kicken]

You should be linking the comments with the article by the article's ID number, not the title.  It's quicker to compare a couple of INTs than it is to compare strings.  It would also use a lot less space on the system to store those INTs than to store a copy of the title.  You also won't have any issues if the article title ever gets changed.

[madness69]

yes i know, and how would be the query for it?

Here is the tables:

table comments:
- id;
- name;
- email;
- message;
-id_article;


table articles:
-id;
- title;
- contents;

Edited by madness69, 08 December 2012 - 07:13 PM.

[kicken]

Just do a JOIN between the two tables using the title columns as the join's condition.

[Barand]

I would like is to get all the data of the column message from the table "comments" but the table "comments" got to have the same title of the column title of the column title of Articles table.

According to to OP all that is required is message column from comments table. I am totally confused about requirements here. It's later been established that title columns are the same so why mention that constraint.