Infusion Technology Solutions Blog
Technology related solutions, tips, tricks, and other interesting topics
Posts Tagged ‘mysql query’
How to Query Multiple Databases in PHP
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 * [...]
- No Comments
- Tags: databases, mysql query, php, sql query, sql statement
About this blog
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.
Web Hosting Discount
-
Get the first month for only $0.01 using coupon code HGCOUPONBLOG. No contracts, cancel anytime.
Categories
- Apple (31)
- Electronics (10)
- Games (1)
- General IT Info (47)
- Information Security (12)
- Microsoft (11)
- Ramblings (3)
- The Net (5)
- Tutorials (3)
- Web Development (12)
- Alshe Dupur: Thanks for the great tips. I need this badly... :) [...]
- hosni: thank you , thank you , thank you [...]
- Rico: Any suggestions for when the slotid mkpassdb fix does not do the trick? [...]
- Neil: I think it is worth noting "udo sso_util configure -r YOUR.REALM.COM -a diradmin -p " The YOURREA [...]
- pearlbluesoul: I was looking for that article for a friend, but in reading it seems that the update for 10.6.7 serv [...]
- How To Allow MacOS X 10.4, 10.5, and 10.6 Client Computers To Update Against a MacOS X 10.6 Sofware Update Server Using a Single Common URL
- How to Reset the Password for an OS X Open Directory Mobile Account
- Terminal Command for Xserve Intel Hardware RAID Card
- How to Fix a Corrupted OS X Open Directory Account Password
- How to Configure Splunk to use a Web Proxy Server
- How to Get Trixbox Working Behind a NAT Firewall
- How to Backup and Restore a MySQL Database Using mysqldump
- How to Reset the Admin Password in ColdFusion MX 6
- How to Enable ReadyBoost for an ExpressCard SSD in Vista
- Sendmail Hangs When Starting Up or When Using It with PHP
Revolutionary One Time Password Device
