Error: Query was empty

[Cooper94]

I get a error that is:

 

Error: Query was empty

 

Any help will be greatful, code is on the bottom and thank you again for your help guys!

 

<?php if(isset($_POST['contact'])) { 
include 'db.php';

$name = $_POST['name'];
$email = $_POST['email'];
$to = $_POST['to'];
$comments = $_POST['comments'];
$today = date("Y-m-d");

$name = mysql_real_escape_string($name);
$email = mysql_real_escape_string($email);
$to = mysql_real_escape_string($to);
$comments = mysql_real_escape_string($comments);

$sql=mysql_query("INSERT INTO contact (from,date,to,comments,email)
VALUES
('$name','$today','$to','$comments','$email')");


if (!mysql_query($sql,$connection))
  {
  die('Error: ' . mysql_error());
  }

}
?>

[Garethp]

Change

 

if (!mysql_query($sql,$connection))

 

To

 

if(!sql)

[Cooper94]

No error pops up but it still dosnt populate the database.

 

Thank You

[knsito]

I think you also need to wrap your field names with ` (grave accent - on the ~[tilda]

ie: `from`,`to`, ... etc

as these are keywords in sql

[Cooper94]

Thank you so much!