syntax error

[mr.eVL]

Error in query: . 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 '' at line 1

Can someone explain to me what this error means? ???

 

 

LIKEWISE, IM FACING THIS ERROR TOO. I CANT UPDATE THE EDITED DATA.

 

Parse error: parse error, unexpected T_VARIABLE in C:\Program Files\xampp\htdocs\FYP\save_company_contacts.php on line 43

 

 

$query = "INSERT into company_contacts (company_name, company_contact, company_fax, company_email, company_address, company_description, contactor_name, contactor_num) VALUE ('$company_name', '$company_contact', '$company_fax', '$company_email', '$company_address', '$company_description', '$contactor_name', '$contactor_num')";

 

$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());

$submitted = true;

 

if($submitted)

{

$query = "UPDATE company_contacts set company_name='$company_name', company_contact='$company_contact', company_fax='$company_fax', company_email='$company_email', company_address='$company_address', company_description='$company_description', contactor_name='$contactor_name', contactor_num='$contactor_num' where id="$_GET['id'];

 

print "You will be re-directing soon!";

}

 

hope to hear from anyone soon. please!

[mr.eVL]

FORGET TO MENTION ONE THING.

 

EVEN IF I SUCCESSFULLY EDIT THE DATA, NOTHING SHOWN AND IT ADDS IT AS A NEW RECORD. WHY?

[woolyg]

Shouldn't you be using VALUES instead of 'VALUE'?

[fenway]

Shouldn't you be using VALUES instead of 'VALUE'?

Yes, and enough upper case.