I used to know this, but haven't done it for more than a year.

1) How do you combine data from two tables?

2) Furthermore, is it possible to include an if statement, so that...

if(data is from table 1) font-color should be red
elseif(data is from table 2) font-color should be blue

what do you mean combine them? as in place them in one table or simply extract data from two tables and place them on one page? The latter would be simple.

Fambi, the two tables must have a relationship -- a key on each that is shared. For example, I have a table MOVIES with movieid, title and directorid; and the director field is an int. I have a directors table that has a directorid, name, birth day, favorite color, etc. The directorid field on the directors table holds a unique number for each row that uniquely identifies it -- that's the primary key. The directorid field in the MOVIES table is a reference to the directorid field on the directors table. That is called a foreign key.

Now that the relationship is there, I can create a query which joins the two sets of data together. Let's say I wanted to find out the name and favorite color of the director of a movie called "FRANK." So the movie title lives in one table (movies) and the favorite color and name live in the other (directors).

SELECT d.birthDay, d.Name FROM directors d INNER JOIN movies m ON d.directorid=m.directorid WHERE m.title = 'FRANK'

This is a called a "join."

yea kyrnt nailed that one

learn something new everyday, dámn, i should really read up on my SQL

Cool. Thanks.

Now is there anyway of identifying which data has come from which table?

If not, i'll put some reference in one table that isn't in the other, and then call an if statement to identify which info has come from which.

THanks again.

OK. I finally sat down to implement this and i think i may have misexplained what i am trying to do.

Basically, i am trying to compile all the messages received and all the messages sent into a single table. They share many same fields such as the message body & date and the primary between them is the username.

Any ideas?

Same u stilll use join if i'm rite

When i tried it, the best i could do was compile the corrseponding data from the two tables into 1 single row. What i would like to do is keep the data from the two tables in seperate rows.

In the end, i called the data from both tables seperately and stuck the results into a single array.

I then used array_multisort to sort them accordingly and achieved my goal.

Thanks for the help everyone.