RE: [PHP] PHP 5.0.1 Date

2007-07-12 Thread Shafer, Philip
[mailto:[EMAIL PROTECTED] Sent: Wednesday, July 11, 2007 4:25 PM To: Shafer, Philip Cc: php-general@lists.php.net Subject: Re: [PHP] PHP 5.0.1 Date Almost for sure from the TZ environment variable, and almost for sure there's more about it in the FAQ, IIRC: http://php.net/faq.php On Wed, July 11

[PHP] PHP 5.0.1 Date

2007-07-11 Thread Shafer, Philip
at the moment. Can anybody let me know where PHP 5.0.1 gets the timezone information from? How can I change this so PHP returns the proper date. Thanks, Phil --- Philip Shafer Web Programmer University Web Services Rowan University Glassboro NJ 08028 856-256-4418 [EMAIL PROTECTED

Re: [PHP] PHP 5.0.1 Date

2007-07-11 Thread Richard Lynch
this so PHP returns the proper date. Thanks, Phil --- Philip Shafer Web Programmer University Web Services Rowan University Glassboro NJ 08028 856-256-4418 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP] PHP MySQL DATE comparison

2004-06-16 Thread Ryan Schefke
Hello, I'm pulling a date in the datetime format via a MySQL query. Using PHP I would like to check if that date is prior to today's date. Can someone please help with this quick question. Thanks, Ryan

RE: [PHP] PHP MySQL DATE comparison

2004-06-16 Thread Ryan Schefke
12:43 PM To: Php-General-Help Subject: [PHP] PHP MySQL DATE comparison Hello, I'm pulling a date in the datetime format via a MySQL query. Using PHP I would like to check if that date is prior to today's date. Can someone please help with this quick question. Thanks, Ryan -- PHP

[PHP] PHP Auto-Date Select Box

2003-04-04 Thread Jay Fitzgerald
Does anyone know how I can make a PHP form select box that has the dates in it for the next 7 days including today and the remaining days from this week? eg: SELECT NAME=date OPTION VALUE=2003-04-05Friday, April 5 OPTION VALUE=2003-04-06Saturday, April 6 OPTION VALUE=2003-04-07Sunday, April 7

RE: [PHP] PHP Auto-Date Select Box

2003-04-04 Thread Matt Schroebel
-Original Message- From: Jay Fitzgerald [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 9:17 AM Subject: [PHP] PHP Auto-Date Select Box Does anyone know how I can make a PHP form select box that has the dates in it for the next 7 days including today and the remaining

Re: [PHP] PHP Auto-Date Select Box

2003-04-04 Thread Marek Kilimajer
for($i = 0; $i = 7; $i++) { $day=strtotime(+$i day); echo 'option value='. date('Y-m-d',$day) .''. date(' *your format here* ',$day).'/option'; } Jay Fitzgerald wrote: Does anyone know how I can make a PHP form select box that has the dates in it for the next 7 days including today and

[PHP] PHP and Date()

2002-07-18 Thread Chris Crane
How can I look back Business Days. I would like to go back from a certain date, like 7 business days. Is there a simple way other then looping and checking for the day of the week? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] PHP and Date()

2002-07-18 Thread Jay Blanchard
[snip] How can I look back Business Days. I would like to go back from a certain date, like 7 business days. Is there a simple way other then looping and checking for the day of the week? [/snip] $sevendaysago = date(Y-m-d, mktime(date(h)-168)); This will give you the date exactly seven days

Re: [PHP] PHP and Date()

2002-07-18 Thread Chris Crane
sorry about last message I want to get a list of the last 7 business days so I would have to loop through this and get each day correct? Jay Blanchard [EMAIL PROTECTED] wrote in message 001701c22e78$4494c970$8102a8c0@niigziuo4ohhdt">news:001701c22e78$4494c970$8102a8c0@niigziuo4ohhdt... [snip]

RE: [PHP] PHP and Date()

2002-07-18 Thread Jay Blanchard
[snip] sorry about last message I want to get a list of the last 7 business days so I would have to loop through this and get each day correct? [/snip] Yes, testing for Saturday and Sunday ... Jay Vampires Suck * * Want to meet other PHP developers * * in

[PHP] PHP/MySQL -- Date/Time Confusion

2002-07-12 Thread Monty
Which method is the best way to store date/time in MySQL and then which PHP command is the best to use to convert that date to something useful? I'm having a difficult time figuring out how to reconcile the date in MySQL so it works with PHP's various date commands, like getdate(). Any

Re: [PHP] PHP/MySQL -- Date/Time Confusion

2002-07-12 Thread 1LT John W. Holmes
You've got all kinds of options. I suggest you do any date calculations in the database and use DATE_FORMAT to format any dates pulled out. It's exactly like the date() function in PHP. MySQL has some great date and time functions so you can select out exactly what you want. You can use

RE: [PHP] PHP/MySQL -- Date/Time Confusion

2002-07-12 Thread David Freeman
Which method is the best way to store date/time in MySQL and then which PHP command is the best to use to convert that date to something useful? Get comfortable with MySQL's date functionality and you'll find that you don't often need to do the date comparisons and manipulation in php

Re: [PHP] PHP/MySQL -- Date/Time Confusion

2002-07-12 Thread Anas Mughal
The easiest and my preferred way is to use strtotim method. This method accepts MySQL format 2002-12-23 and converts it into a UNIX time stamp. After that you can use the date function to format time as you wish! Monty [EMAIL PROTECTED] wrote: Which method is the best way to store date/time

RE: [PHP] php - assigning date variables

2002-02-26 Thread joakim . andersson
PROTECTED]] Sent: Monday, February 25, 2002 7:34 PM To: [EMAIL PROTECTED] Subject: [PHP] php - assigning date variables $query = mysql_query(SELECT * FROM table WHERE date LIKE '%. $query .%'); // returns all items in database $query = 2001-01-01 mysql_query(SELECT * FROM table WHERE date

[PHP] php - assigning date variables

2002-02-25 Thread Craig Westerman
$query = mysql_query(SELECT * FROM table WHERE date LIKE '%. $query .%'); // returns all items in database $query = 2001-01-01 mysql_query(SELECT * FROM table WHERE date LIKE '%. $query .%'); // returns all rows that have 2001-01-01 as the date What is proper way to define a variable to