RE: [PHP-DB] Date help needed

2004-06-25 Thread Kenny
Hi Neil, I would actually like to get a sample of this code as well if you don't mind K- -Original Message- From: Neil Smith [MVP, Digital media] [mailto:[EMAIL PROTECTED] Sent: 25 June 2004 16:22 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Date help neede

Re: [PHP-DB] Date help needed

2004-06-25 Thread Neil Smith [MVP, Digital media]
0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Subject: RE: [PHP-DB] Date help needed One thing he wanted which I didn't know how to do (Javascript I guess which I don't know much about) was to preload a database of email address, and as

RE: [PHP-DB] Date help needed

2004-06-24 Thread Chris Payne
Hi there, >A drop down with 365 days !?!? Isn't that a "little" big? Actually it's Fridays, Sundays and Tuesdays for 2 years (365 was an example) it's for an Admin for a client, and he asked that it be in a dropdown box and he's the boss, so he gets what he wants :-) One thing he wanted which

Re: [PHP-DB] Date help needed

2004-06-24 Thread Daniel Clark
A drop down with 365 days !?!? Isn't that a "little" big? > I have a problem, I currently have some code which populates a dropdown > box > - this code gives me every day for the next x amount of days (EG: a years > worth of days), however what I really need to be able to do, is to find a > way

RE: [PHP-DB] Date help needed

2004-06-24 Thread Chris Payne
Hi there, Just got back and tried it and it works perfectly, thank you so much for your help, you've got me out of a bind here ;-) Chris You could loop through the weeks and put those 3 specifically in: $days = array(); for($i = 0; $i < 365; $i +=7) { $days[] = strtotime('next Monday', strtoti

Re: [PHP-DB] Date help needed

2004-06-24 Thread Justin Patrin
You could loop through the weeks and put those 3 specifically in: $days = array(); for($i = 0; $i < 365; $i +=7) { $days[] = strtotime('next Monday', strtotime('+ '.$i.' days')); $days[] = strtotime('next Friday', strtotime('+ '.$i.' days')); $days[] = strtotime('next Sunday', strtotime('+ '.

[PHP-DB] Date help needed

2004-06-24 Thread Chris Payne
Hi there everyone, I have a problem, I currently have some code which populates a dropdown box - this code gives me every day for the next x amount of days (EG: a years worth of days), however what I really need to be able to do, is to find a way to display this data in the dropdown box but ONL

Re: [PHP-DB] date help

2001-11-18 Thread Jason G.
Hello, You said that you are using MySQL. Create 2 columns like: create_ts INT UNSIGNED NOT NULL, last_login_ts INT UNSIGNED NOT NULL Use the MySQL UNIX_TIMESTAMP() function, comparable to the PHP time() function (number of seconds since 1-1-1970 12:00:00 AM). UPDATE table SET last_login_ts=

Re: [PHP-DB] date help

2001-11-17 Thread Andreas D. Landmark
At 17.11.2001 14:45, Srinivasan Ranganathan wrote: >Hi > >I need to store the date and time of sign-up and date >and time of last successful login in a mysql database >and calculate how long the user has been using a site. >how do i do this? Store date either in seconds since 19700101 or use your

[PHP-DB] date help

2001-11-17 Thread Srinivasan Ranganathan
Hi I need to store the date and time of sign-up and date and time of last successful login in a mysql database and calculate how long the user has been using a site. how do i do this? thanks in advance Srinivasan __ Do You Yahoo!? Everything you'l

Re: [PHP-DB] Date Help

2001-03-07 Thread Richard S. Crawford
I desperately need to know whether it is possible to call an Oracle function in PHP. For example... $functionResult=hubins($name,$commit_yn) where hubins is a stored procedure in our Oracle database. Can this be done? My first thought was to do something like this: $functionCall="hubins($

[PHP-DB] Date Help

2001-03-07 Thread Faye Keesic
--MS_Mac_OE_3066812333_145812_MIME_Part Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit When I want to subtract a day from a date, and pass the date to a function that will do the subtraction and then return the new value, so why does php sometimes subtract the year, i