Views

2 posts by 2 authors in: Forums > CMS Builder
Last Post: June 9, 2011   (RSS)

By mdegive - June 8, 2011

Could you guys support Views?

I want to be able to have a view that selects data from 2 tables with same columns.

I actually managed to do this by first creating a section in CMS with the columns that I wanted, then with phpmyadmin, I dropped the table and created a view to replace the table.

Works great except that CMS complained that my view was not a table, line 213 of lib/database_functions.php, once I removed the die statement, everything worked fine.

mysql_query("ALTER TABLE `".mysql_escape($mysqlTableName)."` $addFieldSQL") or die("Error adding fields to '$mysqlTableName', the error was:\n\n". htmlspecialchars(mysql_error()));

Would be a nice feature for a future release.