select

The simplest calculator in JavaScript. I can not understand why the code does not work, tell me, illiterate)

<script> function a() { var a1 = parseInt(document.getElementById('a1').value); ... tarea сols="20" rows="1" id="count" ></textarea> </p> </div> </body> </html>

How to join multiple rows in a table into one

There is an sql query select oi.order_item_name , oi.order_item_id, oim.meta_key ,oim.meta_value from idlf.wp_woocomm ... of the request is as follows How do I make _product_id, _qty, and _line_total appear on the same line for the same product?

Make a multiple selection in MySQL (nested SELECT)

There are two tables: Mutation table CREATE TABLE `mut_pat_012345_01012017` ( `chromosome` int(11) NOT NULL, `position ... the data belonging to different genes in such a response? I don't want to make multiple requests, it's very difficult. long.

How can I mark the desired checkbox by the data value of the selected select value when selecting select?

<select class="select" id="select"> <option value="all" data-size="all" class="subSelect">Все размеры< ... шой <input type="checkbox" data-size="big" class="checkbox" value="big"> </label><br> </div>

Select styling

Tell me how to make <select> like this: That is: 1. How do I add a changing element when clicked ( an arrow and a c ... lecting an item from the list)? 2. How do I increase the distance between <option>? Thank you very much for your help!

Decode in SQL. REQUEST (SELECT), DECODE

Hello, there is such a problem. I have two tables GOODS ID | NAME 1 | book 2 | notebook 3 | pen 4 ... eration on (goods.id = goods_operation.goods_id) group by name.oper_date; It doesn't work correctly! What should I do? Help

Multiple Select Processing

There is a simple multiple select: <select class="chosen" multiple="true" name="name[]"> <option value="1"& ... lt;option> tag? You need both values and text, in pairs Looking for a solution on php, or jquery, or within JQuery Chosen

Add an element using JS depending on select

Good time of day. It is necessary that, depending on the selected select, the text is added after the next field input. For e ... e="rub">Russia</option> <option value="doll">USA</option> </select> <input id="cash">

How to calculate the number of rows by grouping conditions

Good time of day, please tell me on this question: There is a table of the form: +-----------------------+ |id|user_id|poin ... of points = 3 (point_3) number of points = 1 (point_1) And they are ordered first by point_1, then point_3 and total_point.

MySQL nested queries have the same values

Good afternoon! There is a request SELECT COUNT(`week`.`id`) AS `cell1`, COUNT(`months`.`id`) AS `cell2` FROM (SELEC ... the same values in both cells, and if you remove everything that is associated with one of the columns, the value is correct

Why is the result of SELECTS with <= ALL and MIN different?

The database schema consists of four tables: Product(maker, model, type) PC(code, model, speed, ram, hd, cd, price) Lap ... , product WHERE printer.model = product.model AND color = 'y' AND price = (SELECT MIN(price) FROM printer WHERE color = 'y')

jQuery Selectric

I try to use Selectric to select the current (selected) element LI, but nothing happens, tell me who knows how to do it The ... ple of Selectric and ul, what I do here Here is the link to Selectric http://lcdsantos.github.io/jQuery-Selectric/index.html

Selecting multiple fields using DISTINCT

Help to form an sql query SELECT DISTINCT news FROM `comments` ORDER BY `id` DESC LIMIT 10 - this works, but only the news ... SELECT DISTINCT news,id,news,reg,name,comment,date_add FROM `comments` ORDER BY `id` DESC LIMIT 10 - this one doesn't work

MySQL output strings based on the IF/ELSE CASE query conditions

Let's say there is such a table _ _ test_if_else. It is necessary to output the lines corresponding to two conditions. In ... he table, with certain identifiers, but in the absence of the string 'en'(which is checked first), output the rows with 'ru'?

Bootstrap form select does not work correctly

Why didn't select display correctly? Although it is the same there and there. <div class='box box-theme box-form'> ... }); }); } else { splitter_form_wrapper.empty(); } }) }); </script>

Placeholder is not displayed on select2

Here is an example of how the plugin is initialized $(".select_3_wrapp select").select2({ "width": "100%", minim ... tion> <option>Option 4</option> </select> </div> Why is placeholder not displayed?

SELECT INSERT in Oracle using sequence nextval and group by

Good Morning, guys! I am trying to make a select insert in Oracle using a sequence in id, but it is giving error on account ... AL) is inappropriate here in the statement. *Action: Remove the sequence number. Has anyone been through this?

Limit and Offset for web paging in SQL Server

I am working with PHP and have about 8000 records currently in DB. As it is for a web page, I need to do a pagination to mak ... usuario.idCliente from usuario where usuario.login = 'julio') order by dataHora desc GIST How to proceed in this case?

Using select with SUM function()

I am developing a database for a small application. My bank has 3 tables: students, subjects and school report card, the la ... M() next to the Note3 column Note1 / Note2 / Note3 / average ??? It will be possible to do this I urgently need this help.