Re: [PHP-DB] difference between two dates

2003-01-19 Thread Rajesh Fowkar
On Sun, Jan 19, 2003 at 09:34:02AM -0500, John W. Holmes wrote: >> I tried this : >> >> $dobtimestamp = mktime(0,0,0,$cboMM,$cboDD,$cboYY); >> $todaytimestamp = time(); >> $txtAge = ($todaytimestamp - $dobtimestamp)/86400; >> >> It does not give me the expected output. >> >> Can anybody suggest

RE: [PHP-DB] difference between two dates

2003-01-19 Thread John W. Holmes
> In my application I am accepting Day, Month and Year from a Select List. > What I want to do is calculate the age of the person based on the above > selection. > > $cboDD is the day variable > $cboMM is the month variable > $cboYY is the year variable > > I tried this : > > $dobtimestamp = mkt

[PHP-DB] difference between two dates

2003-01-19 Thread Rajesh Fowkar
Hello, In my application I am accepting Day, Month and Year from a Select List. What I want to do is calculate the age of the person based on the above selection. $cboDD is the day variable $cboMM is the month variable $cboYY is the year variable I tried this : $dobtimestamp = mktime(0,0,0,$cbo

RE: [PHP-DB] Difference between 2 dates.. thoughts?

2002-11-13 Thread Aaron Wolski
] Subject: RE: [PHP-DB] Difference between 2 dates.. thoughts? Test whether min() and max() work on date fields - never tried it. Or check the documentation on date and time functions for your database - they may have something that does this. If not, you could just do an order by date ascending and

RE: [PHP-DB] Difference between 2 dates.. thoughts?

2002-11-13 Thread Jason Vincent
13, 2002 12:27 PM To: Vincent, Jason [BRAM:1334:EXCH]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Difference between 2 dates.. thoughts? Hi There, Well the first and last record of the results. So if 1000 records were found... then record #1 and then record #1000 - perform data calculation between

RE: [PHP-DB] Difference between 2 dates.. thoughts?

2002-11-13 Thread Aaron Wolski
Message- From: Jason Vincent [mailto:jayv@;nortelnetworks.com] Sent: November 13, 2002 12:24 PM To: Aaron Wolski; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Difference between 2 dates.. thoughts? You should be able to do this at the database level - of course you never said what database that is

RE: [PHP-DB] Difference between 2 dates.. thoughts?

2002-11-13 Thread Jason Vincent
functions that might be able to tell the days elapsed between to dates (in mySQL you might look at the interval function). Regards, J -Original Message- From: Aaron Wolski [mailto:aaronjw@;martekbiz.com] Sent: Wednesday, November 13, 2002 11:33 AM To: [EMAIL PROTECTED] Subject: [PHP-DB

[PHP-DB] Difference between 2 dates.. thoughts?

2002-11-13 Thread Aaron Wolski
Hi All, First off I have a query like this: SELECT dateinserted FROM SiteTrackingTable; Now. in this query any number of results could be returned 10 or 1000, etc. Is it possible to take the dateinserted value from the first record and then from the last record and perform some calculation

RE: [PHP-DB] Difference in time

2002-10-02 Thread John W. Holmes
> I am fighting a time issue(don't we all). I have a online poll set up. I > need a way to stop a person from > submitting more than once an hour. As of now I have the time .. mktime( > ) .. being stored in a database along > with the users IP. > > I want to be able to say if 1 hour has passed fr

RE: [PHP-DB] Difference in time

2002-10-02 Thread Jason Vincent
Sent: Wednesday, October 02, 2002 2:56 PM To: Vincent, Jason [BRAM:1334:EXCH] Subject: Re: [PHP-DB] Difference in time MYSQL Here is a sample of what I am doing $ip = $_SERVER['REMOTE_ADDR']; $time_now = mktime(); // open connection to database $connect

RE: [PHP-DB] Difference in time

2002-10-02 Thread Jason Vincent
From: wade [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 1:29 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Difference in time Hello all, I am fighting a time issue(don't we all). I have a online poll set up. I need a way to stop a person from submitting more than once an hou

[PHP-DB] Difference in time

2002-10-02 Thread wade
Hello all, I am fighting a time issue(don't we all). I have a online poll set up. I need a way to stop a person from submitting more than once an hour. As of now I have the time .. mktime( ) .. being stored in a database along with the users IP. I want to be able to say if 1 hour has passed from

Re: [PHP-DB] difference !!??

2002-02-07 Thread Daniel Ems
Bart, See this page for an explanation of quotes inside array brackets: http://www.php.net/manual/en/language.types.array.php Basically, the correct way to do it is to _always_ use quotes (single quotes for strings without variables, and double quotes for strings with variables). So your examp

[PHP-DB] difference !!??

2002-02-07 Thread B. Verbeek
Hello, What's the difference between: 1.- $row[column_name]; 2.- $row['column_name']; 3.- $row["column_name"]; ? ragards Bart -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Difference between OCI* functions and ORA_* functions

2001-10-04 Thread Philippe Saladin
FYI, You can use OCI8 on a Oracle 7 database, if the net8 client is configured Regards, Philippe "B. Perrine" <[EMAIL PROTECTED]> a écrit dans le message news: [EMAIL PROTECTED] ORA are for Oracle7 OCI8 for Oracle8 Read the manual on www.php.net B. le jeu 04-10-2001 at 17:02 Sridhar Moparthy a

Re: [PHP-DB] Difference between OCI* functions and ORA_* functions

2001-10-04 Thread B. PERRINE
ORA are for Oracle7 OCI8 for Oracle8 Read the manual on www.php.net B. le jeu 04-10-2001 at 17:02 Sridhar Moparthy a écrit : > Hi All, > > Does any one know the difference between OCI* functions from PHP_OCI8.DLL > and ORA_* functions from PHP_ORACLE.DLL? > Which one is better in terms of spe