MySQL functions

#VARS ?: = database prefix ?i = int ?s = string ?l = like ex: LIKE ?l => '%HERE' ?n = numeric ex: IN (?n) => array(1,2,3) ?a = string ex: IN (?a) => array('a','b','c') #INSERT $vars = array( 'name'=>'value', 'subname'=> $value ); $inserted_id = db_query('INSERT INTO ?:table ?e', $vars); #UPDATE $id = 1; $vars = array( 'name'=>'value', 'subname'=> $value ); db_query('UPDATE ?:table SET ?u WHERE id=?i', $vars, $id); #DELETE db_query('DELETE FROM ?:table WHERE id=?i', $id);