<?php
// $db->query("SELECT f.*, m.userid, m.email FROM foo AS f LEFT JOIN members AS m WHERE ??? ORDER BY m.userid ASC GROUP BY m.userid LIMIT 10, 100");
$db ->select(array('f' => '*', 'm' => array('userid', 'email')))
->from(array(TABLE_PREFIX . 'foo' => 'f'))
->join('left', 'members', 'm')
->where(array(
))
->orderBy('userid', 'asc', 'm')
->groupBy('userid', 'm')
->limit(10, 100);
// $db->query("SELECT * FROM users WHERE userid = 4");
$simple = $db->select('*')->from('users')->where(array('userid' => 4));
// $db->query("INSERT INTO posts (userid, email) VALUES (4, 'robert@sesek.com')");
$insert = $db->insert(TABLE_PREFIX . 'posts', array(
'userid' => 4,
'email' => 'robert@sesek.com'
));
?>