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 * [...]
In: Web Development
29 Apr 2008Sometimes it is useful in the Apache configuration httpd.conf file to only apply configuration settings if a particular module has already been loaded. Or it is useful to load settings in the event an Apache module has not been loaded. Here is how to handle both cases: <IfModule module_identifier> # do these Apache settings if [...]
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.