Custom SQL queries

Hi,

Are you trying to execute a query inside CMS Builder, or on a page that is using CMS Builder?

If you want to be able to test queries on your database from inside CMS Builder, we have a free MySQL Console plugin:
http://www.interactivetools.com/add-ons/detail.php?MySQL-Console-1011

If you can provide some more information about what you're trying to accomplish, we should be able to make some suggestions.

Hope this helps

I'm trying to execute a query on a page that is using CMS Builder.

I need to be able to merge 2 sql queries.
Merging 2 sql queries with array_merge() doesn't get me the same results as UNION.

Hi David,

There's no easy automated way to do that. CMSB's functions like getRecords() make it easy to do simple queries, but for a custom query with union it would be easier to just code it in straight PHP.

If the page loads viewer functions you'll already be connected to the database, so just call mysql_query(). You can use the global $TABLE_PREFIX to get CMSB's table prefix.

Hope that helps! Let me know any other questions.