[PHP-DB] RE: [PHP] Adding a log file

2003-11-07 Thread Erik Osterman
Consider using this // // STDERR logging function // function warn( $msg, $die = 0 ) { $fp = fopen("php://stderr", 'w') or die("Failed to open STDERR"); fwrite($fp, "[".strftime("%Y-%m-%d %T")."] $msg\n") or die("Failed to write to stderr"); fcl

[PHP-DB] Re: [PHP] Adding a log file

2003-11-07 Thread John W. Holmes
Erik Osterman wrote: Consider using this // // STDERR logging function // function warn( $msg, $die = 0 ) { $fp = fopen("php://stderr", 'w') or die("Failed to open STDERR"); fwrite($fp, "[".strftime("%Y-%m-%d %T")."] $msg\n") or die("Failed to write to stderr"); fc

[PHP-DB] Tristan Pretty is out of the office.

2003-11-07 Thread Tristan . Pretty
I will be out of the office starting 23/10/2003 and will not return until 11/11/2003. I will respond to your message when I return. Please contact Fiona or Alan for any issues. * The information contained in this e-mail me

Re: [PHP-DB] Strtotime works for date comparisons on nonUnix--thank you :)

2003-11-07 Thread Jason Wong
On Saturday 08 November 2003 03:43, Karen Resplendo wrote: >$today = Strtotime(date("m/d/Y")); >$expires=Strtotime(odbc_result($data,"Expires")); > >If ($today <= $expires) > { > echo "License has not expired"; > } >Else > { > echo "License has expired"; >

[PHP-DB] Strtotime works for date comparisons on nonUnix--thank you :)

2003-11-07 Thread Karen Resplendo
$today = Strtotime(date("m/d/Y")); $expires=Strtotime(odbc_result($data,"Expires")); If ($today <= $expires) { echo "License has not expired"; } Else { echo "License has expired"; } :-P - Do you Yahoo!? Protect your

Re: [PHP-DB] CONVERT STRING VARIABLES TO DATES, THEN COMPARE (HOW?)

2003-11-07 Thread Karen Resplendo
Education :) (it seems like such a simple thing to do, to look up, to have in someone's library of code, yet. . . . . . .) > I can do it with my eyes closed in SQL. I don't want to if I can avoid it. It's more efficient to do so, so can I ask why you want to avoid it? -- Jason Wong -> Gre

Re: [PHP-DB] CONVERT STRING VARIABLES TO DATES, THEN COMPARE (HOW?)

2003-11-07 Thread Jason Wong
On Saturday 08 November 2003 03:08, Karen Resplendo wrote: > Yes, the values echo out the way I expect them. But these are displayed > values, not dates, I'm pretty sure, and that is why the comparison is > failing. > > The question began very simply. I will try to make it simpler: > > How do I com

Re: [PHP-DB] CONVERT STRING VARIABLES TO DATES, THEN COMPARE (HOW?)

2003-11-07 Thread Karen Resplendo
Yes, the values echo out the way I expect them. But these are displayed values, not dates, I'm pretty sure, and that is why the comparison is failing. The question began very simply. I will try to make it simpler: How do I compare a string date from a database to today's date using PHP? I can

Re: [PHP-DB] CONVERT STRING VARIABLES TO DATES, THEN COMPARE (HOW?)

2003-11-07 Thread Jason Wong
On Saturday 08 November 2003 02:44, Karen Resplendo wrote: > Apache on NT using MS SQL Srvr 2000 > PHP 4.03pl1 > > I return these dates into strings and now I want to compare my database > date to see if it is later than today's date. Pretty sure my "Expires" > field is a string: > > Here is the "E

RE: [PHP-DB] CONVERT STRING VARIABLES TO DATES, THEN COMPARE (HOW?)

2003-11-07 Thread Oscar Rylin
Strtotime() Look it up in the manual :-) -Original Message- From: Karen Resplendo [mailto:[EMAIL PROTECTED] Sent: den 7 november 2003 19:44 To: [EMAIL PROTECTED] Subject: [PHP-DB] CONVERT STRING VARIABLES TO DATES, THEN COMPARE (HOW?) Apache on NT using MS SQL Srvr 2000 PHP 4.03pl1 I r

[PHP-DB] CONVERT STRING VARIABLES TO DATES, THEN COMPARE (HOW?)

2003-11-07 Thread Karen Resplendo
Apache on NT using MS SQL Srvr 2000 PHP 4.03pl1 I return these dates into strings and now I want to compare my database date to see if it is later than today's date. Pretty sure my "Expires" field is a string: Here is the "Expires" field from the SQL: Convert(varchar, DATEADD(Year,3,DateCertif

[PHP-DB] PHP 4.3.4 + Oracle 9i + Apache 2.0.47

2003-11-07 Thread Daniel Sand
Hello, The system is Solaris sun4u sparc SUNW,UltraAX-i2, SunOS 5.8 i'm compiling this with a gcc 3.3. I'm trying to configure a PHP 4.3.4 with oracle oci8 support. i've pushed the vars for oracle in the enviroment ORACLE_BASE="/opt/oracle/app/oracle" export ORACLE_BASE ORACLE_HOME="/opt/oracl