[SOLVED] differentiating union queries??? possible?

[dj-kenpo]

hey!

 

so I'm doing a union based fullt-text query on 3 different tables.

problem: I want to know what is what.

ie is result 1 from table 1,2, or 3?

 

here's my query, which works, but it's nonesense without being able to say what table the data came from (I can't build a url link to the result if it's unlcear what it is...)

 

$main_sql = "SELECT ID, Title, urlTitle, Timestamp, Entry, MATCH(Title, Entry) 
               AGAINST ('$searchstring' IN BOOLEAN MODE) AS score FROM journal 
               WHERE User_ID='$User_ID' AND MATCH(Title, Entry) 
               AGAINST ('$searchstring' IN BOOLEAN MODE)
                
                UNION 
                SELECT ID, NULL, NULL, Timestamp, Entry, MATCH(Entry) 
               AGAINST ('$searchstring' IN BOOLEAN MODE) AS score FROM cv_entries 
               WHERE User_ID='$User_ID' AND MATCH(Entry) 
               AGAINST ('$searchstring' IN BOOLEAN MODE)
               
               UNION 
                SELECT ID, NULL, NULL, Timestamp, Entry, MATCH(Entry) 
               AGAINST ('$searchstring' IN BOOLEAN MODE) AS score FROM news 
               WHERE User_ID='$User_ID' AND MATCH(Entry) 
               AGAINST ('$searchstring' IN BOOLEAN MODE) ORDER BY Timestamp DESC";

[Barand]

Add an identifier to each SELECT statement

 

$main_sql = "SELECT 'J', ID, Title, urlTitle, Timestamp, Entry, MATCH(Title, Entry)

              AGAINST ('$searchstring' IN BOOLEAN MODE) AS score FROM journal

              WHERE User_ID='$User_ID' AND MATCH(Title, Entry)

              AGAINST ('$searchstring' IN BOOLEAN MODE)

 

              UNION

 

              ....

               

[dj-kenpo]

wow... I had no idea identifiers existed... I seem to have spotty knowledge on mysql/php...

 

thanks barand. you rule as always