WordPress database on non wordpress page

You’d probably just do it the ‘normal’ way you’d pull in an external database. Use PHP to call SQL.

But it was the sql query I was struggling with. I ended up changing it so much I got totally confused.

Without knowing the particulars of the non WordPress database you’re trying to get info from, we really can’t tell you much.

https://www.webcheatsheet.com/PHP/connect_mssql_database.php

FYI i found the answer on a post half way down the page here.

Simple really. I was over complicating things

<?php
	$query = "SELECT post_title, post_name FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' ORDER BY post_date DESC LIMIT 5";
	$result = mysql_query($query,$dblink);
	if(mysql_num_rows($result)) {?>
		<ul>
		<?php while($post = mysql_fetch_assoc($result)) {?>
			<li><a href="/blog/<?php echo $post['post_name'] ?>"><?php echo stripslashes($post['post_title']); ?></a></li>
		<?php }?>
		</ul>
	<?php }
?>

You were trying to get data from one WP database on a second WP install? Ah, that was unclear ??

Also? That’s not MultiSite. MultiSite is using ONE WordPress install like Sauron to run them all.

exterminate, you mean, you want to show WP content outside of your WP blog? If so, read this:

https://www.corvidworks.com/articles/wordpress-content-on-other-pages