I have a problem here.

I have 3 databases that sit ont he same server, I can access the databases seperatly find but what I need to do is access all 3 at the same time. All 3 databases have the same schema. Is it possible to do this? Here is my setup:

My 3 databases: wcmporg_db , alife_db and puritan_db

Here was my thought process on this but it doesnt work

PHP Code:

"SELECT * FROM puritan_db.main,wcmporg_db.main,alife_db.main  ORDER by main.burial_date desc  limit $offset,$limit" 


Any help would be appreciated

Wtf. Did you try to read mysql manual on joins? Also read about aliases. In your request you will have 3 tables with same names which is not allowed. You should say something like this:

select * 
from db1.main as m1
join db2.main as m2 on m1.id = m2.id
join db3.main as m3 on m1.id = m3.id
order by m1.field

You should clearly define how to join your tables. If you don't do that you will receive a table with number of columns = sum of number of columns in each table and with number of rows = number of rows in table1 * number of rows in table 2 * number of rows in table 3 which will most surely eat out all spare memory, go deeply into swap and put your server down.

What you're looking for is union here is how you do it :

 (SELECT field1, field2, field3 FROM db1.table1)
 UNION
 (SELECT field1, field2, field3 FROM db2.table1)
 UNION
 (SELECT field1, field2, field3 FROM db3.table1)
 order by field1 limit $offset, $limit;

further reading