Search found 3 matches
- Sat Sep 08, 2007 10:26 pm
- Forum: CMSMS Core
- Topic: Adding a seperate sql query using addtional table in same database.
- Replies: 4
- Views: 1881
Re: Adding a seperate sql query using addtional table in same database.
Thank you very much...it worked like a charm....
- Sat Sep 08, 2007 7:36 pm
- Forum: CMSMS Core
- Topic: Adding a seperate sql query using addtional table in same database.
- Replies: 4
- Views: 1881
Re: Adding a seperate sql query using addtional table in same database.
Okay, this is what we have now... but it is still giving us a Fatal Error. Any other suggestions?? $db =& $gCms->GetDb(); $variables =& $gCms->variables; $q= "SELECT zen_categories_name FROM zen_categories_description ASC"; $dbresult = $db->Execute($q); if( !$dbresult ) { echo...
- Sat Sep 08, 2007 4:19 pm
- Forum: CMSMS Core
- Topic: Adding a seperate sql query using addtional table in same database.
- Replies: 4
- Views: 1881
Adding a seperate sql query using addtional table in same database.
I'm trying to pull a category list from the same database and I keep receiving an error. Here is what my smarty tag says: global $gCms; global $db; $vars = $gCms->variables; $q= "SELECT zen_categories_name FROM zen_categories_description ASC"; $dbresult = $db->Execute($q); if( !$dbresult ...