addTable('users'); $sql->addUpdate('username', 'john'); $update = array ( 'col_Username' => 'superman', 'col_Email' => 'superman@superheroes.com', 'id' => 1 ); //$sql->addUpdate($update); $sql->addRawUpdate('username', 'GETNAME()'); $insert = array ( 'col_Username' => "'superman'", 'col_Email' => 'GETMAIL()', 'id' => '1' ); $sql->addRawUpdate($insert); //$sql->removeRawUpdate(); $sql->addWhere('users', 'username', 'doug'); $sql->addWhere('users', 'id', 1); $sql->addWhere('users', 'id', 2); $sql->removeWhere('users', 'id'); $sql->setLimit(4); echo "
";
//print_r($sql->removeInsert());
echo "
"; echo "
";
print_r($sql->generateQuery());
echo "
"; ?>