sql errorz *SOLVED*

[pouncer]

this is my class_functions.php

[code=php:0]
<?php

require_once("php_classes/class_db.php");

DB::Connect();

class Functions {
// Send a private message to a user.
function SendPrivateMessage($From, $To, $Subject, $Message) {
$privmessage = mysql_query("INSERT INTO private_messages (From, To, Subject, Message, Date_Sent) VALUES('$From', '$To', '$Subject', '$Message', now())") or die (mysql_error());
}

function RegistrationMessage() {
return "Hellogfdhgfdg";
}

}

?>
[/code]

This is my test.php

[code=php:0]
<?php
require_once('php_classes/class_functions.php');

$func = new Functions();
$msg = $func->RegistrationMessage();

$func->SendPrivateMessage("From-Mike", "To-John", "Subject-Welcome to the site", $msg);

?>
[/code]

on test.php though, i keep getting:

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, To, Subject, Message, Date_Sent) VALUES('From-Mike', 'To-J

[Barand]

I suggest to think up a different name for the "From" column.

FROM is a mysql reserved word as in "SELECT * FROM .... "

[pouncer]

ok i did that. i changed it to From_

i changed the code too.

still same error :s

[Barand]

Guess what, "TO" is also reserved

[pouncer]

Awesome, that nailed it. Thanks.