Help with mySQL INSERT INTO syntax error

[jcjst21]

Hello,

 

I receive an error when i submit my form for processing:

 

it says:

 

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 'group, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday) VALUES ('' at line 1

 

i can't figure out what's wrong with my code; it looks right to me:

 

<?php

$hcTime=$_POST['scheduleTime'];
$group=$_POST['groupToCall'];
$sunday=$_POST['Sunday'];
$monday=$_POST['Monday'];
$tuesday=$_POST['Tuesday'];
$wednesday=$_POST['Wednesday'];
$thursday=$_POST['Thursday'];
$friday=$_POST['Friday'];
$saturday=$_POST['Saturday'];

if(isset($_POST['scheduleTime']))
{

$sql="INSERT INTO HealthCenterSchedule(time, group, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday) VALUES ('$hcTime', '$group', '$sunday', '$monday', '$tuesday', '$wednesday', '$thursday', '$friday', '$saturday')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  echo $sql;
  }
$result = mysql_query("SELECT * FROM HealthCenterSchedule");
}

?>

 

Could someone take a look at this and see if I'm not seeing something.

 

Thanks,

jcjst21

[PFMaBiSmAd]

group is a reserved mysql keyword and should not be used as a column name.

[jcjst21]

Ooohhhh i'll fix that, and let you know what happens...

[jcjst21]

that was it!

 

Thank you so much!

 

jcjst21