Topic awaiting preservation: Select fields from diferents tables (Page 1 of 1)

Hola!
I got a forum, i have a table for initial messages and another for the reply. I have the same fields in both tables:
table posts
Imagenes

im not sure but try this:

$query_showPosts = "
SELECT imagenes.posts,user_name.posts,mensaje.posts,imagenes.reply,user_name.reply,mensaje.reply
FROM posts,reply ";

no. stupid me! it has to be the other way round:


$query_showPosts = "
SELECT posts.imagenes,posts.user_name,posts.mensaje,reply.imagenes,reply.user_name,reply.mensaje
FROM posts,reply ";

Using a join like Grumble suggests will probably not give you what you want as it will combine rows in every possible way giving you m * n rows where m, n are the number of rows in table1, table2.

Just a suggestion, but it might make more sense to have one table and just have an integer field that contains the id number of the post that it is a reply to. If it is not a reply just set the field to 0. That way you can use a simple query to get all the posts or all the replies to specific post.

-jiblet

[This message has been edited by jiblet (edited 06-03-2002).]

Jiblet, it's a special thing, and the field in each table are totally different.....

A sig should be here.....
But is not.