SQL syntax error

[Andrew R]

Hi

Anybody have any idea why I'm getting a SQL syntax error on this script SQL query?

[code]mysql_query("INSERT INTO messages (to, subject) VALUES ('$to', '$subject')") or die (mysql_error());[/code]

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, subject) VALUES ('Andrew', '456456',)' at line 1

Cheers

[suzzane2020]

try takin the space out between
messages  and (to, subject)
mysql_query("INSERT INTO messages(to, subject) VALUES ('$to', '$subject')") or die (mysql_error());

[HuggieBear]

You could try quoting the table names with back ticks (`) as [b]to[/b] is a [url=http://dev.mysql.com/doc/refman/4.1/en/reserved-words.html]reserved word[/url]. :D

[code]<?php
$sql = "INSERT INTO messages (`to`, `subject`) VALUES ('$to', '$subject')";
mysql_query($sql) or die ("Unable to run $sql: " . mysql_error());
?>[/code]

Regards
Huggie