Unable to Insert Values into database

[surajkandukuri]

Hi,

 

  I have a sql UPDATE query

 

$update_query="update employee_positionheld SET `Position held 2`='$tempjobname' and `Start Date 2`='$startdate' where `EmployeeNumber`='$employeenumber'"; echo($update_query); echo("<br>"); mysql_query($update_query) or die("updation failed");

 

 

update_query prints :- update employee_positionheld SET `Position held 2`='Process Tech 1' and `Start Date2`='2009-11-05' where `EmployeeNumber`='34550'

 

    WHICH IS CORRECT as per my variables

 

BUT in the database

  Position held 2=0 and Start Date 2=0

 

I do not know what is happening here, please suggest me ... 

 

[rajivgonsalves]

are those your field names ?

 

instead of

 

mysql_query($update_query) or die("updation failed");

 

try

 

mysql_query($update_query) or die(mysql_error());

 

maybe it will help

 

[JJ2K]

Are the data types of the fields correct? They look like they could be set to an INT when they should be String/Date Time

 

 

[surajkandukuri]

I checked the data types they are VARCHAR(Position held)  and DATE(Start Date)

[JJ2K]

Try removing the single quotes from around the variables.

 

I also notice in some instances you are reffering to the date field as:

Start Date 2

and other times as:

Start Date2

 

w/ or w/o a space make sure it's correct.