• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: TRIM quotes from query

TRIM quotes from query 11 years 5 months ago #25839

  • donaldbmoore
  • donaldbmoore's Avatar
  • OFFLINE
  • Fresh Boarder
  • Where there is a will, there is a way!
  • Posts: 5
I am populating a text field with data from the user_profiles table. Unfortunately the values in that table are wrapped in quotes. I need to TRIM the quotes but am a bit unsure of how to do this...my code here to diplay valeu in field:

///<code>
$db =& JFactory::getDBO();
$db->setQuery("SELECT `profile_value` FROM `#_user_profiles` WHERE `profile_key` = 'profile.address1' AND `user_id` = '46'");
$result = $db->loadResult();
return $result;
//</code>

Result is:
"Address"

How do I trim the quotes?
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!