Creating new query
Page: 1
Recent posts in this topic
tranzparency
on Jul 29. 2006. 6:12 am
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?
Staff
Ilija Studen
on Jul 29. 2006. 11:00 pm
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:
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');
activeCollab Team Member
tranzparency
on Aug 2. 2006. 9:56 am
awesome.. I cheated and used an included adodb library just to get it running. Now I can port it over. thanks again. great work!
Topic is locked. If you have something important to say about issues discussed on this page please write at hi@a51dev.com.
