Accessing MS Access memo field through php

[pushVTEC]

I'm using a simple access db to store some info and any text fields I can access and print out data fine. However when I try to write out the memo field it shows up as a blank in the webpage, here's the code I used:

$result = $conn->Execute($query);
if(strcasecmp($result->Fields['slogan']->Value, '') != 0){
echo "<br/>\n";
echo $result->Fields['slogan']->Value."\n";
}

I know there is data in the that memo field and it is indeed called slogan, any ideas? I don't get any error messages, just a blank.

 

[Zugzwang152]

what is $conn and what is $query?

 

[pushVTEC]

$conn = new COM('ADODB.Connection') or exit('Cannot start ADO.');

$conn->open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$db");

$query = "select name, phone, phone2, contact, website, email, fax, rating, address, city, state, number, zipcode, slogan FROM detailer WHERE country='$ct' AND stateabr='$st'" ;