Re: [PHP-DB] SELECT problem

2001-02-23 Thread JJeffman
echo(""); HTH Jayme. -Mensagem Original- De: Julio Cuz, Jr. <[EMAIL PROTECTED]> Para: <[EMAIL PROTECTED]> Enviada em: quinta-feira, 22 de fevereiro de 2001 18:33 Assunto: [PHP-DB] SELECT problem > Hi-- > > What's wrong with this line of code? > > echo(" NAME='campus'>"); > > > > Julio

Re: [PHP-DB] MySQL execution order...

2001-02-23 Thread Bob Hall
Sir, it would help to see the INSERT statement and the table definition. Bob Hall >I sent this message to the "general" list yesterday, and have yet to get an >answer (except for that Spanish "Snow White" virus attempt from Peru). > >I'm trying to download info from a table as a tab-delimted tex

[PHP-DB] OCI 8 and rowid cause SIGSEGV

2001-02-23 Thread SVEN . VOIGT
Hi there! I am using the following code on SuSE 6.4, Apache 1.3.14 and PHP 4.0.4: # $sql is dyanmically built, e.g. $sql = "select foo, bar, :rid from masterdata"; $db = OCILogOn("picht","picht"); $stmt = OCIParse($db, $sql); $rowid = OCINewDescriptor($db,OCI_D_ROWID); OCIBindByName($stmt,":

RE: [PHP-DB] Re: sessions

2001-02-23 Thread Hoover, Josh
Configure PHP with this line included --enable-trans-sid This will automatically put the session ID after every URL if the user does not have cookies enabled. Josh Hoover KnowledgeStorm, Inc. Searching for a new IT solution for your company? Need to improve your product marketing? Visit Knowle

AW: [PHP-DB] Re: sessions

2001-02-23 Thread Matthias Kopolt
configure apache with modrewrite and configure it to rewrite a request URL like http://domain/DUMMY/1234109809--cookiedata---123412341234/file to localfile url /home/apache/triggeredpath/file or use one php-file for your total website (maybe modular with includes), then you can build URLS lik

[PHP-DB] SQL finding a date problem

2001-02-23 Thread Gary
Can someone tell me how to search for a date with SQL? I have tried the following SELECT * from schedule WHERE EST_DATE = '03/26/2001'; I get the error Incompatible datatypes in expression : = , SQL state 37000 Thanks. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-ma

RE: [PHP-DB] SQL finding a date problem

2001-02-23 Thread Hoover, Josh
Try this: SELECT * from schedule WHERE EST_DATE = '2001-03-26'; By the way, what Database are you using? Josh Hoover KnowledgeStorm, Inc. Searching for a new IT solution for your company? Need to improve your product marketing? Visit KnowledgeStorm at www.knowledgestorm.com to learn how we ca

Re: [PHP-DB] OCI 8 and rowid cause SIGSEGV

2001-02-23 Thread Joe Brown
I suppose the authors never concieved a replacement parameter for select specification. try: > $sql = "select foo, bar, rid from masterdata WHERE rid=:rid" You need to loose the colon ":" or place it to the right of a where clause. <[EMAIL PROTECTED]> wrote in message F114C0EF28F3D211B7E8400061

[PHP-DB] Interbase connection problem

2001-02-23 Thread Duky
Can somebody help me out? I have some problems with connecting my gdb file with PHP. it is giving me this error: Fatal error: Call to undefined function: () in /home/sites/site156/web/columbus/ibconnect.php on line 9 What can I do now? Thnx, Duky -- PHP Database Mailing List (http://www.php

[PHP-DB] onMouseOver & onMouseOut

2001-02-23 Thread Rudi Ahlers
Is there such a function for PhP ? I want to replace some javasctiripts with PhP, but there are quite a few onmouseover events. Thank you Rudi "Opinions expressed do not necessarily represent the views of my employer." -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-ma

[PHP-DB] PHP + interbase connection problem

2001-02-23 Thread Duky
Can somebody help me out? I have some problems with connecting my gdb file with PHP. it is giving me this error: Fatal error: Call to undefined function: () in /home/sites/site156/web/columbus/ibconnect.php on line 9 What can I do now? Thnx, Duky -- PHP Database Mailing List (http://www.php

Re: [PHP-DB] Timeout

2001-02-23 Thread Stas Trefilov
Hello, Daniel Rezny! You wrote: > I've changed max_exution_time in php.ini file, increase > a conection > timeout for webserver and still the same. What else I > have to do > more. > You got to optimise your database storage by using indexes and ung your SQL. See additional resour

[PHP-DB] Error compiling php

2001-02-23 Thread Enrico Comini
During compilation of php4 I have this: What I have to do ? Thanks, Enrico DXML_BYTE_ORDER=12 -g -O2 -c sapi_apache.c sapi_apache.c:32: httpd.h: No such file or directory sapi_apache.c:33: http_config.h: No such file or directory sapi_apache.c:41: http_core.h: No such file or directory sapi_a

Re: [PHP-DB] onMouseOver & onMouseOut

2001-02-23 Thread JJeffman
Remember, php is server side while JavaScript is client side. You can't use php client side. You can use some client side events to call php scripts which will run on the server and send data to the browser. Events are client side, so try JavaScript you'll enjoy it too. HTH Jayme. -Mensagem

Re: [PHP-DB] onMouseOver & onMouseOut

2001-02-23 Thread Ron Brogden
At 06:27 PM 2/23/2001 -0300, you wrote: >Remember, php is server side while JavaScript is client side. You can't use >php client side. You can use some client side events to call php scripts >which will run on the server and send data to the browser. Events are client >side, so try JavaScript you'

RE: [PHP-DB] Can PHP read View in stead of Table?

2001-02-23 Thread WC Ip
Dear Andrew, I have followed your instruction to comment out the #define statement. PHP/Apache can recompile smoothly but PHP still need key to search the table so that I cannot access View. Moreover, I found that when I propose SQL statement using "group by", error printed : "SQL error: [OpenL

Re: [PHP-DB] Can PHP read View in stead of Table?

2001-02-23 Thread Andrew Hill
Hi Peter, What is the SQL statement that you are using? Also, can you give me the table structure? Lastly, an ODBC trace would be helpful. Look in your odbc.ini file and uncomment the DebugFile section, pointing it to a suitable location. I also suggest you respond to this off list; this may g