formfields
Joined: 01 Aug 2005 Posts: 465
|
Posted: Thu Nov 02, 2006 5:01 pm Post subject: |
|
|
Yes, this can be done just by using a MySQL function. For example, in our A+ Doctors example, you can capitalize a doctor's name by changing:
Code: |
define("FF_SELECT_CLAUSE", "doctor_name AS 'Doctor\'s Name', doctor_type AS 'Type of Doctor', insurance AS 'Types of Insurance Accepted'");
|
to
Code: |
define("FF_SELECT_CLAUSE", "UPPER(doctor_name) AS 'Doctor\'s Name', doctor_type AS 'Type of Doctor', insurance AS 'Types of Insurance Accepted'");
|
For more MySQL functions please see the documentation at http://www.mysql.com |
|