i have dates stored in mysql using int(11), what are the query statements for sql so that i view the date in dateformat ,instead in all integer numbers?
If you stored the dates in a more appropriate field type (as dates) you'd be able to use any of MySQL's date and time functions (there's a whole chapter of them).
Since you're not, you'll probably have to do all the date processing in PHP.
