Best answeres tagged with select

3

answers

make a grouping select per year

I have a client field in it I need to make a count of how many customers were registered during the years 2016, 2017 and 2018. I was doing 3 select, and in each one I made a where dataCadastro > = 2016-01-01 and dataCadastro

asked by 31.01.2018 / 16:10

1

answer

Variable within the WHERE of a select

I have a variable that changes its content according to some user actions! I want to use this same variable inside a select, as follows! " Select * FROM tabele WHERE '$variável' " However, when I apply variável to Select it...

asked by 12.09.2016 / 03:28

1

answer

Select in two tables at the same time

asked by 07.12.2016 / 00:40

1

answer

Select like (2 different parameters)

I have a table with several cars, I need to pick only the ones I need. Example: goal fox parati kombi voyage I just want to get a goal and a kombi. I'm using the following command to get where I have the GOL value in my table ......

asked by 05.08.2015 / 19:39

3

answers

How to make more than one select in the same query in different DB tables?

The problem is as follows: I have the tables: Whatareforeignkeysinthefollowingtable: AndIneedtopullallthenamesofthe"connector_model", "connector_name" and "connector_type" columns and concatenate and echo an individual search. To do th...

asked by 06.03.2017 / 19:07

1

answer

How to select the value option returned with jQuery?

This variable data.uf returns me the acronym of the states. Ex ...: SC How do I loop with jQuery to select the data-acronym corresponding to the variable data.uf ? <select id="billing:region_id" name="billing[region_id]"> &...

asked by 12.04.2016 / 17:36

1

answer

Return amount of dependents per employee

I need to select the Plaque, Employee Name, and Dependent Amount for each Employee, but the result of that query is showing the number of dependents for the first Employee only, / p> Note: If you remove the WHERE clause, the query shows...

asked by 03.11.2018 / 20:36

2

answers

SQL Select return only one of several

I have two tables. "User" table that has 5 rows and 5 users. andthe"lease" table that has 20 records, using 5 foreign key ID of the user table WhenIusethisselectIdidselectu.nomefromusuarioujoinlocacaolonl.UsuarioId=u.idItreturnsmethef...

asked by 11.10.2018 / 10:02

2

answers

How to use multiple select in PHP form to query in MYSQL

I have a search with a select that can select more than one option, but I do not know how to do it so they search for all the selected options. Currently it does the search, it inserts the values in the url (I'm using GET ), but it can...

asked by 03.08.2018 / 14:51

1

answer

Highchart chart that imports the table values from the database

I have a system where students are enrolled in training classes, every registered student is "scheduled" to attend and when he / she attends, in addition he / What I want is to make a chart using Highcharts that compares the number of students...

asked by 13.09.2017 / 16:12

Questions tagged as 'select'