Update: Here are some of the things I have tried:
I've tried this straight from the Integrating WordPress page:
<?php
define('WP_USE_THEMES', true);
require('../wp-blog-header.php');
?>
Results in:
Absolutely nothing. Completely blank page. Html is empty.
I've tried requiring the header.php in my theme directory:
<?php
define('WP_USE_THEMES', true);
require('Path-To-Theme-Header');
?>
Results in:
Warning: require() [function.require]: Unable to access Path-To-Theme-Header
Warning: require(Path-To-Theme-Header) [function.require]: failed to open stream: No such file or directory
I've tried the plain old php include:
<?php include('Path-To-Theme-Header'); ?>
Results in:
Warning: include() [function.include]: URL file-access is disabled in the server configuration
Warning: include(Path-To-Theme-Header) [function.include]: failed to open stream: no suitable wrapper could be found
Warning: include() [function.include]: Failed opening 'Path-To-Theme-Header' for inclusion (include_path='.:/usr/share/pear')
I've tried this code I found somewhere along the way...
<?php
define('WP_USE_THEMES', false);
require('../wp-load.php');
query_posts('showposts=1');
?>
<?php while (have_posts()): the_post(); ?>
<?php endwhile; ?>
<?php while (have_posts()): the_post(); ?>
<h2><?php the_title(); ?></h2>
<?php the_excerpt(); ?>
<p><a href="<?php the_permalink(); ?>">Read more...</a></p>
<?php endwhile; ?>
Results in:
Showing the default post of my blog twice. Not the post from my cms website, which it should be able to grab.
I've tried using the code in the example from this tutorial
Which results in:
Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
In case anyone was wondering and couldn't tell from the above, my website has the wordpress cms at the base url, and the blog at mysite.com/blog.
I feel like I'm just hitting my head against the wall here. Can anyone offer some useful suggestions? Would integrating both wordpresses into one sql database make a difference perhaps? Since the one attempt that did result in a page, just seemed to be accessing the wrong database.