HOW update time and date-fields to mysql....

["Gustav Wiberg" <gustav@xxxxxxxxxxxxxx>]

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)
{
  // Stripslashes
  if (get_magic_quotes_gpc()) {
      $value = stripslashes($value);
  }
  // Quote if not integer
  if (!is_numeric($value)) {
      $value = "'" . mysql_real_escape_string($value) . "'";
  }

  return $value;
}


$sql = "UPDATE tbforum SET";
$sql .= " question=" . safeQuote($frmQuestion);
$sql .= ", insertDate='" . $dat . "'";
$sql .= ", insertTime='" . time() . "'";
$sql .= " WHERE IDForum=" . safeQuote($idForum);
$querys = mysql_query($sql);

/G 

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php