[PHP] HOW update time and date-fields to mysql....

2006-02-28 Thread Gustav Wiberg
Hi there guys! I have used a date-field and a time-field in a mysql-database. How should I update these fields through php? This is my code now (it works fine locally with data on a win-machine, but not on Linux at my webhotel - Time doesn't work at all) function safeQuote($value) { //

Re: [PHP] HOW update time and date-fields to mysql....

2006-02-28 Thread Robin Vickery
On 28/02/06, Gustav Wiberg [EMAIL PROTECTED] wrote: Hi there guys! I have used a date-field and a time-field in a mysql-database. How should I update these fields through php? This is my code now (it works fine locally with data on a win-machine, but not on Linux at my webhotel - Time

Re: [PHP] HOW update time and date-fields to mysql....

2006-02-28 Thread matt stone
On 2/28/06, Gustav Wiberg [EMAIL PROTECTED] wrote: Hi there guys! I have used a date-field and a time-field in a mysql-database. $sql = UPDATE tbforum SET; $sql .= question= . safeQuote($frmQuestion); $sql .= , insertDate=' . $dat . '; $sql .= , insertTime=' . time() . '; $sql .=