There has to be something stupid here but I can't find it....
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, to_name, url, date) VALUES ('test@test.com', 'test2@test.com' at line 2
$link = mysql_connect('server', 'user', 'password');
$select = mysql_select_db('database', $link);
if(!is_resource($link)) {
echo "Failed to connect to the server";
} elseif(!$select) {
echo "Failed to select database";
} else {
// Make a safe query
$query = sprintf("INSERT INTO table
(from, to, to_name, url, date)
VALUES ('%s', '%s', '%s', '%s', '%s')",
mysql_real_escape_string($e_title),
mysql_real_escape_string($e_start_date),
mysql_real_escape_string($e_end_date),
mysql_real_escape_string($e_address),
mysql_real_escape_string($today)
);
mysql_query($query, $link);
echo mysql_error();
if (mysql_affected_rows($link) > 0) {
echo "\n Inserted\n";
} else {
echo "Insert Failed\n";
}
