aC forum: Creating new query http://www.activecollab.com/forums/topic/306/ Recent posts on topic: Creating new query en-us Tue, 02 Dec 2008 18:15:49 CST http://www.activecollab.com/forums/post/1731/#post1731 http://www.activecollab.com/forums/post/1731/#post1731 Post #4 by tranzparency tranzparency Took 5 minutes to bring everything native. thanks.

]]> Wed, 02 Aug 2006 21:21:06 CDT http://www.activecollab.com/forums/post/1669/#post1669 http://www.activecollab.com/forums/post/1669/#post1669 Post #3 by tranzparency tranzparency awesome.. I cheated and used an included adodb library just to get it running. Now I can port it over. thanks again. great work!

]]> Wed, 02 Aug 2006 04:56:43 CDT http://www.activecollab.com/forums/post/1564/#post1564 http://www.activecollab.com/forums/post/1564/#post1564 Post #2 by Ilija Studen Ilija Studen Use DB::execute(), DB::executeAll() and DB::executeOne() functions.

First will return instance of DBResult class, second will return result as array and third first row of the result set. All of them can be used to prepare SQL:

$result = DB::execute('SELECT * FROM table WHERE `id` = ? AND `name` = ?', 12, 'name');

]]> Sat, 29 Jul 2006 18:00:26 CDT http://www.activecollab.com/forums/post/1549/#post1549 http://www.activecollab.com/forums/post/1549/#post1549 Post #1 by tranzparency tranzparency I'm adding another section to the dashboard and want to run some of my own queries for these pages. How can I do a query against the db class library and get a returned result?

]]> Sat, 29 Jul 2006 01:12:05 CDT