[PHP-DB] Fast template

2001-12-03 Thread sharmad
Hi, I am working on a Fasttemplate dbase project,so i downloaded the Fasttemplate and untarred(unzipped) in the /usr/local/lib/php directory but gives me the following error :- Warning: Failed opening 'class.FastTemplate.php3' for inclusion (include_path='.:/usr/local/lib/php') in

[PHP-DB] no Oracle functions

2001-12-03 Thread John Kolvereid
Hi, I have just downloaded and installed PHP4.0.6. I have configured it --with-mysql and --with-oracle. I am able to easily use Mysql but NOT Oracle. When I try an ora_logon or ora_login I get 'Fatal error: Call to undefined function: ora_log?n' Moreover, I AM able to use Oracle w/ DBI

Re: [PHP-DB] no Oracle functions

2001-12-03 Thread Thies C. Arntzen
On Mon, Dec 03, 2001 at 06:58:00AM -0800, John Kolvereid wrote: Hi, I have just downloaded and installed PHP4.0.6. I have configured it --with-mysql and --with-oracle. I am able to easily use Mysql but NOT Oracle. When I try an ora_logon or ora_login I get 'Fatal error: Call to

Re: [PHP-DB] Fast template

2001-12-03 Thread Jason Wong
On Monday 03 December 2001 18:42, [EMAIL PROTECTED] wrote: Hi, I am working on a Fasttemplate dbase project,so i downloaded the Fasttemplate and untarred(unzipped) in the /usr/local/lib/php directory but gives me the following error :- Warning: Failed opening 'class.FastTemplate.php3'

Re: [PHP-DB] no Oracle functions

2001-12-03 Thread John Kolvereid
Hi Thies, Thanks for the info. I tried re-configuring w/ --with-oracle=$ORACLE_HOME and --with-oci8=$ORACLE_HOME. After configuration I got the msg that --with-odi8 there was no such file or directory as /u01/app/oracle/product/8.1.7 (which is $ORACLE_HOME). However, now I am able to open

[PHP-DB] Can't unserialize array from mysql

2001-12-03 Thread Jim Doolittle
Hi, I'm trying to loop thru an unserialized array pulled from mysql. First I serialized the array before storing it: $sql =UPDATE $table_name set performer_id=' . addslashes(serialize($perfor mer_id)) . ' WHERE 

RE: [PHP-DB] Use php to plot graph.

2001-12-03 Thread matt stewart
yes, it is possible - read up on the .PNG image format, as it is possible to create graphs ind images dynamically to suit the data and figures youve extracted from the database -Original Message- From: Denny Ow [mailto:[EMAIL PROTECTED]] Sent: 03 December 2001 16:14 To: [EMAIL PROTECTED]

RE: [PHP-DB] Use php to plot graph.

2001-12-03 Thread Leotta, Natalie (NCI/IMS)
I'm working on a project right now where we call PHP from within an HTML page, send it vars using a POST method, and then use that to draw a graph. We're drawing bar graphs now but one of my coworkers did a line graph. You call the PHP as an img src tag and have PHP return a .png. We used the

Re: [PHP-DB] Use php to plot graph.

2001-12-03 Thread Daniel Barton
There are a few ways to go about this: You could: 1) Use little image blocks to dynamically build bar graphs. It's not too hard with PHP. Make some little square (or round or whatever) gifs (with transparent edges), and then position them on a background JPEG or gif using DIV tags. Make an

Re: [Fwd: [PHP-DB] Oracle functions]

2001-12-03 Thread John Kolvereid
Hi Dan, I tried $n = ora_numcols($odb); echo number = $n\n; This resulted in '0' which I know is incorrect. It should be '1' = the number in the table. Any other ideas. Please advise. Thanks. Daniel Barton wrote: ooops, forgot to reply to list too. -- -- Dan

Re: [PHP-DB] Use php to plot graph.

2001-12-03 Thread Jason Wong
On Tuesday 04 December 2001 00:14, Denny Ow wrote: Hi, Jus wanna to ask if it is possible to use php to plot graph using data retrieve from mysql. If yes, how should i go about? Check out the graphics section of http://www.phpclasses.upperdesign.com/. It's got some neat classes for creating

[PHP-DB] finding a link in large text blob

2001-12-03 Thread Terry Romine
Is there an easy way (say using eregi_replace) to find a link reference in a blob of text and add the a href anchor around it? Something like: text has a link to a website at http://www.whatever.com/mydirectory/mypage.html ... and converts it to text has a link to a

[PHP-DB] EZ Question...I think

2001-12-03 Thread Thomas
I have looked into some source code that I found, but I'm a newbie at this, and don't understand.. if ( 0 == $this-link_id) { In this statment, what does the '-' repersent? this statment (operator?) occurs alot in this code that I have, but I can't find the definition on any site...can anyone

[PHP-DB] pg_fetch_object() not returning values from multi-table query

2001-12-03 Thread K Old
Hello all, I have the following code: /* construct the query */ $the_sql = SELECT inv.at_id FROM invoice_items inv, customer cus WHERE inv.client_id = cus.client_id AND inv.inv_id = '2001-12-03-4'; /* send the statement to query() for processing */ $qid =

RE: [PHP-DB] EZ Question...I think

2001-12-03 Thread Brian Paulson
Thomas, It a used to referance a class method or proporty Example: ? Class Simple { var $debug = True; // Proporty Function Debug($msg) // Method { if($this-debug == True) {

[PHP-DB] Re: EZ Question...I think

2001-12-03 Thread Thomas
Thanks everyone. Appreciate it. Thomas [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I have looked into some source code that I found, but I'm a newbie at this, and don't understand.. if ( 0 == $this-link_id) { In this statment, what does the '-'

[PHP-DB] Unable to Open ORACLE

2001-12-03 Thread John Kolvereid
Hi, I tried the following snippet from http://www.php.net/manual/en/ref.oracle.php $query = Select * from patients where clientid = 'DEMO'; ora_parse($curs, $query); ora_exec($curs); ora_fetch($curs); The parse executed successfully, but the exec complained

[PHP-DB] adding an auto-incrementing id field to an existing database

2001-12-03 Thread chip
I have an existing database, created a while back, which I need to add a id field to, there isn't one currently. Will simply adding a new auto-increment field be okay? Will the existing rows receive id numbers and will they be numbered properly? Or will it start with the new data and continue

[PHP-DB] Re: Unable to Open ORACLE

2001-12-03 Thread John Kolvereid
Hi, Me again, My table has a CLOB in it. Could that be a problem. When I tried the same querry on another table w/o a CLOB it succeeded. Please advise. Thanks. John Kolvereid wrote: Hi, I tried the following snippet from http://www.php.net/manual/en/ref.oracle.php $query

[PHP-DB] Re: Unable to Open ORACLE

2001-12-03 Thread John Kolvereid
Hi, Me again, My table has a CLOB in it. When I tried the same querry w/ another table w/o a CLOB it succeeded. Are CLOBs an issue? Please advise. Thanks. John Kolvereid wrote: Hi, I tried the following snippet from http://www.php.net/manual/en/ref.oracle.php $query =

Re: [PHP-DB] Re: Unable to Open ORACLE

2001-12-03 Thread Anthony Carlos
John: Yes, CLOBs are a little more difficult to access. The best way I've used them is to use the DBMS_LOB package in Oracle. Here's a link on technet.oracle.com to some documentation. http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev. 817/a76940/adl03pr4.htm#146661 I

[PHP-DB] Re: Unable to Open ORACLE

2001-12-03 Thread Manuel Lemos
Hello, John Kolvereid wrote: Hi, Me again, My table has a CLOB in it. When I tried the same querry w/ another table w/o a CLOB it succeeded. Are CLOBs an issue? Please advise. Thanks. I have no idea what is the problem here, but you may want to try Metabase which is a PHP

[PHP-DB] Failed to query correctly.

2001-12-03 Thread Denny
Hi, I got this problem when i tried to do a sql query and print the ouput. But the script below always failed to return the first row of the records. But i do a manual query, i got the results i wanted. Thanks, Denny $query=SELECT * from $tbl ; $result=mysql_query($query);

[PHP-DB] Mass Mailing

2001-12-03 Thread Nathan Cavicchi
I started writing a set of scripts that would send out mutiple emails to a list of customers. I then realized that most likely this program, and/or snipits had most likely already been written. If so, can some one point me in the right direction and save me 3 or 4 days? Thanks Nathan

[PHP-DB] Re: Mass Mailing

2001-12-03 Thread Manuel Lemos
Hello, Nathan Cavicchi wrote: I started writing a set of scripts that would send out mutiple emails to a list of customers. I then realized that most likely this program, and/or snipits had most likely already been written. If so, can some one point me in the right direction and save me