[freaky]

Hello all,

I have one problem to which i couldn't find the solution.
I have two MySQL tables...

lets say:

---------
table1
--------
id
name
text

--------
table2
--------
id
name
subtitle
text

Now they don't have same number of columns so I can't do Union.
Tables are not related (one is news, other is articles)
What I need to do?

User inputs search parameter for example: "test" (exclude ")
Then I need to search Table1.name, Table1.text AND Table2.name, Table2.subtitle, Table2.text
And output the results together.....

Do you have any sudgestions?
Thank you very much in advance!

[PennyBoki]

Hi
Lets clear things up a bit. So you have the user to search the word test in two different, not connected tables? Right?
If yes, then you could use a variable(I guess you are using PHP) and with SELECT you'll assign the results from the first table. Then you can use another SELECT and concatenate the results to the same variable. Then use the variable as you wish in order to show the results.

[freaky]

PennyBoki, on 12 August 2010 - 07:46 AM, said:

Hi
Lets clear things up a bit. So you have the user to search the word test in two different, not connected tables? Right?
If yes, then you could use a variable(I guess you are using PHP) and with SELECT you'll assign the results from the first table. Then you can use another SELECT and concatenate the results to the same variable. Then use the variable as you wish in order to show the results.

Yes you are correct, but let's say I want to see the resulty in phpMyAdmin. Is there a way to do this by union?join?something?

Thank you!

[Somyagupta]

Yes use join to combine the two table into one

[PennyBoki]

Or you could CREATE VIEW so that you could select what you needed from the tables, without using extra memory. But still you need to join them somehow, maybe by id as in the following example:

LINK

[freaky]

thank you I understand everything =)