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('+ '.

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

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