MySQL Select Row With Most Recent Date Per User

May 28, 2019 5:28 pm by ATS Staff

PHP MySQL Date Formats

May 23, 2019 4:46 pm by ATS Staff

PHP Date Comparison Checks Using strtotime Function

May 14, 2019 5:12 am by ATS Staff

PHP date comparison examples:

MySQL Update Column From Another Table Based On Where Clause

February 17, 2019 9:21 pm by ATS Staff

MySQL Decimals

February 3, 2019 9:56 pm by ATS Staff

Decimals can be added to a MySQL database by using the DECIMAL(M,D) data type. This requires 2 arguments. M is the maximum number of digits, ranging from 1 to 65. D is the number of decimal places available, ranging from 0 to 30. Note that […]

MySQL – Delete Duplicate Rows Keeping Latest

January 3, 2019 12:47 pm by ATS Staff

MySQL date to PHP date format

August 28, 2018 10:01 pm by ATS Staff

PHP Date Format List

Get file date time stamp using PHP in MySQL format

August 20, 2018 8:27 am by ATS Staff

HTML select and optgroup tags building using PHP and MySQL

December 24, 2016 11:11 pm by ATS Staff

Following is piece of code that shows HTML select and optgroup tags building using PHP and MySQL. The following example is based of the database structure in OpenCart. Also, it is assumed that the select tags are already part of existing HTML. And sample result […]