I need to reformat the output of the 'dates' field from '2009-04-08' to
'Wed. Apr. 8th'. Any help would be appreciated.
Thanks.
---
for ($counter = 0; $counter mysql_num_rows($resultID); $counter++);
while ($row = mysql_fetch_object($resultID))
{
print tr;
print td . $row-dates .
Jack Lauman wrote:
I need to reformat the output of the 'dates' field from '2009-04-08' to
'Wed. Apr. 8th'. Any help would be appreciated.
You can either do it using mysql date formats (see
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format)
or something
See the date function
Http://www.php.net/date
Bastien
Sent from my iPod
On Apr 8, 2009, at 21:41, Jack Lauman jlau...@nwcascades.com wrote:
I need to reformat the output of the 'dates' field from '2009-04-08'
to 'Wed. Apr. 8th'. Any help would be appreciated.
Thanks.
---
for ($counter
On Tue, Aug 5, 2008 at 4:33 PM, Ben Miller [EMAIL PROTECTED]wrote:
Figured there had to be an easier way. Thank you so much.
-Original Message-
From: Simcha Younger [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2008 2:48 PM
To: php-db@lists.php.net
Subject: RE: [PHP-DB] Date
I'm looking for a quick and simple way to query a MySQL database by date, or
more specifically, by day of the week. My dates are stored in the DB in
-MM-DD HH:MM:SS format. Question, is there a built-in for PHP or MySQL
that will take this column and return only Saturdays, for example,
Select * FROM ... WHERE DAYOFWEEK(datecol)=7
-Original Message-
From: Ben Miller [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2008 8:10 PM
To: PHP. DB Mail List
Subject: [PHP-DB] Date Translation in MySQL
I'm looking for a quick and simple way to query a MySQL database by date
Figured there had to be an easier way. Thank you so much.
-Original Message-
From: Simcha Younger [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2008 2:48 PM
To: php-db@lists.php.net
Subject: RE: [PHP-DB] Date Translation in MySQL
Select * FROM ... WHERE DAYOFWEEK(datecol)=7
I want to calculate the registed users today
Also total users this week
Total users this month
Total users this year
The Mysql table has a row of INT(11) with time() value inserted.
I did something like this
$today = strtotime(+1 day)
Then $sql = SELECT COUNT(*) FROM table WHERE dateReg =
Something like this should work.
$today = mktime(0, 0, 0, date(m), date(d), date(Y));
$tomorrow = mktime(0, 0, 0, date(m), date(d) + 1, date(Y));
$sql = SELECT COUNT(*) FROM table WHERE regdate BETWEEN {$today} AND
{$tomorrow};
$thismonth = mktime(0, 0, 0, date(m), 1, date(Y));
$nextmonth =
my problem is with date format
mysql support -mm-dd
but my client not use to enter date in -mm-dd format
he use to in dd-mm-yyy format
how can it possible to input date in
dd-mm- format
www.php.net/date will show you all the possibilities of formatting the date
bastien
Date: Sat, 22 Dec 2007 17:54:07 +0600
From: [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] date format problem
my problem is with date format
From: rDubya [EMAIL PROTECTED]
Thanks for the help so far guys!!
Not helping though. I have the date contained in the database as timestamp
(-MM-DD HH:MM:SS).
Do you really need to pull events from the database which are not in your
range of interest? This will only slow down your
From: Instruct ICC [EMAIL PROTECTED]
And while not trusting your indexing, rewrite short_date as:
My short_date rewrite was also wrong. So it looks like you will have to
learn those offsets for this function if you do it on the PHP side. But you
could also do it on the MySQL side.
This DID work, but I recently switched hosting companies...
Is the new server in a different country with a different date format
/ time zone?
Just a thought ;-\
On 9/7/07, Instruct ICC [EMAIL PROTECTED] wrote:
From: Instruct ICC [EMAIL PROTECTED]
And while not trusting your indexing,
WOW!! Thanks for all the help guys!! And Instruct ICC.. you're
solution for pulling the events did work.. but.. it turns out that
the solution was actually much simpler than I thought:
The old mysql database (once again, not sure what version) stored the
date as MMDDHHMMSS. The new
I'm having a problem with dates in php and mysql. I run a site that
promotes dated events and concerts and has the information for each
stored in a mysql database with the timestamp field.
Here is the function that checks the date of the event to ensure it is
between now and three weeks from now
From: rDubya [EMAIL PROTECTED]
My problem is that I have events dated for Sep 2007 and on, and yet
they all come up as being on Dec 7 to 9, 2006.. any ideas?
rDubya
How about having MySQL only return the events you are interested in?
SELECT yourEventFields FROM theTable
WHERE
TO_DAYS(
It's much better to use add_date instead of to_days since mysql isn't
smart enough to do it for you.
Such as:
SELECT yourEventFields FROM theTable
WHERE theEventDate BETWEEN now() AND date_add(now(), INTERVAL 21 DAYS;
This way mysql will calc the now() and date_add and will essentially
convert
Argh, make sure you add the closing paren for the date_add since I
forgot it.
Mike...
Mike Gohlke wrote:
It's much better to use add_date instead of to_days since mysql isn't
smart enough to do it for you.
Such as:
SELECT yourEventFields FROM theTable
WHERE theEventDate BETWEEN now() AND
Thanks for the help so far guys!!
Not helping though. I have the date contained in the database as timestamp
(-MM-DD HH:MM:SS). The problem is that not only is it not displaying
events, but if I alter my code so that it displays ALL events, it shows the
events for the last year, and those
Would someone help me with this ---
How do I get the results for 2 days before Easter Sunday from this ---
what do I have to do to my date statement to figure out Good Friday?
$good_Friday = date(Y-m-d, easter_date($current_year));
At 12:26 PM 1/21/2007, Denis L. Menezes wrote:
Dear friends.
I have a date field in mysql called event_end .
I want to run a query to find all records where the event_and is greater
than today's date. I have written the following code. It does not work.
Please point out the mistake.
$today =
Hello all,
I am developing a site in php implementing the concept of rss feeds. For
that i want to convert the standard date into RFC822 format.
If any one have idea about it, please help me.
Regards
Manoj
Manoj Singh wrote:
I am developing a site in php implementing the concept of rss feeds. For
that i want to convert the standard date into RFC822 format.
If any one have idea about it, please help me.
Go to http://php.net/date and search the page for RFC822. If you need
further help read the
PHP 4.4/MySQL 4.0
I am tying to convert a date to put into a database from a string (ie:
January, February) to a numeric value (ie: 01,02). I am taking the
value from a form, which is a drop down menu listing the months.
$sMonth1 = $_POST['Smonth']; returns the money selected from the form.
A simple associate array would work as well, although not quite as elegent.
$months_arr = array(January=01, February=02...);
-Original Message-
From: Mark Bomgardner [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 16, 2006 12:35 PM
To: Php-Db
Subject: [PHP-DB] Date Conversion
PHP 4.4/MySQL
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 16, 2006 1:29 PM
To: [EMAIL PROTECTED]; 'Php-Db'
Subject: RE: [PHP-DB] Date Conversion
A simple associate array would work as well, although not quite as elegent.
$months_arr = array(January=01, February=02...);
-Original Message-
From: Mark
This works perfect, Bastien!
Many thanks.
Gerry
On 3/13/06, Bastien Koert [EMAIL PROTECTED] wrote:
select * from table where date_format(date_field, '%Y-%m') = '2006-02'
bastien
From: Gerry Danen [EMAIL PROTECTED]
To: php-db@lists.php.net
CC: [EMAIL PROTECTED]
Subject: [PHP-DB] Date
select * from table where date_format(date_field, '%Y-%m') = '2006-02'
bastien
From: Gerry Danen [EMAIL PROTECTED]
To: php-db@lists.php.net
CC: [EMAIL PROTECTED]
Subject: [PHP-DB] Date question
Date: Sun, 12 Mar 2006 20:44:13 -0700
While I am rebuilding my crashed laptop (the machine
While I am rebuilding my crashed laptop (the machine that had all my
intelligence), I started thinking about a select statement I need.
I have log info in a table and want to extract it on a monthly basis. The
date field is in -mm-dd format. What's a good way to select those dates
that match
For example, you have table `logs` with `datelog` field and you want to
select dates
that match 2006-02. You can try this select statement:
SELECT * FROM `logs` WHERE MONTH(datelog)='02' and YEAR(datelog)='2006'
Hope that helps.
LJ Regalado
Gerry Danen wrote:
While I am rebuilding my crashed laptop (the machine that had all my
intelligence), I started thinking about a select statement I need.
I have log info in a table and want to extract it on a monthly basis. The
date field is in -mm-dd format. What's a good way to select
Would someone be able to help me with the DATE command syntax to know
what the date and time was 90 minutes ago? I am trying to assign these
values into two variables:
$date_90_minutes_ago
$time_90_minutes_ago
I am not sure how to handle midnight where if the time is 00:10:00
ninety minutes
?php
echo date(Y-m-d H:i:s,strtotime(90 minutes ago));
?
bastien
From: Ron Piggott (PHP) [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: PHP DB php-db@lists.php.net
Subject: [PHP-DB] Date Time 90 minutes ago
Date: Thu, 19 Jan 2006 16:57:33 -0500
Would someone be able to help me
$date_90_minutes_ago = date('m/d/Y',mktime()-(60*90));
$time_90_minutes_ago = date('h:i:s',mktime()-(60*90));
60 seconds * 90 minutes.
=C=
|
| Cal Evans
| http://www.calevans.com
|
| We get our best customers from referrals.
| We would appreciate you referring any of your
| friends or co-workers
-d H:i:s,strtotime(90 minutes ago));
?
bastien
From: Ron Piggott (PHP) [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: PHP DB php-db@lists.php.net
Subject: [PHP-DB] Date Time 90 minutes ago
Date: Thu, 19 Jan 2006 16:57:33 -0500
Would someone be able to help me with the DATE command syntax
I am trying to format the month portion of a date that I am trying to
pull from MySQL to be placed into a drop down menu to modify the date.
I have tried several ways and none seem to be working.
I am pulling the date out of MySQL with:
$sDate = explode(-, $row_events['Sdate']);
And then
You got the right idea, but you're making it more complicated than it needs to
be.
your $sDate after using explode() is going to contain an array. strtotime
doesn't take an array, it takes a string.
$monthName = date(F, strtotime($row_events['Sdate']));
$monthNumber = date(m,
Question:
I am trying to for the first time create a table with a column that is
defined as datetime
I wanted to populate that column with the date(r) command.
date(r) on my web site gives this response:
Fri, 9 Sep 2005 13:32:19 -0400
How may I manipulate date(r) to give a format which is
use timestamp column type and populate it by
$date = strtottime(date(r));
then when you want to display it
$date = date('r',$row['datefieldname']);
Bastien
From: Ron Piggott [EMAIL PROTECTED]
Reply-To: Ron Piggott [EMAIL PROTECTED]
To: PHP DB php-db@lists.php.net
Subject: [PHP-DB] DATE(r
You need to use:
date('Y-m-d H:i:s');
It's in the comments at:
http://www.php.net/date
Jordan
On Sep 9, 2005, at 12:52 PM, Ron Piggott wrote:
Question:
I am trying to for the first time create a table with a column that is
defined as datetime
I wanted to populate that column with the
Hi there everyone,
OK I'm using the following in my query to display entries in the LAST 3
days:
DATE_SUB(CURDATE(),INTERVAL 3 DAY) = ListingDate
But it doesn't seem to affect the results, the date format in my DB column
(ListingDate - datatype is Date) is 2000-00-00 as in year, month
I suppose there is a submit_time field in your DB table, so you could:
SELECT * FROM `tablename` WHERE `submit_time`=.lastdays(3)
lastdays() is a function you could create using mktime(),time(), and date()
On Tue, 22 Mar 2005 16:28:39 -0500, Chris Payne [EMAIL PROTECTED] wrote:
Hi there
To view the terms under which this email is distributed, please go to
http://disclaimer.leedsmet.ac.uk/email.htm
On 16 December 2004 06:00, neil wrote:
Hi
I am needing to convert a d/m/y date such as 30/11/2004 into the
format that mysql can use ie. 2004-11-20
If I try the following:
Hi
I am needing to convert a d/m/y date such as 30/11/2004 into the format that
mysql can use ie. 2004-11-20
If I try the following:
$testdate=30/11/2004;
echo date(Y-m-d, strtotime($testdate));
the result is - 2006-06-11
I can't find any other function apart from strtotime to do this.
Any
On Thursday 16 December 2004 14:00, neil wrote:
I am needing to convert a d/m/y date such as 30/11/2004 into the format
that mysql can use ie. 2004-11-20
If I try the following:
$testdate=30/11/2004;
echo date(Y-m-d, strtotime($testdate));
the result is - 2006-06-11
I can't find any
Thank you for all your help.
Among all the variations I found this to be the clearest:
list($d,$m,$y) = explode(/,$testdate);
$mysqldate = date(Y-m-d, mktime(0,0,0,$m,$d,$y));
But I also thought the use of split instead of explode so you could nominate
multiple delimiters was good.
eg.
I am having trouble converting a date from mm/dd/ to -mm-dd on a
user form. I know there was post about this, but I keep getting an
error message when I try to search the archives.
I have looked at the manual, but I am not finding what I am looking for.
Mark A. Bomgardner
How are you trying to convert the date?
bastien
From: Bomgardner, Mark A [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Date Question
Date: Wed, 27 Oct 2004 11:17:16 -0500
I am having trouble converting a date from mm/dd/ to -mm-dd on a
user form. I know there was post about
Bomgardner, Mark A wrote:
I am having trouble converting a date from mm/dd/ to -mm-dd on a
user form. I know there was post about this, but I keep getting an
error message when I try to search the archives.
I have looked at the manual, but I am not finding what I am looking for.
echo
Hi all,
can someone kindly point me to a resource that converts all kinds of possible date
inputs into MySQL format of -MM-DD?
example of formats to be converted includes:
d/m/yy
d/m/
d/mm/yy
d/mm/yyy
dd/mm/yy
dd/mm/yyy
d/mmm/yy
d/mmm/
dd/mmm/yy
dd/mmm/
yy - 2 digit
-Original Message-
From: Karen Resplendo
To: [EMAIL PROTECTED]
Sent: 02/07/04 19:36
Subject: [PHP-DB] Date problem: data is current as of yesterday
The database queries all the sources at night after everyone has gone
home. That means the data was current as of yesterday. This little
The database queries all the sources at night after everyone has gone home. That means
the data was current as of yesterday. This little snippet below returns yesterday's
date, except that the first day of the month returns 0 for the day. Now, I know why
this is happening, but I can't find out
accidentally replied only to karen.
The database queries all the sources at night after everyone has gone
home. That means the data was current as of yesterday. This little snippet
below returns yesterday's date, except that the first day of the month
returns 0 for the day. Now, I know why
How can I query a MySQL table to get the latest results from a date field?
Basically, I am inserting several records at a time at the end of each week.
I want to have a page that displays the results for the last week only.
The date format in the field is -MM-DD
How can I query a MySQL table to get the latest results from a date field?
Basically, I am inserting several records at a time at the end of each
week.
I want to have a page that displays the results for the last week only.
The date format in the field is -MM-DD
if you want the latest row
] [mailto:[EMAIL PROTECTED]
Sent: 25 June 2004 12:15
To: Tom Chubb
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Date Select
How can I query a MySQL table to get the latest results from a date field?
Basically, I am inserting several records at a time at the end of each
week.
I want
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
he started to type an email address it would do a sort of auto-complete
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
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('+
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',
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 to
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 I
Hi guys
I have a script which pulls a date(date default NULL) and a time (time default NULL)
from a MySQL database, now I would like to display that date and time in a 'pretty'
format.
I've been able to show the date nicely with the help of this:
Hi,
Is it possible to have a clause in a mysql SELECT statement? I would the
query to display the date except where it equals the default 000-00-00 to
display n/a or something similar.
For example SELECT DATE_FORMAT(B.Booking_End_Date, \%Y-%m-%d\) AS 'Booking
End Date' FROM Bookings (IF
: Thursday, April 15, 2004 7:44 PM
Subject: [PHP-DB] Date SELECT with IF
Hi,
Is it possible to have a clause in a mysql SELECT statement? I would the
query to display the date except where it equals the default 000-00-00 to
display n/a or something similar.
For example SELECT DATE_FORMAT
try the WHERE clause.
SELECT name, address, phone, date FROM usertable WHERE date =
'-00-00'
And please, look at the mysql documentation, or at least the tutorial.
--
Marcjon
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi People,
Need some assistance in the following scenario:-
Inserting a date into the database that is entered into a form by the site
visitor. - This is easy enough.
However I now need to use the same date that has been entered by the site
visitor add 35 days and then insert into another
Shannon Doyle wrote:
My question, how do I get the date entered into the form add 35days to it
and then include that into the same sql query as the first one. Or do I have
to use a second sql query? If the second query how would I get the date and
add 35days??
INSERT INTO table (date1, date2)
Hi guys
This might be slightly off topic but hopefully someone can help.
I have a field that is a varchar and I stored dates in it. But now I want to
change the type of the column to date, but I have a problem that the formats
differ:
my format: mm/dd/
mySQL format: -mm-dd
So can I
From: Angelo Zanetti [EMAIL PROTECTED]
This might be slightly off topic but hopefully someone can help.
I have a field that is a varchar and I stored dates in it. But now I want
to
change the type of the column to date, but I have a problem that the
formats
differ:
my format: mm/dd/
Hi Angelo
Yes you will have to reformat and he is something that may help you.
Hope it does
function dateCheckMysql ($date) {
list($dateDay, $dateMonth, $dateYear) = explode(/, $date);
if ((is_numeric($dateDay)) (is_numeric($dateMonth))
Brett King wrote:
Hi Angelo
Yes you will have to reformat and he is something that may help you.
Hope it does
function dateCheckMysql ($date) {
list($dateDay, $dateMonth, $dateYear) = explode(/, $date);
if ((is_numeric($dateDay)) (is_numeric($dateMonth))
Hi guys,
This might not be the best place for this but here goes.
I want to create a dropdown list with a date range of
--
SELECT name=bdate
OPTION value=11/02/2003 SELECTEDToday
OPTION value=11/01/2003Yesterday
OPTION
This might not be the best place for this but here goes.
You are correct. At the very least, you should probably be using the
general PHP list, not the database one.
I want to create a dropdown list with a date range of
Not to be obstinate, but it looks like you already have. But, assuming
have a look at the PEAR date package.
http://pear.php.net/package/Date
_
- Original Message -
From: OpenSource [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, November 02, 2003 11:13 PM
Subject: [PHP-DB] date function
Hi guys,
This might not be the best
1) Why do you send this to a DB list?
2) Try seeing the Date class of PEAR (PEAR::Date).
El Dom 02 Nov 2003 19:13, OpenSource escribió:
Hi guys,
This might not be the best place for this but here goes.
I want to create a dropdown list with a date range of
Sorry for what is probably going to be a late reply. I'm waiting to pick
someone up at the airport, and the plane was delayed, so I wanted to try my
hand at answering your question.
First I had to figure out what method you used to pick those dates in the
first place. It seems to be...
Greetings,
I have some php code that pulls from the mysql database. Here it is:
?php
mysql_connect(wildcat.osborneindustries.com, webuser,
webpass);
$mymonth = date('n');
$cyear = date('Y');
$query = SELECT name,hdate FROM emp2 where month(hdate)=$mymonth
order by hdate;
On Saturday 06 September 2003 06:01, Darryl wrote:
I have some php code that pulls from the mysql database. Here it is:
?php
mysql_connect(wildcat.osborneindustries.com, webuser,
webpass);
$mymonth = date('n');
$cyear = date('Y');
$query = SELECT name,hdate FROM
Hello,
I have a field in my mysql db wich is a timestamp with the format
mmddhhmmss
and I would like to display it like:
dd/mm/
how do I do that?
Thank you in advance,
Dani
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
I have a field in my mysql db wich is a timestamp with the format
mmddhhmmss
and I would like to display it like:
dd/mm/
http://www.mysql.com/doc/en/Date_and_time_functions.html#IDX1333
SELECT DATE_FORMAT(timestamp_col_name, '%d/%m/%Y') FROM table_name
--
PHP Database
Hi there everyone,
I use the below code to grab the current date, convert it to a unix timestamp to do
some bits then it's supposed to change the date back with the new values (IE: current
date - x amount of seconds) but it's not doing it correctly, it's probably DEAD
obvious to everyone as my
Pay It Forward
mailto:[EMAIL PROTECTED]
http://accessingram.com
-Original Message-
From: Chris Payne [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2003 3:45 AM
To: php
Subject: [PHP-DB] Date problem
Hi there everyone,
I use the below code to grab the current date, convert
Cheers for the help on my last auto inc prob..
I checked out phpmyadmin, and I'm loving it...! cheers all
Anyway,
I want to know how to store a date like this in a MySQL database:
date(F j, Y, g:i a);
Resulting in:
July 10, 2003, 3:39 am
But what do I need to set my
]
cc:
07/10/2003 11:02 AM Subject: [PHP-DB] date, and time
I have a simple need to reformat a variable coming in as $DatePick, brought
forward from a MySQL select in the format:
2003-11-18
I need to convert it to the format
November 18, 2003
I am trying to avoid having to mess with the MySQL select statement, as the
output is being passed
PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 11:23 PM
Subject: [PHP-DB] Date Formatting in PHP
I have a simple need to reformat a variable coming in as $DatePick,
brought
forward from a MySQL select in the format:
2003-11-18
I need to convert it to the format
November
At 05:23 PM 6/10/2003 -0400, David Shugarts wrote:
I have a simple need to reformat a variable coming in as $DatePick, brought
forward from a MySQL select in the format:
2003-11-18
I need to convert it to the format
November 18, 2003
try the dice-n-slice method. use substr and
I have a simple need to reformat a variable coming in as $DatePick,
brought
forward from a MySQL select in the format:
2003-11-18
I need to convert it to the format
November 18, 2003
$f_date = date('F d, Y',strtotime($db_date));
---John Holmes...
--
PHP Database Mailing List
This worked perfectly, is very simple for me to use, and I would never have
come upon it in 10,000 years of trying. Thanks!
Thanks also to everyone who offered ideas.
$f_date = date('F d, Y',strtotime($db_date));
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
a function to convert any date to ymd...
function datetoymd($date){
$dateymd = date('Y-m-d',$date);
return $dateymd;
}
this function when output gives me the date 1970-01-01 (date of the unix
timestamp start) so, ehm, why!?
cheers,
dave
function datetoymd($date){
$dateymd = date('Y-m-d',$date);
return $dateymd;
}
this function when output gives me the date 1970-01-01 (date of the unix
timestamp start) so, ehm, why!?
Because you're not passing a valid Unix timestamp or whatever your passing
is empty.
---John Holmes...
]
Verzonden: Tuesday, March 25, 2003 3:42 PM
Aan: [EMAIL PROTECTED]
Onderwerp: [PHP-DB] date to Y-M-D
a function to convert any date to ymd...
function datetoymd($date){
$dateymd = date('Y-m-d',$date);
return $dateymd;
}
this function when output gives me the date 1970-01-01 (date
Hi there everyone,
I have a form which displays 3 dropdowns, day, month and year, I have it displaying
the default of the dropdown for month no problem, but how can I get it to select the
current date (day) in the dropdown, but show 31 days nomatter how many days are in the
month? This is
I have a form which displays 3 dropdowns, day, month and year, I have
it
displaying the default of the dropdown for month no problem, but how
can I
get it to select the current date (day) in the dropdown, but show 31
days
nomatter how many days are in the month? This is important even
though
Hi there,
Thank you John, you are a lifesaver :-)
Chris
I have a form which displays 3 dropdowns, day, month and year, I have
it
displaying the default of the dropdown for month no problem, but how
can I
get it to select the current date (day) in the dropdown, but show 31
days
Sorry, I forgot to add the part at the bottom where I am calling the
function
=
?
function tips($weekstart){
$start = date('Ymd',strtotime($weekstart));
$query = SELECT * FROM Rota WHERE date = $start and date = ($start +
Professionals. Get your copy
today. http://www.phparch.com/
-Original Message-
From: David Rice [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 05, 2003 12:34 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] date functions (generates parse error)
Sorry, I forgot
I am looking for a way to take a date stored in a mysql database... and find
out the date seven days later.
how would i do this?!
cheers, dave
_
Chat online in real time with MSN Messenger http://messenger.msn.co.uk
--
PHP
1 - 100 of 241 matches
Mail list logo
