prefix . "nb_data"; $rows_affected = $wpdb->insert( $table_name, array( 'status' => 0, 'timecreated' => current_time('mysql'), 'name' => $name, 'content' => $content, 'status' => $status, 'timebegin' => $begin, 'timeend' => $end ) ); } function nb_delete_entry($id) { global $wpdb; $table_name = $wpdb->prefix . "nb_data"; $wpdb->query('DELETE FROM ' . $table_name .' WHERE id = ' . $id); } function nb_change_status($id,$status) { global $wpdb; $table_name = $wpdb->prefix . "nb_data"; $wpdb->update( $table_name, array( 'status' => $status ), array( 'id' => $id)); } function nb_edit_entry($id) { global $wpdb; $table_name = $wpdb->prefix . "nb_data"; $wpdb->update( $table_name, array( 'status' => $_POST['nb_status'], 'timebegin' => $_POST['nb_timebegin'], 'timeend' => $_POST['nb_timeend'], 'name' => $_POST['nb_name'], 'content' => $_POST['nb_content']), array('id' => $id)); } // end database options ?>