[PHP-DB] MySQL fulltext indices and phrase search
Hi there, is there a possibility to use MySQL's MATCH ... AGAINST to look for a string like foo bar ? if i MATCH keyname AGAINST ('foo bar') i get resuts that match foo or bar, but not both of them separated by a space. My guess is that the organization of the index doesn't allow this kind of search as it's based on single words , but maybe one of you has a better idea than to select the rows that contain both and hit those with LIKE '%foo bar%' -- Grüße aus dem schönen Kleve Jens Kisters rosomm et partner Agentur für neue Medien GmbH Dienstleistungszentrum am Weißen Tor - Eingang B Gocher Landstrasse 2 47551 Kleve / Bedburg-Hau Telefon: 02821 - 97856-20 Telefax: 02821 - 97856-77 [EMAIL PROTECTED] http://www.rosomm-partner.de -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] What causes error 127 from table handler
Hi there, i got an error message got error 127 from table handler Last time i got that i lost a few rows in the affected table, but i thought that resulted from copying the db-files without shutting down the database, but the system i got the message from this time never had operations like this done on it, the tables belong to the same application, so what could i have done in php (PHP4.04 pl1) that introduced this error? The application does nothing fancy, just some basic operations. The tables have a few keys on them. the mysql versions are MySQL 3.23.32-log and MySQL 3.23.35-log no special features like transactions or so -- Gre aus dem schnen Kleve Jens Kisters rosomm et partner Agentur fr neue Medien GmbH Dienstleistungszentrum am Weien Tor - Eingang B Gocher Landstrasse 2 47551 Kleve / Bedburg-Hau Telefon: 02821 - 97856-20 Telefax: 02821 - 97856-77 [EMAIL PROTECTED] http://www.rosomm-partner.de -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Calling DB2's stored Procedures from PHP
is it possible to call stored procedures on an DB2 Database (assuming you have the DB2-Support up running)? -- Gre aus dem schnen Kleve Jens Kisters rosomm et partner Agentur fr neue Medien GmbH Dienstleistungszentrum am Weien Tor - Eingang B Gocher Landstrasse 2 47551 Kleve / Bedburg-Hau Telefon: 02821 - 97856-20 Telefax: 02821 - 97856-77 [EMAIL PROTECTED] http://www.rosomm-partner.de -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]