Technology related solutions, tips, tricks, and other interesting topics
In: Web Development
3 May 2008You can perform a SQL query against more than one database with PHP. Here is a sample generic SQL query against two databases:
SELECT image.image_title, greetings.date FROM db1.image, db2.greetings WHERE greetings.image_id=image.imageid
And here is some PHP sample code on how you would query two databases in a single SQL statement:
$query="INSERT INTO db1.table1 SELECT * FROM db2.table2 WHERE a=1"; mysql_query($query,$connection);

This blog is about technology related topics. It will primarily contain problems and solutions to IT problems that I encounter on a day-to-day basis. In addition interesting things I come across either on or off the internet will be posted here as well. I will also include step-by-step tutorials to common tasks people may need to do with their computers.