How to Handle Duplicate Records by Deleting and Leaving Only One Record from Each Duplicate Records in MySQL Database

Have you ever got difficulty when handling the duplicate records in a table in MySQL database, where you want to delete the records and pretty leaves one record from each duplicate records? This usually happens in the table who did not have the primary key, so that it can cause to store the duplicate records. [...]

Share
[Read more...]

How to Know The Duplicate Records Based on The Same Value in a Field in MySQL Database

Have you ever wanted to know which record has duplicate content based on the same content in a field in MySQL database? This information will be get after you select the records and display them which one have the same content by groupping them by that field. Well, here is the script how you can [...]

Share
[Read more...]

Record per Page Limit in Client My Ticket Page in osTicket v1.6 RC5

Today I made another modification into osTicket version 1.6 RC5. It was about the page limit or displaying the ticket list page based on the maximum record per page. I wanted the ability for client to choose and also to change how many records per page will be displayed in the My Ticket page. After [...]

Share
[Read more...]

How to Add Custom Record Number in Table List of PodPages

I have just found the way how to add custom record number in the table list of PodPages in WordPress Pods CMS plugin. I optimize the PodPages feature for this purpose by using Bypassing Templates technique. Currently, up to Pods CMS version 1.7.3, you can only use the id field from the table as your [...]

Share
[Read more...]