[PHP-DB] explode / implode function call on a field with blob type

2005-08-04 Thread Shahmat Dahlan
I have the following table structure called announcements - id int(6) - data longblob And this is what i did: $sql_stmt = "SELECT id, data FROM announcements"; $query = mysql_query ($sql_stmt); while ($row = mysql_fetch_object ($query)) { echo $row->id; $tmp = explode (" ", $row->data, 10);

Re: [PHP-DB] explode / implode function call on a field with blob type

2005-08-04 Thread Shahmat Dahlan
Correction, my corrected code (mistake in the last line, echo $row->data): $sql_stmt = "SELECT id, data FROM announcements"; $query = mysql_query ($sql_stmt); while ($row = mysql_fetch_object ($query)) { echo $row->id; $tmp = explode (" ", $row->data, 10); #1 $data_stripped = implode (" ",

[PHP-DB] Does Berkeley DB 4.3.28 work fine PHP 4 ?

2005-08-04 Thread Leena Dasnurkar
Hello! This is leena from pune. I want to use berkeley db with PHP 4. I have installed php extension of berkeley DB on my linux machine. (berkeley db version - 4.3.28 ) I have gone through php extension classes. [http://www.sleepycat.com/docs/ref/ext/php.html] However I m not able to crea

Re: [PHP-DB] explode / implode function call on a field with blob type

2005-08-04 Thread Shahmat Dahlan
My apologies, I got it all wrong, I simply went and used the split function and join those strings together, and it works. Shahmat Dahlan wrote: Correction, my corrected code (mistake in the last line, echo $row->data): $sql_stmt = "SELECT id, data FROM announcements"; $query = mysql_query (