I have a Firebird 2.0 Database with a BLOB field that contains the history of buildings.
How can I display the text(Building history) from the BLOB executing a query from PHP. Here is an extract of the sql query :
$congregationName = $address1 = $address2 = $autobiography = "";
doConnect($con);
// Execute query
$stmt = "SELECT DISTINCT C.CONGREGATIONNAME,
C.ADDRESS1,
C.ADDRESS2,
C.AUTOBIOGRAPHY
FROM MEMBERS M
JOIN CONGREGATIONS C ON M.CONGREGATIONNO = C.CONGREGATIONNO
JOIN DISTRICTAREA D ON D.DISTRICTAREANO = C.DistrictAreaNo
JOIN BISHOPAREA B ON B.BISHOPAREANO = C.BishopAreaNo
JOIN APOSTLEAREA A ON A.APOSTLEAREANO = C.APOSTLEAREANO
$areaCon
ORDER BY C.CONGREGATIONNAME";
$result = ibase_query($stmt);
This is the result :
Congregation Name |
Address1 |
Address2 |
Cronicle |
|
DURBANVILLE |
DE VILLIERS AVENUE |
DURBANVILLE |
0x00003a3a00000099 |
Please HELP
No one has replied yet! Why not be the first?
Sign in or Join us (it's free).