Wordpress WPQuery

As far as I can tell, using WPQuery in Wordpress is a big pain in the ass and sometimes it doesn't seem to work like you think it should. After reading the documentation, watching demo videos, and experimenting with the code, here's my best guess as to how to use it:

Getting PEAR to work with MAMP 2

Trying to get PEAR to run with MAMP 2 will result in the following error by default:

Notice: unserialize(): Error at offset 276 of 1133 bytes in Config.php on line 1050
ERROR: The default config file is not a valid config file or is corrupted.

To Fix, open up /Applications/MAMP/bin/php/php5.3.6/conf/pear.conf, search for:


Replace with:


Accessing MSSQL in VMWare Fusion from Mac host

Disclaimer: I wrote this in haste because it's Saturday but I wanted to at least document things a little, so my grammar is horrible and I left out a bunch of stuff. Well, this should help quite a bit anyway :)

I had to get data out of a MSSQL database and into a MYSQL database. I had VMWare fusion with Windows 7 already set up.

In Windows:

Then I downloaded and installed MS SQL Server Express With Tools