insert a varchar data into mysql from a php date() function

[wev]

hi there..im new to php mysql and im having trouble inserting a string data to mysql from a php date() function.

 

 

here's my code:

 $year = date('Y');
echo $year;
  $insertSQL = sprintf("INSERT INTO tbl_elections (election_id=$year)");

  mysql_select_db($database_organizazone_db, $organizazone_db);
  $Result1 = mysql_query($insertSQL, $organizazone_db) or die(mysql_error());

 

when i try to output the $year variable on a webpage, it returns "2012"

but when i try to insert this data into my database table, it returns an error like this:

 

check the manual that corresponds to your MySQL server version for the right syntax to use near '=2012)'

 

is there a way to convert "2012" into a normal string data type?

[samshel]

you don't need to convert number to string to store in varchar. I think your insert statement needs to be updated:

try this:

 

INSERT INTO tbl_elections (election_id) values ($year)

[wev]

it said:

 

unexpected T_STRING in C:\xampp\htdocs\ABEOrgzone\elections\election.php

 

i've successfully inserted a data with similar code earlier..but the data it stored on my database was -1 instead of the year 2012

[samshel]

$year = date('Y');
echo $year;
  $insertSQL = "INSERT INTO tbl_elections (election_id) values ($year)";

  mysql_select_db($database_organizazone_db, $organizazone_db);
  $Result1 = mysql_query($insertSQL, $organizazone_db) or die(mysql_error());

[wev]

whew...

 

so that's just it?!

finally got it right..

thank's a lot!!