database value is not updating

[eluser]mehwish[/eluser]
hi can anyone tell me why it is happening when i put a variable in a database table (variable contains the string of this format 0000-00-00 00:00:00 but it is not a string like date month year and time is selected from calender and that selected date time is put in that variable ) it is still set to null i.e. 0000-00-00 00:00:00 whereas when i manually insert 2011:08:08 00:01:01 , the 0000-00-00 00:00:00 is replaced by that manual values. The database table field is of type timestamp.

[eluser]Aken[/eluser]
Check your SQL query by using $this->db->last_query() to show the last SQL command you used, paste it into phpMyAdmin or your appropriate database manager and see what errors it returns.

We can't help you without knowing at least an exact error that you're getting. So start there.

[eluser]mehwish[/eluser]
sorry where i have to write this query?