work with 2 databases

[mohamad_1978]

hi there
i have 2 databases

database1 and database2

and in database1 there is table called (books) and in database2 there is table called (megazins) and in each of these tables there is field called (date) for the publish date
i want to get all the data from both databases and sort them by the (date)

i wish im clear
how can i do it

[eoghain]

Unless you are using an RDBMS that allows you to run queries across databases then you are stuck running 1 query on each database to get your data and doing all of the heavy work yourself in PHP.

This isn't that tough since you can just put all of the data from each query into an array and do a [man]usort/man on it. Ofcourse you'll have to build the sorting function but that's not that big a deal.