Archive

Posts Tagged ‘record’

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

November 28th, 2009 Masino Sinaga No comments

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 do that. Read more…

  • Share/Bookmark

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

October 23rd, 2009 Masino Sinaga No comments

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 I modified, then there will be a new selection for page limit upon the ticket list on that page. When client choose a specific number from that selection or combobox, then the page will be automatically adjust to that specific number and updating the ticket list properly. So here is the code. Read more…

  • Share/Bookmark

How to Add Custom Record Number in Table List of PodPages

September 21st, 2009 Masino Sinaga 1 comment

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 record number column. Unfortunately, if you delete one or some of the record(s) from the table, then there will be missing number when you displaying this record number that you get from that id field. Besides that, if you search or filter the certain record, then the record number on the result will not continuously (there will be some missing number). So, here is the solution that I made to fix that problem, by adding the custom record number column based on the number of record in a page or in the table result. Read more…

  • Share/Bookmark