error in SQL syntax.

[gregorya]

This is the message I am getting whe i run te script below. Help!

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 '0' at line 1

<?
$day=date(j);
$month=date(n);
if($day=1)
{
include("../_includes/db_fns.php");
$db=db_connect();
$table=$month-1;
$sql="TRUNCATE TABLE $table";
mysql_query($sql) or die(mysql_error());
}

?>

What do I do to fix it?

[nemonoman]

Don't try to truncate table 0. What, do you have 12 tables, one for each month? what were you thinking?

Anyway, it that's what you've got, you want to truncate table 12, not table 0.

$table=$month-1;
if($table==0){$table=12;}

[gregorya]

this is what it tells me now

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 ''12'' at line 1

and this is the code

<?
$day=date(j);
$month=date(n);
if($day=1)
{
include("../_includes/db_fns.php");
$db=db_connect();
$table=$month-1;
if($table==0){$table=12;}
$sql = "TRUNCATE TABLE '$table'";
mysql_query($sql) or die(mysql_error());
}

?>

so whats wrong now?

P.S. what is a better idea for tables for the months. I am trying to build a calender feature for vaction rentals that can support multiple houses calendars?