]>
src.bluestatic.org Git - isso.git/blob - BSDbAbstracter.php
c40c995657e818f0bce23e1ab8e2a55be879ee40
4 // $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");
5 $db ->select(array('f' => '*', 'm' => array('userid', 'email')))
6 ->from(array(TABLE_PREFIX
. 'foo' => 'f'))
7 ->join('left', 'members', 'm')
11 ->orderBy('userid', 'asc', 'm')
12 ->groupBy('userid', 'm')
16 // $db->query("SELECT * FROM users WHERE userid = 4");
17 $simple = $db->select('*')->from('users')->where(array('userid' => 4));
19 // $db->query("INSERT INTO posts (userid, email) VALUES (4, 'robert@sesek.com')");
20 $insert = $db->insert(TABLE_PREFIX
. 'posts', array(
22 'email' => 'robert@sesek.com'