Questions tagged as 'select'

Tagged questions
1
answer

C # and mysql pagination

I have a form and a datagrid, in this form I am using a timer to do a search in mysql that fills the datasouce of the datagrid, so far everything is right. Now I need to limit the amount of search. For example: Select <campos> from tabel...
asked by 25.03.2015 / 13:22
1
answer

Error returning mysql database data

I made a normal form that returns the data in HTML. So I decided to insert images into the database and then gave a warning:    "Notice: Array to string conversion in   E: \ sites \ htdocs \ progdesenv2 \ admin \ acao.php on line 14 " As f...
asked by 23.04.2015 / 23:46
1
answer

Previous record Mysql

Hello, I'm trying to see the previous record in relation to the current record. I am using the following code SELECT * FROM Tabela WHERE compoid <"Contraband" ORDER BY compoid DESC LIMIT 1; But it is returning the blank table What's wron...
asked by 27.03.2015 / 22:38
1
answer

PHP return data from the database

I am trying to make a select in the database for testing, this select displays the user data after entering username and password. The error happens after select :    Warning: mysql_fetch_array () expects parameter 1 to be...
asked by 27.03.2015 / 12:11
1
answer

Displaying null results for mysql related tables

I need to create a relational query that returns records containing data from both the PERMISSION table and the USERS table. ALL PERMIT records must be displayed. When no records exist in the USER, NULL must be displayed. PERM_USU is used to rel...
asked by 18.02.2015 / 16:10
1
answer

How to do this SELECT (SQL Server 2008)?

To be honest, I do not even know how to start my question. So I'll first put the information I have. I have the following structure in my database. I need to do a SELECT that returns me the following: How can I achieve this?   ...
asked by 08.01.2015 / 21:09
1
answer

Relate sub query table with main query

SGDB: MySql. PROBLEM: I need to somehow relate the subquery (being table and field highlighted in Functional.codZone1) to the table "Zone", which is in the main query. Is there any way? "ZONE" table: Contains all Zones of the city. Tab...
asked by 15.04.2014 / 17:01
1
answer

Return values Select Multiple

Okay with all of you, I hope so. I have a question and I can not get on with my code. So let's go I have a multiple sign-up screen with the following data: <select class="form-control " id="restriction_details" name="restriction_detai...
asked by 28.10.2018 / 00:41
0
answers

Problems with Where

I'm using MariaDB and I have a problem in the WHERE clause of the bank. The query is inside Excel which brings me periods from the bank through the month filter. But I was asked to change for a period of time, but it is bringing me an empty...
asked by 14.12.2018 / 16:01
1
answer

More than one value in a variable id

Select: <div class="span2" class="checks" > <h4>BRANCO</h4> <img src= "/images/cor-05.jpg" width="57" height="27"> <input type="checkbox" data-id="TRANSPARENTE" name="cor5" value="BRANCO" /> <labe...
asked by 18.10.2018 / 14:00