[SOLVED] mysql error?

[forumnz]

I get this error:

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 'to, date, due_date, inv_number, ref, tax_incl) VALUES ('e878dca5c96oa38a815cf915' at line 1

 

And this is the code:

<?php
mysql_query("INSERT INTO table (hash_key, inv_key, to, date, due_date, inv_number, ref, tax_incl) VALUES ('$hk', '$ik', '$to', '$date', '$due', '$inv_num', '$ref', '$tax')")or die(mysql_error());
?>

 

What's wrong with it?

Thanks

[forumnz]

Is to reserved?

[DarkSuperHero]

what are some of the values you are trying to inser...what does $ik, $to, $date look like ?

[forumnz]

$ik is an md5 string (so 32 chars long)

$to is a text string (eg White House)

$date is text with slashes

 

The rest are similar, with $tax being from a list (value might be i or e)

 

What could it be?

[DarkSuperHero]

im sure this wont make much of a diff...but try....

<?php
mysql_query("INSERT INTO table (`hash_key`, `inv_key`, `to`, `date`, `due_date`, `inv_number`, `ref`, `tax_incl`) VALUES ('$hk', '$ik', '$to', '$date', '$due', '$inv_num', '$ref', '$tax')") or die(mysql_error());
?>

 

 

and your sure that your the table is named table, and it has the columns named: hash_key, inv_key, to, date, due_date, inv_number, ref, tax_incl ?

[forumnz]

No way! I didn't think that would work either.. but it did! Thanks heaps DarkSuperHero!!

 

Sam