[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

[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,

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

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 Expires

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 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 -

[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 brbrLicense has not expiredbrbr; } Else { echo brbrLicense has expiredbrbr; } :-P - Do you Yahoo!?

[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

[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); fclose($fp);

[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); fclose($fp);