Nogen der kan se min SQL fejl?
if($update_kal) {echo "<span class=textred>Kalenderen er nu opdateret.</span><br><br>";
if(is_array($_REQUEST['check'])) {
$tempSQL = "DELETE * from kalander where month = '".$current_month."' && year = '".$year."'";
foreach($_REQUEST['check'] as $value) {
$tempSQL .= " && date != '".$value."'";
$query = mysql_query("SELECT * FROM kalender WHERE month = '$current_month' && year = '$year' && date = '$value'");
if(mysql_num_rows($query) == 0) {
mysql_query("insert into kalender (date, month, year) values ('$value','$current_month','$year')")or die (mysql_error());
}
mysql_query($tempSQL)or die (mysql_error());
}
}
}
den giver mig en fejl:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '* from kalander where month = '2' && year = '2005' && date != '
det er denne linje:
$tempSQL = "DELETE * from kalander where month = '".$current_month."' && year = '".$year."'";
