public static function add_act(Oedipus_Drama $drama, $name = NULL) { if ($name == NULL) { $name = Oedipus_DramaHelper::get_next_act_name_for_drama_id($drama->get_id()); } // Add Act to database $dbh = DB::m(); $drama_id = mysql_real_escape_string($drama->get_id(), $dbh); $name = mysql_real_escape_string($name, $dbh); $sql = <<<SQL INSERT INTO \toedipus_acts SET \tname = '{$name}', \tadded = NOW(), \tdrama_id = '{$drama_id}' SQL; // print_r($sql);exit; $result = mysql_query($sql, $dbh); $act_id = mysql_insert_id($dbh); $added = date(); $act = new Oedipus_Act($act_id, $act_name, $added, $drama_id); // print_r($act);exit; return $act; }