You have an error in your SQL syntax near ')' at line 41
I get an SQL error. can u find the problem?:
$selectrecurring=mysql_query("SELECT * FROM table1
WHERE flagrecurring=1
AND
unlimited LIKE '%yes%'
AND datestart <= curdate()") or die(report_bug(mysql_error().$PHP_SELF));
while($c=mysql_fetch_array($selectrecurring)) {
echo "recurloop<br><br>";
echo $c["recurnumber"]."<br>";
if($c["recurnumber"] > 1){
if($c["recurwhen"] == "monthsend"){
echo $c["recurwhen"]. "monthsend";
$recurinterval = "DAY";
$daymultiply = 30;
}
if($c["recurwhen"] == "daysend"){
echo $c["recurwhen"]."daysend";
$recurinterval = "DAY";
$daymultiply = 1;
}
if($c["recurwhen"] == "yearsend"){
echo $c["recurwhen"]."yearsend";
$recurinterval = "DAY";
$daymultiply = 365;
}
}else{
if($c["recurwhen"] == "monthsend"){
echo $c["recurwhen"]. "monthsend";
$recurinterval = "DAY";
$daymultiply = 30;
}
if($c["recurwhen"] == "daysend"){
echo $c["recurwhen"]."daysend";
$recurinterval = "DAY";
$daymultiply = 1;
}
if($c["recurwhen"] == "yearsend"){
echo $c["recurwhen"]."yearsend";
$recurinterval = "DAY";
$daymultiply = 365;
}
}
echo $c["recurnumber"] . '<br>';
echo $recurinterval . '<br>';
echo $daymultiply.'<br>';
echo $c["ID"] . '<br>';
$selectrecur2=mysql_query("SELECT DATE_ADD(datestart, INTERVAL ".($daymultiply * $c["recurnumber"])." DAY) as datestart,ID FROM table1
WHERE ID=".$c["ID"]." ") or die(report_bug(mysql_error().$PHP_SELF));
