Tag Archives: mysql

Sort by specific order in MySQL query

If you want to sort the list by a certain order, such as a list of numbers from the beginning of 4,5,1, and then in ascending order, you can create a sort order by IF … Continue reading →

Local date format in PHP or MySQL

If locale is installed on the server then with PHP: For MySQL local date:

Calculate days between dates

Using php strtotime function difference between dates: Another way to set date with mktime function: Before PHP 5.1.0 negative timestamps were not supported. Under any known version of Windows date could be from 1970 to … Continue reading →