getDBO(); $poll_id = (int) $poll_id; $option_id = (int) $option_id; $query = 'UPDATE #__poll_data' . ' SET hits = hits + 1' . ' WHERE pollid = ' . (int) $poll_id . ' AND id = ' . (int) $option_id ; $db->setQuery( $query ); $db->query(); $query = 'UPDATE #__polls' . ' SET voters = voters + 1' . ' WHERE id = ' . (int) $poll_id ; $db->setQuery( $query ); $db->query(); $date =& JFactory::getDate(); $query = 'INSERT INTO #__poll_date' . ' SET date = ' . $db->Quote($date->toMySQL()) . ', vote_id = ' . (int) $option_id . ', poll_id = ' . (int) $poll_id ; $db->setQuery( $query ); $db->query(); } }