Help

[affordit]

Can someone tell me what I did wrong here

$query = "select * from test WHERE end_date = 'date('Y-m-d', strtotime('+ 5 days'))'";

[GingerRobot]

You've tried to use the php date() function in your string. You cannot do that. You must concatenate(join) the returned value of the function with the rest of the string:

 

<?php
$query = "select * from test WHERE end_date = '".date('Y-m-d', strtotime('+ 5 days'))."'";
?>

 

Alternatively, see the the mysql date and time functions

[kenrbnsn]

The function will not be run that way, try

<?php
$query = "select * from test WHERE end_date = '" . date('Y-m-d', strtotime('+ 5 days')) . "'";
?>

 

Ken

[affordit]

Still just get a blank page

[uniflare]

post your script, may not be the query

[affordit]

<?php
include("sharons_dbinfo.inc.php");
mysql_connect(mysql,$name,$password);
@mysql_select_db($database) or die( "Unable to select database"); 

//
// CHANGE QUERY TO GRAB THE ID
//
$query = "select * from test WHERE end_date = '" . date('Y-m-d', strtotime('+ 5 days')) . "'";
$result=mysql_query($query) or die (mysql_error());
$num=mysql_numrows($result); 

mysql_close();

$i=0;
while ($i < $num) {
$company=mysql_result($result,$i,"company");
$name=mysql_result($result,$i,"name");
$address=mysql_result($result,$i,"address");
$city=mysql_result($result,$i,"city");
$state=mysql_result($result,$i,"state");
$zip=mysql_result($result,$i,"zip");
$phone=mysql_result($result,$i,"phone");
$acct_num=mysql_result($result,$i,"acct_num");
$email=mysql_result($result,$i,"email");
$start_date=mysql_result($result,$i,"start_date");
$end_date=mysql_result($result,$i,"end_date");
$remind_date=mysql_result($result,$i,"remind");
$lost_password=mysql_result($result,$i,"lost_password");
$lost_password_answer=mysql_result($result,$i,"lost_password_answer");

$to = "$email"; 
$subject = "Your Subscription is about to expire"; 
$message="This mail was sent to you because your subscrption with Affordable Everything will expire on $end_date.\nYou can login to your account and use the link at the top of the page to renew your registration. If you let your subscription lapse, Your information and ads you have placed will be deleted and you will have to reregister and enter them all again.";
$headers = "From: subscriptions@affordit.us"; 
$sent = mail($to, $subject, $message, $headers) ; 
if($sent) 
{print "Your mail was sent successfully"; }
else 
{print "We encountered an error sending your mail"; }



++$i;
} 
?>

[uniflare]

try this tell us what it says:

 

<?php
include("sharons_dbinfo.inc.php");
mysql_connect(mysql,$name,$password) or die(mysql_error());
@mysql_select_db($database) or die( "Unable to select database"); 

//
// CHANGE QUERY TO GRAB THE ID
//
$query = "select * from test WHERE end_date = '" . date('Y-m-d', strtotime('+ 5 days')) . "'";
$result=mysql_query($query) or die (mysql_error());
$num=mysql_numrows($result); 

print_r(mysql_fetch_array($result));

mysql_close();

$i=0;
while ($i < $num) {
$company=mysql_result($result,$i,"company");
$name=mysql_result($result,$i,"name");
$address=mysql_result($result,$i,"address");
$city=mysql_result($result,$i,"city");
$state=mysql_result($result,$i,"state");
$zip=mysql_result($result,$i,"zip");
$phone=mysql_result($result,$i,"phone");
$acct_num=mysql_result($result,$i,"acct_num");
$email=mysql_result($result,$i,"email");
$start_date=mysql_result($result,$i,"start_date");
$end_date=mysql_result($result,$i,"end_date");
$remind_date=mysql_result($result,$i,"remind");
$lost_password=mysql_result($result,$i,"lost_password");
$lost_password_answer=mysql_result($result,$i,"lost_password_answer");

$to = "$email"; 
$subject = "Your Subscription is about to expire"; 
$message="This mail was sent to you because your subscrption with Affordable Everything will expire on $end_date.\nYou can login to your account and use the link at the top of the page to renew your registration. If you let your subscription lapse, Your information and ads you have placed will be deleted and you will have to reregister and enter them all again.";
$headers = "From: subscriptions@affordit.us"; 
$sent = mail($to, $subject, $message, $headers) ; 
if($sent) 
{print "Your mail was sent successfully"; }
else 
{print "We encountered an error sending your mail"; }



++$i;
} 
?>

[affordit]

Just a blank page

[uniflare]

try this tell us what it says (its either query or display_errors() is set off)

 

<?php
include("sharons_dbinfo.inc.php");
mysql_connect(mysql,$name,$password) or die(mysql_error());
@mysql_select_db($database) or die( "Unable to select database"); 

//
// CHANGE QUERY TO GRAB THE ID
//
$query = "select * from test";
$result=mysql_query($query) or die (mysql_error());
$num=mysql_numrows($result); 

print_r(mysql_fetch_array($result)); exit(); // debug lines

mysql_close();

$i=0;
while ($i < $num) {
$company=mysql_result($result,$i,"company");
$name=mysql_result($result,$i,"name");
$address=mysql_result($result,$i,"address");
$city=mysql_result($result,$i,"city");
$state=mysql_result($result,$i,"state");
$zip=mysql_result($result,$i,"zip");
$phone=mysql_result($result,$i,"phone");
$acct_num=mysql_result($result,$i,"acct_num");
$email=mysql_result($result,$i,"email");
$start_date=mysql_result($result,$i,"start_date");
$end_date=mysql_result($result,$i,"end_date");
$remind_date=mysql_result($result,$i,"remind");
$lost_password=mysql_result($result,$i,"lost_password");
$lost_password_answer=mysql_result($result,$i,"lost_password_answer");

$to = "$email"; 
$subject = "Your Subscription is about to expire"; 
$message="This mail was sent to you because your subscrption with Affordable Everything will expire on $end_date.\nYou can login to your account and use the link at the top of the page to renew your registration. If you let your subscription lapse, Your information and ads you have placed will be deleted and you will have to reregister and enter them all again.";
$headers = "From: subscriptions@affordit.us"; 
$sent = mail($to, $subject, $message, $headers) ; 
if($sent) 
{print "Your mail was sent successfully"; }
else 
{print "We encountered an error sending your mail"; }



++$i;
} 
?>

[affordit]

That pulled every record out

[uniflare]

your query is definetely the problem, could you give some examples of the date format in your mysql tables?

[affordit]

The field is set to DATE and the format is 0000-00-00

[EchoFool]

<?php
mysql_connect(mysql,$name,$password) or die(mysql_error());
@mysql_select_db($database) or die( "Unable to select database"); 

//
// CHANGE QUERY TO GRAB THE ID
//
$query = "select * from test";
$result=mysql_query($query) or die (mysql_error());
$num=mysql_num_rows($result); 

print_r(mysql_fetch_array($result)); exit(); // debug lines

mysql_close();

$i=0;
while ($i < $num) {
$company=mysql_result($result,$i,"company");
$name=mysql_result($result,$i,"name");
$address=mysql_result($result,$i,"address");
$city=mysql_result($result,$i,"city");
$state=mysql_result($result,$i,"state");
$zip=mysql_result($result,$i,"zip");
$phone=mysql_result($result,$i,"phone");
$acct_num=mysql_result($result,$i,"acct_num");
$email=mysql_result($result,$i,"email");
$start_date=mysql_result($result,$i,"start_date");
$end_date=mysql_result($result,$i,"end_date");
$remind_date=mysql_result($result,$i,"remind");
$lost_password=mysql_result($result,$i,"lost_password");
$lost_password_answer=mysql_result($result,$i,"lost_password_answer");

$to = "$email"; 
$subject = "Your Subscription is about to expire"; 
$message="This mail was sent to you because your subscrption with Affordable Everything will expire on $end_date.\nYou can login to your account and use the link at the top of the page to renew your registration. If you let your subscription lapse, Your information and ads you have placed will be deleted and you will have to reregister and enter them all again.";
$headers = "From: subscriptions@affordit.us"; 
$sent = mail($to, $subject, $message, $headers) ; 
if($sent) 
{print "Your mail was sent successfully"; }
else 
{print "We encountered an error sending your mail"; }



++$i;
} 
?>

 

Try that... you may want to put Error report ALL on ... just to get a bigger answer of errors.

[affordit]

The problem is with this line somewhere

$query = "select * from test WHERE end_date = '" . date('Y-m-d', strtotime('+ 5 days')) . "'";

[uniflare]

your query is not returning any MATCHES or RESULTS, there are no entries where end_date = 2008-02-23,

 

the code is fine, your query will return rows where the DATE/end_date field equals 5 days in the future... is this what your trying to do?

 

 

try this and copy and paste the result from the browser source exactly.

 

<?php
include("sharons_dbinfo.inc.php");
mysql_connect(mysql,$name,$password) or die(mysql_error());
@mysql_select_db($database) or die( "Unable to select database"); 

//
// CHANGE QUERY TO GRAB THE ID
//
$query = "select `end_date` from test LIMIT 50";
$result=mysql_query($query) or die (mysql_error());
$num=mysql_numrows($result); 

print_r(mysql_fetch_array($result)); exit();

mysql_close();

$i=0;
while ($i < $num) {
$company=mysql_result($result,$i,"company");
$name=mysql_result($result,$i,"name");
$address=mysql_result($result,$i,"address");
$city=mysql_result($result,$i,"city");
$state=mysql_result($result,$i,"state");
$zip=mysql_result($result,$i,"zip");
$phone=mysql_result($result,$i,"phone");
$acct_num=mysql_result($result,$i,"acct_num");
$email=mysql_result($result,$i,"email");
$start_date=mysql_result($result,$i,"start_date");
$end_date=mysql_result($result,$i,"end_date");
$remind_date=mysql_result($result,$i,"remind");
$lost_password=mysql_result($result,$i,"lost_password");
$lost_password_answer=mysql_result($result,$i,"lost_password_answer");

$to = "$email"; 
$subject = "Your Subscription is about to expire"; 
$message="This mail was sent to you because your subscrption with Affordable Everything will expire on $end_date.\nYou can login to your account and use the link at the top of the page to renew your registration. If you let your subscription lapse, Your information and ads you have placed will be deleted and you will have to reregister and enter them all again.";
$headers = "From: subscriptions@affordit.us"; 
$sent = mail($to, $subject, $message, $headers) ; 
if($sent) 
{print "Your mail was sent successfully"; }
else 
{print "We encountered an error sending your mail"; }



++$i;
} 
?>