I'm trying to put the date into a mysql row, and it is keeping the "00:00:00" which looks unprofessional. I've tried to get rid of it using str_replace() and just tried explode() and threw in the first element of the array, as you can see, still with no luck.
is mysql automatically appending the "00:00:00" to the end of the date? I don't understand why I can't get rid of it.
$date = date("Y-m-d");
$fdate = explode(" ",$date);
$result = mysql_query("INSERT INTO `clients` (`id`, `site`, `login`, `pass`, `date`, `ip`) VALUES (NULL , '".$cleanurl."', '".$username."', '".$password."', '".$fdate."', '".$_SERVER['REMOTE_ADDR']."');", $mysql);