review this piece of code:
$values = $mysqli->query("select * from `my_table`");
while($value = $values->fetch_array()) {
print_array($value);
}
however one column having a date structure does this:
[8] => 2016-11-20
[date] => 2016-10-02 15:52:18
As you can see, 8 is having a different value as date however, they should be the same value because it is the same column in the same row. How can 'date' be changed?
the expected result = 2016-11-20 because that is the same value as stored in my database
info about my table: it has 8 different columns containing all kind of things that do work. the 8th field is named 'date' and has type 'DATE'
concluding: somehow my output is in datetime (wrong time and date though) while it should be DATE