Is it possible to....?

[plasmahba]

Hi!

Is it possible to make a search engine that combines data from two different tables?

In that case, could you tell me one direction to follow?

Thank you very much

[rgermain]

Yes it is possible and can be done. In fact I have done it before. I do not have my code handy, but I believe you can use join to do this...Anyone, correct me if I am wrong.

I would look into: http://www.mysql.com/

[Napster]

you would go something like

mysql_query("SELECT * FROM table1, table2 WHERE table1.row=table2.row");

Something like that

[rgermain]

Napster,
Thats a lot more correct then what I had! 🙂 Hard to remember it all! Thanx for the help on this one.

[plasmahba]

For more information here´s the link

http://dev.mysql.com/doc/mysql/en/Multiple_tables.html

Thanxs both !