I have a dating problem :(

[portrower8]

This script is supposed to send an email to me of everyone who has a birthday today (whatever today is). It works fairly well, except I can't get the date to show up right in the email.

In trying to figure out the problem I listed each variable in the email and it shows this:
Bob Evans
DOB: 1928-06-13
DOB2: Dec 31, 1969
DOB2: 06131928
Date: 13
Month: 06
Year: 1928

I'd like to have it say, "Birthday: June 13th, 1928" but instead it is showing Dec. 31, 1969 --- EVEN THOUGH THAT'S NOT THE BIRTHDAY! I don't know why, I ahve tried every comibition I can think of. Please help

<?php
include_once("dbconnect.php");
?>
<?
// Values you need set
$email = "[e-mail]";
$reminder_details = "";
$result = mysql_query( "SELECT * FROM ENTITY WHERE RIGHT(DOB,6) = RIGHT(CurDate(),6) ORDER BY DOB ASC" );

$nr = mysql_num_rows($result);
while( $row = mysql_fetch_array( $result ) )
{
$year = substr($row["DOB"], 0, 4);
$month = substr($row["DOB"], 5, 2);
$date = substr($row["DOB"], 8, 2);
$reminder_date = $month;
$reminder_date .=$date;
$reminder_date .=$year;

$reminder_date2 = date("M  j, Y",$row["DOBinS"]);
$reminder_details .= "".$row["NICKNAME"]." ".$row["LSTNAME"]."\n";
$reminder_details .= "DOB: ".$row["DOB"]."\n";
$reminder_details .= "DOB2: ".$reminder_date2."\n";
$reminder_details .= "DOB2: ".$reminder_date."\n";
$reminder_details .= "Date: ".$date."\n";
$reminder_details .= "Month: ".$month."\n";
$reminder_details .= "Year: ".$year."\n\n";
}
mysql_free_result( $result );
if( !empty( $nr ) )
{
// Send out Reminder mail
$mailheader = "From: Birthday Reminders<$email>\nX-Mailer: Reminder\nContent-Type: text/plain";
mail("$email","Birthday's Today","$reminder_details","$mailheader");
echo $reminder_details."\n\n";
}
?>

[Installer]

$reminder_date2 = date("M  j, Y",$row["DOBinS"]);

The lower range of a valid timestamp in Windows is Jan 1, 1970, so that may be the problem. Does it work with birthdays after that date?

[dewen]

$row["DOBinS"] in

$reminder_date2 = date("M j, Y",$row["DOBinS"]);

needs to be a unix timestamp

Also it has limitation depends on 32bit or 64bit

[portrower8]

Notice, the date that is spelled out is different than the date that is actually there --- I get this when I plug that in:

Bo Flubbers
DOB: 1951-01-14
DOB2: Dec 31, 1969
DOB2: 01141951
Date: 14
Month: 01

Year: 1951

with this script:

<?php
include_once("dbconnect.php");
?>
<?
// Values you need set
$number_of_days_before = 3;
$email = "[e-mail]";
$reminder_details = "";
//$todays_date = date("m/d/Y");
//$trigger_date = date("m/d/Y", time() - 60*60*24 * $number_of_days_before);

$result = mysql_query( "SELECT * FROM ENTITY WHERE RIGHT(DOB,6) = RIGHT(CurDate(),6) ORDER BY DOB ASC" );
//$result = mysql_query( "SELECT * FROM ENTITY WHERE MONTH(DOB) = $month AND DAYOFMONTH(DOB) = $day ORDER BY DOB ASC" );

$nr = mysql_num_rows($result);
while( $row = mysql_fetch_array( $result ) )
{
$year = substr($row["DOB"], 0, 4);
$month = substr($row["DOB"], 5, 2);
$date = substr($row["DOB"], 8, 2);
///////$dateofbirth = DATE_FORMAT("$row["DOB"]", b D Y);
//////$reminder_date = date("M j, Y", mktime ([0 [,0 [,0 $month,$date,$year, 0));
//////$reminder_date = date("M j, Y", mktime ($month,$date,$year));
$reminder_date = $month;
$reminder_date .=$date;
$reminder_date .=$year;

//$reminder_date2 = date("M  j, Y","$reminder_date, Y=$year2");
$reminder_date2 = date("M  j, Y",$row["DOBinS"]);
$reminder_details .= "".$row["NICKNAME"]." ".$row["LSTNAME"]."\n";
$reminder_details .= "DOB: ".$row["DOB"]."\n";
$reminder_details .= "DOB2: ".$reminder_date2."\n";
$reminder_details .= "DOB2: ".$reminder_date."\n";
$reminder_details .= "Date: ".$date."\n";
$reminder_details .= "Month: ".$month."\n";
$reminder_details .= "Year: ".$year."\n\n";
}
mysql_free_result( $result );
if( !empty( $nr ) )
{
// Send out Reminder mail
$mailheader = "From: Birthday Reminders<$email>\nX-Mailer: Reminder\nContent-Type: text/plain";
mail("$email","Birthday's Today","$reminder_details","$mailheader");
echo $reminder_details."\n\n";
}
?>

[xblue]

I'd also check out mysql's DATE_FORMAT() - it may get you the formatted date even easier, like

SELECT whatever, DATE_FORMAT(DOB, '%M %e, %Y') AS formatted_date FROM ...

for formatting options, see
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html

[portrower8]

SELECT whatever, DATE_FORMAT(DOB, '%M %e, %Y') AS formatted_date FROM

WORKED!

Working Script:

<?php
include_once("dbconnect.php");
?>
<?
// Values you need set
$number_of_days_before = 3;
$email = "[e-mail]";
$reminder_details = "";
//$todays_date = date("m/d/Y");
//$trigger_date = date("m/d/Y", time() - 60*60*24 * $number_of_days_before);

$result = mysql_query( "SELECT *, DATE_FORMAT(DOB, '%M %e, %Y') AS formatted_date FROM ENTITY WHERE RIGHT(DOB,6) = RIGHT(CurDate(),6) ORDER BY DOB ASC" );
//$result = mysql_query( "SELECT * FROM ENTITY WHERE MONTH(DOB) = $month AND DAYOFMONTH(DOB) = $day ORDER BY DOB ASC" );

$nr = mysql_num_rows($result);
while( $row = mysql_fetch_array( $result ) )
{
$year = substr($row["DOB"], 0, 4);
$month = substr($row["DOB"], 5, 2);
$date = substr($row["DOB"], 8, 2);
///////$dateofbirth = DATE_FORMAT("$row["DOB"]", b D Y);
//////$reminder_date = date("M j, Y", mktime ([0 [,0 [,0 $month,$date,$year, 0));
//////$reminder_date = date("M j, Y", mktime ($month,$date,$year));
$reminder_date = $month;
$reminder_date .=$date;
$reminder_date .=$year;

//$reminder_date2 = date("M  j, Y","$reminder_date, Y=$year2");
$reminder_date2 = date("M  j, Y",$row["DOBinS"]);
$reminder_details .= "".$row["NICKNAME"]." ".$row["LSTNAME"]."\n";
$reminder_details .= "Birthday: ".$row["formatted_date"]."\n\n";
}
mysql_free_result( $result );
if( !empty( $nr ) )
{
// Send out Reminder mail
$mailheader = "From: Birthday Reminders<$email>\nX-Mailer: Reminder\nContent-Type: text/plain";
mail("$email","Birthday's Today","$reminder_details","$mailheader");
echo $reminder_details."\n\n";
}
?>

THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[Installer]

And this:

$reminder_date2 = date("M  j, Y",$row["DOBinS"]);

will still give you Dec 31, 1969. One day before the Windows timestamp era, eh?

(Just to point out that

Notice, the date that is spelled out is different than the date that is actually there...

we noticed.)

[kburger]

I have a dating problem 🙁

deodorant might help 😉

Just kidding. I'd suggest checking out strtotime() along with date()