Get json data in a page
$.getJSON("demo_ajax_json.js", function(result){
$.each(result, function(i, field){
$("div").append(field + " ");
});
});
MySQL date format DD/MM/YYYY select query?
You can use STR_TO_DATE() to convert your strings to MySQL date values and ORDER BY the result: ORDER BY STR_TO_DATE(datestring, '%d/%m/%Y') However, you would be wise to convert the column to the DATE data type instead of using strings.
Comments
Post a Comment