HELP with INSERT! pls!

[TheStalker]

hi,

i am having trouble making an insert statment work. i know the database is conected etc because i have other staments working above the one i am having trouble with.

 

I have a large if esle stament that produces a total sorted in a variable called $total i am trying to insert the total into table accounts into collum WeelyCharge.

 

the code i have is as follows

 

$sql = "INSERT INTO accounts WeeklyCharge VALUES $total";

 

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

  {

  die('Error: ' . mysql_error());

  }

 

 

the error i seem to get is 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 'WeeklyCharge VALUES 18.2' at line 1

 

i have tried many diffrent ways of doing this and still cant get this insert to work. If anyone has any ideas that would be great

 

many thanks!

[premiso]

$sql = "INSERT INTO accounts (WeeklyCharge) VALUES ($total)";   

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

 

Try that.

[revraz]

Or

 

$sql = "INSERT INTO accounts (WeeklyCharge) VALUES ('$total')";