php/sql access of wikimedia

[Rukie]

I'm building a site but there has to be an easy way of writing to the file. I need something with a simple easy end user interface. It was suggested to me to use wikimedia. Anyways, I have it set up but I cannot seem to figure out how to setup the sql query and fetch. I just need to access the text.

http://meta.wikimedia.org/wiki/Page_table This is what I was workign off of, however I do have a wiki_ prefix on my tables in the database CCHS.
I can connect fine and retrieve information.. I just can't seem to figure out how to retrieve the RIGHT information.

I'm also using a variable, $homebody to choose what to select, what to look for.

I'm on apache2 linux with php5 and sql, a little home server thing I'm working on atm that will hopefully be uploaded onto another server.

Any ideas/help would be greatly appreciated. Thankyou 🙂

[Rukie]

select old_text from wiki_page, wiki_revision, wiki_text where page_title = 'Mrs._Harford' and page_latest = rev_id and rev_text_id = old_id;
works fine in the mysql prompt..

I need a $homebody where Harford is, but neither one works in the php... heh

[Rukie]

now I am able to get Resource Id #3, but nothing else with

if (! $thiscontent = mysql_query('SELECT old_text from wiki_page, wiki_revision, wiki_text where page_title = "Mrs._Harford" and page_latest = rev_id and rev_text_id = old_id'))
{
die("Cannot execute the query: ".mysqlerror());
}
else
{echo $thiscontent;}