[PHP-DB] suggestion about php ocilogon() oracle OCI FUNCTION

2003-10-27 Thread kss
I'm using php/oracle9.2 . i cant' login into oracle db using ocilogon() as "SYS" user. so, i examed oci8.c source. above 9i , in order to login as "SYS" user 5th parameter of OCISessionBegin must be "OCI_SYSDBA"(not OCI_DEFAULT); -

[PHP-DB] Re: PHP + FIREBIRD + INTERNET INFORMATION SERVER

2003-10-27 Thread thejavo
Hi, after all, thank you, I was starting to think that I'm the only one trying to do something with Firebird ;), but, the thing is that, I got no error message at all, only the "ring" of a tone. And the strangest of all is that the things works fine and suddenly stop working. I've tried it in three

[PHP-DB] Re: PHP + FIREBIRD + INTERNET INFORMATION SERVER

2003-10-27 Thread thejavo
Hi, after all, thank you, I was starting to think that I'm the only one trying to do something with Firebird ;), but, the thing is that, I got no error message at all, only the "ring" of a tone. And the strangest of all is that the things works fine and suddenly stop working. I've tried it in three

Re: [PHP-DB] broken PHP

2003-10-27 Thread Shadow
:-) Shadow -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] RE: Query works but can't echo variable :'(

2003-10-27 Thread Jeremy Shovan
You are selecting it as date but trying to echo DateOfOrder Try this: $TheDate = mysql_query("select DATE_FORMAT(DateOfOrder, '%d, %m, %Y') as date from Orders Where Orders.ID = '$TransID'"); while($OrderDate = mysql_fetch_array($TheDate)) { $Date = $OrderDate["date"]; } -Original Message--

[PHP-DB] RE: mysql field comparison to multiple variables

2003-10-27 Thread Jeremy Shovan
Try this WHERE date_field != $date_1 OR date_field != $date_2 OR date_field != $date_3 -Original Message- From: Mike Baerwolf [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2003 6:46 PM To: [EMAIL PROTECTED] Subject: mysql field comparison to multiple variables Hello, I trying to

[PHP-DB] redirect

2003-10-27 Thread Dan Liu
Hi all, Has anyone used 'Module mod_rewrite URL Rewriting Engine'? I need to do a redirect from http://url1/cgi-bin/mapserv?&map=/dir1/county.map to http://url2/cgi-bin/mapserv?&map=/dir2/county.map But it is not working. Does somebody know why? Thanks in Advance. Dan -- PHP Database Mailing

Re: [PHP-DB] redirect

2003-10-27 Thread Rolf Brusletto
Dan Liu wrote: Hi all, Has anyone used 'Module mod_rewrite URL Rewriting Engine'? I need to do a redirect from http://url1/cgi-bin/mapserv?&map=/dir1/county.map to http://url2/cgi-bin/mapserv?&map=/dir2/county.map But it is not working. Does somebody know why? Thanks in Advance. Dan Dan - wi

Re: [PHP-DB] redirect

2003-10-27 Thread Peter Beckman
Wrong list to ask on -- you are looking for an Apache mailing list. http://apache.org/ read the manual page on mod_rewrite On Mon, 27 Oct 2003, Dan Liu wrote: > Hi all, > Has anyone used 'Module mod_rewrite URL Rewriting Engine'? > I need to do a redirect from > http://url1/cgi-bin/mapserv?&map

[PHP-DB] populating and searching to criteria

2003-10-27 Thread Shannon Doyle
Hi People, I have a three part question here. Well actually its 3 separate questions. First. How would I populate a select menu from a mysql databse with the entries from a particular field, but only showing those that are unique, ie not showing more than 1 of the same value. Second. How wou

Re: [PHP-DB] populating and searching to criteria

2003-10-27 Thread Micah Stevens
First: Use the SQL distinct command.. it's explained here: http://www.mysql.com/doc/en/SELECT.html That will get you unique values. Then just loop through the result: while ($d = mysql_fetch_assoc($return)) { ?> > http://www.mysql.com/doc/en/Fulltext_Search.html If you're using something else

Re: [PHP-DB] suggestion about php ocilogon() oracle OCI FUNCTION

2003-10-27 Thread Christopher Jones
kss wrote: > I'm using php/oracle9.2 . > i cant' login into oracle db using ocilogon() as "SYS" user. > above 9i , in order to login as "SYS" user > 5th parameter of OCISessionBegin must be "OCI_SYSDBA"(not OCI_DEFAULT); > my suggestion !! > > PHP ocilogon specification > resource ocilogon ( str

[PHP-DB] Apache cores when using PHP with Oracle support

2003-10-27 Thread John Mullins
Has anyone come across this behavior? We've built php 4.3.2 with Oracle support (both --with-oracle and --with-oci8), but when I try to start up Apache with the ORACLE_HOME env variable set to the Oracle home location, it core dumps with this error: Dump file /info/root/www/bin/kg_?_15533.trc KG P

Re: [PHP-DB] Apache cores when using PHP with Oracle support

2003-10-27 Thread Christopher Jones
John Mullins wrote: Has anyone come across this behavior? We've built php 4.3.2 with Oracle support (both --with-oracle and --with-oci8), but when I try to start up Apache with the ORACLE_HOME env variable set to the Oracle home location, it core dumps with this error: KGP-00600: internal erro

RE: [PHP-DB] populating and searching to criteria

2003-10-27 Thread Shannon Doyle
Thanks Micah, while ($d = mysql_fetch_assoc($return)) { ?> - I get a parse error on this line. while ($d = mysql_fetch_assoc($return)) { ?>> Third: > If you're using MySQL, check this out: > http://www.mysql.com/doc/en/Fulltext_Search.html > If you're using something else, it's more com

Re: [PHP-DB] populating and searching to criteria

2003-10-27 Thread Micah Stevens
This may be a dumb comment, but those variable don't make any sense, you'll have to replace them with stuff that relates to the query and the database. -Micah On Mon October 27 2003 8:34 pm, Shannon Doyle wrote: > Thanks Micah, > > > while ($d = mysql_fetch_assoc($return)) { > ?> - I get >