MySQL – Select First 2 Characters In Field Using Matching Pattern

MySQL – Select First 2 Characters In Field Using Matching Pattern

ByReid Walley

Problem: After running Easy Profile on Joomla to split up Joomla’s standard First-Name-and-Last-Name-all-on-one-line into separate First Name and Last Name fields, a bunch of User’s middle initials (eg: L.) are now at the beginning of the Last Name field. Here’s an example: Joomla’s standard signup only provides one field to enter a user’s name: John…

Create Membership Reports Using Fabrik

ByReid Walley

Goal: Generate 8 different monthly member reports for Califaep.org’s PayPlans-powered Joomla membership site. Solution: I’ve chosen Fabrik to query the database, display member content, filter info, and generate CSV files. Background: Califaep uses PayPlans to register members, and is using JomSocial’s custom fields to capture specific information during the registration process. Unfortunately, JomSocial’s custom fields data…