Date format on insert
Using the MySQLi server behaviors and the insert function, I have the date as a date picker in DW.
The small issue I'm scratching my head with is when the date is displayed on php page is DD-MM-YYY (Australian format). When the date inserts into the MYSQL Db is swings it to YYYY-MM-DD. As I'm trying to query using a URL variable, I get no results due to the difference.
I've been looking at trying to modify the $InsertQuery statement, so to switch formats on insert, but having no luck with it.
$InsertQuery->bindColumn("date", "s", "".((isset($_POST["date"]))?$_POST["date"]):"") ."", "WA_DEFAULT");
Any help would be great.