[PHP-DB] ORACLE Stored procedure trouble

2002-10-21 Thread dr. Agon
Hello, friends. I got a problem working with ORA functions in PHP. I need to request ORACLE stored procedure with two params. First is some kind of "table type" (i can get exact english name of this termin if need) - e.g. this parameter is table :-/. What is this, and how I can bind this in PHP?

Re: [PHP-DB] TOO MANY CONNECTIONS!!

2002-10-25 Thread dr. Agon
Helo, why you don't make some kind of "db_connect.php" which will make "mysql_pconnect()" and include it in top of your first script? You then will be able use mysql query in everyone of your page. You can also make $mysql_is_connected=true; there and check that variable in other scrips if nee

Re: [PHP-DB] search field into MySQL

2002-10-25 Thread dr. Agon
Did anyone hear about "match against" construction? I is easy to build this: $query = "SELECT *, MATCH field AGAINST ('$searchwords') as relev FROM table ORDER BY relev DESC" (you need do "ALTER TABLE table ADD FULLTEXT(field)" before. This could be usefull: http://detail.phpclub.net/download/s

[PHP-DB] What is OCINewCollection() for?

2002-10-25 Thread dr. Agon
Hello, friends. I am working with PHP+ORACLE project. I need there to request a procedure with pl/sql table parameter. e.g. something like: TYPE tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; I had found OCINewCollection() function in manual. Unfrortunatly this function description is only "com