Thanks for that suggestion and I had been thinking about that - although I have had probs with rss readers in the past, although I will look again at it.
I really want to be able to read the external database though.
I have put just this in a snippet (to try another way of doing it) but again it throws an error.
// get data
$dbase="my db name";
$query="SELECT * FROM `wp_posts` WHERE post_status='publish' LIMIT 5";
$results = $etomite->dbExtQuery($host, $user, $pass, $dbase, $query);
I know my query statement is correct as I can run it on phpmyadmin and it works fine.
The only solution I can think of is to install wordpress on the same database as etomite, although when I then add a forum and a shop this will be a very messy way of doing it IMHO.
Thanks again though, I shall be reading the links you posted now.
PS with the above snippet I get this error now:
Etomite encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed »
SQL: SELECT * FROM `mydatabase`.etomite_site_snippets WHERE `mydatabase`.etomite_site_snippets.name='MenuBuilder';
Although I suspect this is a 'knock on' error by the snippet failiure. When I don't include the snippet on the page everything is fine again. (I have replaced database name with 'mydatabase' of course, but the name here was to my etomite database, not the wordpress one.)
Mysql error reporting on the page actually now has
Query 9 - 0.0009 s
SELECT * FROM `wp_posts` WHERE post_status='publish' LIMIT 5
I think this means that the query worked?
Oh I am confused. I ALWAYS get stuck with sql statements, they really are not my strong point. Any further help would be most welcome. Thank you.
Edited by PaulD, 29 June 2009 - 10:32 AM.