Pulling data from two different tables

[innerc]

I'm also needing one other thing... dealing with MySQL and PHP.

I have two tables. One for PROJECTS1 and one for PROJECTS2.
Both tables have an identical table structure... minus 2 cols. I want to keep these two table separated for several reasons.
But both have a TITLE, DATE, and PAID column.

How can I pull the info from BOTH tables... and have it sort them TOGETHER by date.

So instead of having it output:

PROJ1-01
PROJ1-02
PROJ1-03

PROJ2-01
PROJ2-02
PROJ2-03

It would look like this:

PROJ1-01
PROJ2-01
PROJ1-02
PROJ2-02
PROJ1-03
PROJ1-03

..............Depending on date......

Thanks.

[Weedpacket]

I don't know if MySQL's UNION operator allows you to query two separate tables, and can't tell because I don't use MySQL.

If you can't, then you can do it in PHP by running both queries separately, fetching all the rows of both result sets and storing them in the same array, then using [man]usort[/man] (say) to sort that array.

[GeertVc]

If I understand it correct, then you have a database with two tables, right?

If so, why not using the join possibility of MySql (or more in general: databases) to get information out of the two tables, such as:

select PROJECTS1.DATE, PROJECTS1.TITLE, PROJECTS1.PAID, PROJECTS2.DATE, PROJECTS2.TITLE PROJECTS3.PAID
from PROJECTS1, PROJECTS2
where <use your filter here>;

Don't know exactly what you want, that's why the where clause is not filled in by me.

Be aware that the where clause on its own again can be a complete sql statement.

HTH,

Geert

[Weedpacket]

Originally posted by GeertVc
If I understand it correct, then you have a database with two tables, right?

If so, why not using the join possibility of MySql (or more in general: databases) to get information out of the two tables, such as:

Problem with that is that if Table A has projects "FOO", "BAR", and "BAZ" and Table B has projects "WIBBLE", and "WOMBLE", the result will be six records:

1. details for both FOO and WIBBLE

2. details for both FOO and WOMBLE

3. details for both BAR and WIBBLE

4. details for both BAR and WOMBLE

5. details for both BAZ and WIBBLE

6. details for both BAZ and WOMBLE

[innerc]

both table columns that i need to pull are the same. the two tables have PROJECTDATE, PROJECTTITLE, PAID

(but keep in mind i want to keep the actual tables separated... I just want to combine the results and ORDER BY projectdate )

This way I can pull both table together order by the date of the projects.